https://bugs.documentfoundation.org/show_bug.cgi?id=139910
Ming Hua <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #1 from Ming Hua <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
