https://bugs.documentfoundation.org/show_bug.cgi?id=117806
Bug ID: 117806
Summary: Support =IFERROR(1/0)
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
More and more in Google Sheets people use IFERROR with a single argument.
Google has a default value for the second argument of "" whereas LibreOffice
has no such default value. When people download a google document to their
computer and open it in LibreOffice the spreadsheet doesn't function properly.
LibreOffice will be able to successfully work with a higher percent of Google
Sheets documents if we make this change.
Even if you don't care about compatibility maybe you care about user
preference?
Clearly people like the default argument because otherwise they wouldn't use
it so often. The default argument is the common use-case and not having it
makes already complex formulas that much harder to understand.
Thank you.
PS: I understand ODF does not treat the second parameter as optional. I don't
see this as a compelling reason for us to not offer the user the option.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
