https://bugs.documentfoundation.org/show_bug.cgi?id=159039
Bug ID: 159039
Summary: Error:504 in Summary Sheet when Opening XLSX File in
LibreOffice Calc
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have an XLSX file containing client data, where each client has their own
sheet. There is also a summary sheet that compiles all inputs made (e.g.,
male/female, country of origin, etc.). When I open the file in Excel 2016, the
summary sheet counts and displays the data correctly without any errors.
However, when I open the same file with the latest version of LibreOffice Calc
(Windows and Linux) AND strangely the latest version of Microsoft Excel, I
encounter an error in the summary sheet.
If it helps I also can submit the file.
Steps to Reproduce:
1. Open the specific xlsx file in LibreOffice Calc.
2. Navigate to the summary sheet.
3. Check the values/cells that are supposed to count data from other sheets.
Actual Results:
An error message "Error:504" is displayed when viewing the summary sheet in
LibreOffice Calc.
Expected Results:
The summary sheet should correctly count and display data from other sheets
without any errors, similar to how it works in Excel 2016.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Flatpak
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
