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.
Eike, what's your opinion on this enhancement?
The same as in https://ask.libreoffice.org/en/question/155949/who-do-i-contact-to-fix-implement-iferror10-functionality/ 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.
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.
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.
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.