https://bugs.documentfoundation.org/show_bug.cgi?id=170201
Bug ID: 170201
Summary: FILESAVE: XLSX -> XLSX empty values in array formulas
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LibreOffice supports empty values in array formulas, but Excel doesn't, this
should be handled in XLSX export
Example:
we can insert "={1,,3}" as formula in LO but Excel throws a pop-up dialog
saying it's not valid formula.
When exporting array formulas containing empty values to XLSX, they are
exported without any change, because of this Excel fails to open the file.
Steps to Reproduce:
1. Open the attached XLSX file
2. Save it as XLSX
3. Resulting file can't be opened in Excel
Actual Results:
Excel opens the file without any problem
Expected Results:
Excel fails to open the file
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 22; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
