https://bugs.documentfoundation.org/show_bug.cgi?id=139910
--- Comment #2 from [email protected] ---
Good day,
I am aware of different notations but we mostly use Libre Office for company
employees.
I also tested the document in Excel and the xls one, shows the correct
notations which are used by Excel but if I open the xlsx one the formula looks
like this =SUM('01 2020':'12 2020'!B12:B12)
So it has added to extra ' signs and the formula is now wrong.
The correct one should be =SUM('01 2020:12 2020'!B12:B12)
I can send you a video or the files themselves if you would like
--
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