https://bugs.documentfoundation.org/show_bug.cgi?id=163554
Bug ID: 163554
Summary: CALC error saving as an excel file
Product: LibreOffice
Version: 24.8.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Sum formula changes across multiple tabs after saving to xlsx format.
Steps to Reproduce:
1.Create a function that sums a cell across tabs
2.Save spreadsheet as xlsx type file (not an issue if saving as an ODS file)
3.Reopened in CALC - formula changed -
Also opened in MS EXCEL and formula was incorrect.
Actual Results:
In my case, cell formula changed from:
=SUM('Time (PN8181)'.F11:$'Time (Misc) - Last'.F11)
to:
=SUM('time (pn8181)':$'Time (Misc) - Last'.F11:F11)
Sum shows as "0" - Does not show error even though formula is incorrect, unless
cell edited.
Expected Results:
No formula change
Reproducible: Always
User Profile Reset: No
Additional Info:
I upgraded to this version. Bug was same on V24.4.x.x version as well.
I have a copy of the spreadsheet if needed.
--
You are receiving this mail because:
You are the assignee for the bug.
