Download it now!
Bug 117806 - Support =IFERROR(1/0)
Summary: Support =IFERROR(1/0)
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2018-05-25 16:36 UTC by William Deans
Modified: 2018-06-07 11:01 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description William Deans 2018-05-25 16:36:12 UTC
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.
Comment 1 Aron Budea 2018-05-28 06:15:36 UTC
Eike, what's your opinion on this enhancement?
Comment 2 Eike Rathke 2018-05-28 09:00:25 UTC
The same as in

So Google decided to implement the IFERROR() function differently than ~every other major spreadsheet application where for all the second argument is mandatory? Well, blame Google.
Comment 3 William Deans 2018-05-28 16:24:50 UTC
I wonder if Google blaming has somehow become more important than user experience?

In the end we must produce a product people want to use.    

I give up.
Comment 4 Eike Rathke 2018-05-29 09:34:32 UTC
Yes, and in the end we'd receive bugs that Excel or any other spreadsheet application couldn't read our IFERROR with only one parameter.
Comment 5 Wolfgang Jäger 2018-06-07 11:01:11 UTC
Anyway **specifications** must be regarded. If changes are needed they should be negociated, and all those offering software basically claiming compatibility must take part - or simply accept the results. 
Unspecified relevant functionality and disregarding specifications is a way to hell.  
However, commercial competitors will ignore this again and again as long as they can hope to get an advantage from it. This is not about making better software but about winning a war against competitors, in specific against the free and open ones.