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: users+unsubscribe@global.libreoffice.org
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
Context
- [libreoffice-users] No "help" exists for IFERROR function · Tim Deaton
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.