[Libreoffice-bugs] [Bug 138222] Excel spreadsheet formulas become all #REFS (but the results still show)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138222

--- Comment #4 from m.a.riosv <miguelangelrv at libreoffice.org> ---
The original file has 0 as value in B8;B10;b11;b12;b13.
Opening the file with a compressor program, on OneMonth.xlsx\xl\worksheets open
sheet1.xml to see what are the formulas and values in cells.

Two options, doing a hard-recalc [Ctrl+Shif+F9] or setting up the option to
always recalculate excel files on load Menu/Tools/Options/LibreOffice
calc/Formula.

In my opinion not a bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201116/8be36e2a/attachment.htm>