Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

I'm using version on Windows 7, and this past week imported a spreadsheet from GoogleDocs. The person I got it from exported it from GoogleDocs into .ods format, and when I got it I found a lot of cells with error messages.

The cause of the error messages was a lot of "=_xlfn.iferror((xxx))" entries. I searched LO help and found no reference to an IFERROR function, so I thought that function did not exist in LO. So I spent hours replacing all those "=_xlfn.iferror((xxx))" entries with "if(iserror(xxx),0,xxx)" entries.

Finally done with that, I went to LO Bugzilla to create an enhancement request and found out that IFERROR is in LO after all! And it's apparently been there since v4.0. I even found a bug report:

The report was created in May 2013 asking for IFERROR and IFNA to be added to the help files, but it appears no development folks have taken notice of the request yet. So I added my own comment to the 4 others already there, and decided to add a comment here on the list in hopes that someone who knows how will see it and get something going.

Tim Deaton

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.