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.