Formulas are not recognized by cell copied from xlsx

[JiriH]

Hello.
I copy pasted a sheet (formats and values only) form xlsx opened in the same LO. After that I tried to add a formula in some cells in that copy. Instead of result I could see just the formula, but no result. Even typing =e3 not work as expected. I checked all format settings, all “show formula” checkboxes, remove formating etc. Nothing.
I could workaround this by copy the formula, and paste it again as not formated text.

Next I made one field with working formula, and another with broken one. I checked content.xml, and inside working formula cell was tag with formula, and tag with result text. In the broken one was just tag for text containing literal formula but no formula tag or result.

I am using LO 6.1.6.3 (x64) on Win 10. Localisation cs-CZ.

I believe it is a bug, but maybe I am wrong. Is anybody having this issue too?

(file removed after closing)

[gabix]

Show the file. I cannot reproduce the described behavior with any XLSX file available to me.

[gabix]

In the shared file, I opened the TxKapotaz sheet and saw =C4 in C5 cell. As far as I understand, this is what represents a problem for you. In the cell properties (Ctrl + 1), I changed the category from Text (as it was) to All. Now, when I type in =C4, it works as a formula. Probably, you should set All for other problem cells.

[JiriH]

Thank you. It looks like a solution. I didn’t realize the formula inserted as a text stay as text even after cell formating change. A new formula woks in that cell though.