Hello everybody,
I’ve received a file made with OpenOffice Calc and when I open it in LibreOffice it gives strange error.
There is a formula from that type - “=$B5*IF(ISNA(H5);0;H5)” that multiply the empty cell “H5” with value in “B5” and it gives me #Value! error. What could be wrong?
When open on the computer with OpenOffice the result is 0.
I’ve made a small test with starting new file in Calc and then I multiplied value with empty cell and it gives correctly 0.
But in this file it could not handle empty cell formula.
any help will be welcome,
thank you
Just replace formula with “=IF(ISERR($B5H5);0;$B5H5)” IMHO, cell H5 is not empty, there is blank (space)
Tools > Options… > LibreOffice Calc > Formula > Detailed calculation settings section > select the Custom option and click the Details… button > set Treat empty string as zero to “True”.
thank you!
It is really a hidden option, I’ve tried to search it in the help, but with no success. Now it is working as expected.