[Libreoffice-bugs] [Bug 139910] New: 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

            Bug ID: 139910
           Summary: Calc when save-ing document as .xlsx messes up
                    formula, if save-ing as .xls works fine.
           Product: LibreOffice
           Version: 7.0.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: chaser.bruce at gmail.com

Description:
Example:
When using a formula to sum same cells (B12) on every sheet with formula
=SUM($'01 2020'.B12:$'12 2020'.B12) and afterwords saving the document as
.xlsx, on reopening the new .xlsx document the formula changes to =SUM('01
2020':$'12 2020'.B12:B12) and the field throws a #NAME? error and of course the
calculation does not work.

Steps to Reproduce:
1.Create 3 sheets with spaces like so Sheet 1, Sheet 2, Sheet 3
2.On sheets 2 and 3 enter some value into fields A1
3.On Sheet 1 under A1 enter formula =SUM($'Sheet 2'.A1:$'Sheet 3'.A1) and
calculate the SUM
4.Save file as .xlsx type and close the document.
5.Reopen the document and check the formula. It has now changed to =SUM('sheet
2':$'Sheet 3'.A1:A1)
6.The formula is now wrong and entering new values in A1 fields does nothing.

Actual Results:
The formula is changed and wrong and entering new values in A1 fields does
nothing.
This only happens if you save the document as .xlsx

Expected Results:
/


Reproducible: Always


User Profile Reset: Yes



Additional Info:
/

-- 
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/20210125/68e5caaa/attachment-0001.htm>