Hi guy,
I have a problem, when i open my file .xlsx by Libre Office value in cell auto format = 0 instead of correct value. But, it’s right with other application such as : WPs,MS Office…
Please help me!
Thank you.
Do your “writer”, “common” and “base” tags have anything to do with your question?
If this is not the case, please delete these tags, they only irritate. Thank you.
However, the specification of your used LibreOffice version and the operating system would be very helpful.
To help you further, please upload a reduced and anonymized sample document in which the problem is present. Thank you.
How to upload:
Click on the three dots ( … ) directly below your initial question.
Then click the pencil icon to edit your question.
In question edit mode, select the upload icon.
Select your file and click the Upload button.
Thank you.
May it be your .xlsx is generated by some tool that does not calculate formulas but writes result 0 to their cells, and after having loaded it in LibreOffice recalculating it with Shift+Ctrl+F9 the expected values instead of 0 are displayed? If so and you need it more often, you can force recalculation of .xlsx documents under Tools → Options → Calc → Formula, Recalculation on File Load, Excel 2007 and newer: either Always recalculate or Prompt user.
Thank you so much for your help. I solved my problem.