In LibreOffice Calc formula "=" work not as expected with empty cells. When I try to copy value from empty (blank) cell via simple formula "=A1", it show zero number in cell instead of zero cell. How to reproduce: fill 3 cells in A1-A3 range with values: 0 [leave cell empty] 1 And in 3 cells of B column fill simple formulas "=A1", "=A2" and "=A3". After this you will see in B2 cell "0" value instead of empty cell, here is screenshot: http://i.imgur.com/FFpo4Dv.png Based on the logic, value of B2 cell must be "", so blank empty cell. Why LibreOffice Calc show zero? And how I can got expected result? I have found workaround via =IF(A2="";"";A2) but this looks like ugly hack instead of good solution. I know about option Tools-->Options-->Openoffice Calc-->View. Uncheck "Display Zero Values". But this option will hide all zeros in all cells, this is wrong. I need to hide only zeros from copied empty cells, and leave zeros on cells filled via zero manually. If this is not a bug, but new feature - can you provide and describe in Documentation simple way how to easily solve descibed problem with copying empty cell values to another cell as empty result instead of 0? Thanks.
Hello Murz, you can use format of cell #,##0.00;[RED]-#,##0.00;"" or make formula =IF((A1)=0;"";A1) Wiki is here, please add notes https://help.libreoffice.org/Calc/Handling_of_Empty_Cells