Calc will not perform calculations! Formulas do not work!

No matter what I type, format cell …nothing helps. Please what to do?

Thank you C:\fakepath\Poludecu od ovogaaaa(1).xls

All the following is necessary to make formulas work in an .XLSX file created in Microsoft Excel 2019, then opened in my LibreOffice Calc 7.2.0.4 x64 :

1- Open the .XLSX file in Calc.
2- Un-tick the Show Formula setting in Calc.
3- Save file as .ODS.
4- Close the .XLSX file and open the .ODS file just saved.

Just step 1 is not enough, unless you are already using an .ODS file.

It kind of defeats the purpose of Libre Office as an alternative to Microsoft Office if Libre Office cannot directly work with Microsoft Office documents in their native formats.

Attach an Excel 2019 created .xlsx file to prove your statement (Can’t imagine the noise here, if that’s true for any such file).

Here is the original XLSX file created in Excel 2019, and the ODS file after solving the problem.
Enrico 2021 PC.ods (14.1 KB)
Enrico 2021 PC.xlsx (10.2 KB)

… the .xlsx opens without the need to 2- Un-tick the Show Formula setting in Calc in my case (as far as I can see the only formula is in C15). The only thing is, that column C is not wide enough to show the result and hence you need to change column width.

Yes, that is the only formula. This is how the XLSX file displays on my PC when opened in Calc (it shows ### instead of the total amount of the column).

This got nothing to do with option Show Formula but with Column Width - see my previous comment.
ChangeCOlWidth-2021-08-24 18-08

Yes, that is correct. Apparently the column width does not carry over from Excel to Calc. At least now I know that formulas do work in Calc. It is also displayed slightly different in the two programs when column width is insufficient, ### (three #) in Calc, a whole row of # in Excel.
Clip0005

It carries over from Excel to Calc - as much as possible for an idiotic file format that stores column width in units of “average character width” based on default font, instead of using normal units like mm. That’s what XLS and XLSX do; and LibreOffice tries to calculate the width based on that loosely-specified algorithm, and obviously does it a bit differently compared to Excel. And if there were no specific font on the machine that was used as default in the file, the result would be even worse.

1 Like

Hello,

deactivate option View -> [ ] Show Formula

image description

Recommendation:

Use native ODF format .ods when using LibreOffice Calc as your standard format for saving document. Do not switch to foreign format forth and back.

Hope that helps.

THANK YOU!!!
Two days I’m searching for mistake…THANK YOU!!! :slight_smile: