[Libreoffice-bugs] [Bug 139910] Calc when save-ing document as .xlsx messes up formula, if save-ing as .xls works fine.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Ming Hua <ming.v.hua at qq.com> ---
Created attachment 169460
  --> https://bugs.documentfoundation.org/attachment.cgi?id=169460&action=edit
Sample file

Here is a sample file prepared with the StR in comment #0.

Open the file, save as "Excel 2007-365 (.xlsx)" format.  Close and open the
.xlsx file again, the formula in $'Sheet 1'.A1 cell becomes "=SUM('sheet
2':$'Sheet 3'.A1:A1)", and gives #NAME? error (Re-calculate/F9 may be
necessary).

-- 
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/20210203/aec510fd/attachment-0001.htm>