https://bugs.documentfoundation.org/show_bug.cgi?id=168236
Bug ID: 168236
Summary: Spreadsheet: vstack() short parameters format failure
Product: LibreOffice
Version: 25.8.1.1 release
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
We've found an issue with some .xlsx documents that use VSTACK() function.
LibreOffice has support for this function, but only for full parameter format.
However, some other programs produce documents with short parameter format,
which results in Err:504 error.
Example:
Here's the short format that works in cloud Excel:
=VSTACK(Sheet1:Sheet4!A1:F2)
This formula will produce Err:504 in all related cells.
Here's the full format of the same formula:
=VSTACK(Sheet1!A1:F2; Sheet2!A1:F2; Sheet3!A1:F2; Sheet4!A1:F2)
This works fine in LibreOffice.
Steps to Reproduce:
There's a small simple synthetic file attached to the bug.
Download the file and open it in LibreOffce.
2. Switch to Sheet 5 — there will be Err:504 errors
3. Fix formula so it would use full parameters format: =VSTACK(Sheet1!A1:F2;
Sheet2!A1:F2; Sheet3!A1:F2; Sheet4!A1:F2) — now Sheet 5 contains data from all
other sheets.
Actual Results:
Sheet 5 contains Err:504 errors in cells from A1 to F8.
Expected Results:
Fix formula so it would use full parameters format: =VSTACK(Sheet1!A1:F2;
Sheet2!A1:F2; Sheet3!A1:F2; Sheet4!A1:F2)
Now Sheet 5 contains data from all other sheets.
Reproducible: Always
User Profile Reset: No
Additional Info:
I've tested it on my MacOS, but the same happens in linux as well.
--
You are receiving this mail because:
You are the assignee for the bug.
