[Libreoffice-bugs] [Bug 117806] New: Support =IFERROR(1/0)

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: william.deans at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180525/f16b8f1e/attachment.html>