how to display blank cell in place of zero result
I have many files that used a very simple formula, for example:
where "" should leave the cell blank if the sum was less than 1, as it did in OO. However LibreOffice returned #VALUE in all cells with this formula.
The laborious workaround was to replace all "" in formulas, with 0 using Edit > Replace All.
I now have spreadsheets full of zeros where there were nice blank spaces previously.I hope that there is a fix for this