I'm using version 4.3.5.2 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:
https://bugs.documentfoundation.org/show_bug.cgi?id=64773
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.
Thanks,
Tim Deaton
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
