Calc XLSX shows "=FALSE()" and MS Office shows "FALSE"


Calc opens a XLSX, showing “=FALSE()” in the same cells every other XLSX editor (including MS Office) shows “FALSO” (my Windows 10 is in English configured to the Portuguese formats).

Seems like Calc forgot to recalculate the formulas when opening the XLSX file.

Shared on my Google Drive:

(you need to download, Google shows it fine)

The XLSX was not created or edited on Google. I’m using Google for upload purposes only.
I tested the uploaded file an Google didn’t modify it in any way.

LO About box:
Version: (x64)
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 8; OS: Windows 10.0; UI render: default;
Locale: pt-PT (pt_PT); Calc: group threaded

Google apps are notorious in creating bad docs, where they mark cells as “text” where there’s other data. We add workarounds for that from time to time, but it’s a pain to break code to allow another broken app to continue producing shit.

I shared on Google Drive, but it’s just a coincidence (I should have chosen other file sharing service).
The XLSX was created elsewhere.

My point is that it’s a well formatted XLSX (AFAIK) that displays well in every other spreadsheet except LibreOffice Calc.

Please try opening id after downloading from your share. Because I did, and it shows 0 for me with Now I don’t know if that’s an artifact of your sharing (when Google could modify it somehow), or a difference in our LO settings/versions, or …

By the way, you failed to tell your LO/OS version.


Sometime last week when checking the LO settings, I activated the
Options => LibreOffice Calc => View => Formulas
… and I totally forgot about it.
I’m dumb.

Sorry for wasting your time.