[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 #2 from chaser.bruce at gmail.com ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210126/0aa286a1/attachment.htm>