https://bugs.documentfoundation.org/show_bug.cgi?id=170876
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|FILEOPEN XLSX Imported |Worksheet named "sheet1" is |array formula result in |imported incorrectly from |attached file is Err:504 |xlsx files, producing | |failing formulas. IMPORT. | |STR comment 9 --- Comment #9 from ady <[email protected]> --- I can replicate the issue: 1. Create a new empty spreadsheet. You can use Calc itself. 2. Change the name of the worksheet to (exactly) "sheet1" (without quotation marks, all lowercase, no space character between the letters "sheet" and the number "1"). 3. Save the file using xlsx file format. 4. Close the xlsx file. 5. Load (aka, import) the xlsx file in Calc. Note that the worksheet label in Calc is shown differently than before, not as it was originally saved, "sheet1". So the problem has nothing to do with array formulas, nor anything else other than the specific "sheet1" name of the worksheet. Formulas (and/or anything else) that include explicit references to the original "sheet1" worksheet name will fail. When importing xlsx files, Calc mishandles this specific string ("sheet1") when it is the name of the worksheet. This happens with xlsx files, but not with xls nor ods files. I am changing the Summary of the report, from the current: "FILEOPEN XLSX Imported array formula result in attached file is Err:504" to: Worksheet named "sheet1" is imported incorrectly from xlsx files, producing failing formulas -- You are receiving this mail because: You are the assignee for the bug.
