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)