[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

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ming.v.hua at qq.com

--- Comment #1 from Ming Hua <ming.v.hua at qq.com> ---
I haven't tested your steps yet, but I'd like to point out that LibreOffice
Calc and Microsoft Excel use different notations for sheets and cells in
formula, and it's well documented in LO Help:
https://help.libreoffice.org/7.0/en-US/text/shared/optionen/01060900.html

In short, Calc uses "$Sheet1.A1" by default ($ for sheet name, . between sheet
name and cell name), while Excel uses "Sheet1!A1" by default (no symbol for
sheet name, ! between sheet name and cell name).

So if you file is in Excel's XLSX or XLS format, and interoperability between
Calc and Excel is important, you should consider using Excel's notations
everywhere.  In Calc this is configured in Tools > Options > LibreOffice Calc >
Formula.

-- 
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/20210126/e36f555c/attachment.htm>