Cells always display 0.00 even with non-zero data

I’ve received and xlsx document and when I open the file all cells show 0.00 when they have non-zero values in them.


In the picture you can see the cells show 0.00 but in the Input Line there is a value.

I’ve talked with the person who provided the file and they said enabling Editing Mode in Excel will show the values in the cells. On my system I’ve tried toggling Edit>Edit Mode; this has had no affect.
I’ve tried toggling Options>LibreOffice Calc>General>“Press enter to switch to edit mode”; this did not fix the issue.
I’ve tried toggling Options>LibreOffice Calc>View>“Zero Values”; this did not fix the issue.

Any other things I could try to fix this?

I guess it has an odd format like #,,. Try formatting the cells differently, I would suggest as 0.00 or #,##0.00.
Select the cells, click Format > Cells and in the Numbers tab select Number and -1234.57, click OK

As your shown cell shows a (unnecessary) formula, have you tried to recalculate the sheet?

Please upload a file with samples of such cells.

This was close. Recalculate will fix whatever cell is selected. Recalculate Hard does the entire sheet.
Data>Calculate>Recalculate Hard.

Which indicates, that for the document, automatic calculation is turned off.

Or it was a generated document and the results were written as 0 instead of the calculated values and when opening such document it is not recalculated unless forced and displayed as is.

Might also be a recalc flag was set for such but that so far isn’t evaluated, tdf#144819, though there also exist generated documents without recalc flag.

1 Like