Bug 154484 - FILEOPEN, FILESAVE, Array functions lost between saves
Summary: FILEOPEN, FILESAVE, Array functions lost between saves
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.1.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-03-30 15:14 UTC by Balázs Ágasvári
Modified: 2023-04-01 18:57 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Balázs Ágasvári 2023-03-30 15:14:09 UTC
Description:
I have a decent size spreadsheet  with 5 tables, with cells referenced and updated via SUMIF() Array functions examining conditions in specified rows in column headers. 'Array' is needed in order to function properly.
Pretty large table, so I use AutoFilter to only show the rows needed.
When I save the document with active filter, and reopen it, cells referncing cells in hidden rows on referenced sheets are showing error 504.
It is due to cell functions 'Array' notation not being preserved, they show up in normal function form, without the curly brackets notation.
The only way I find to "fix" is to go to Function Wizard, check the 'Array' checkbox in the lower left corner (which is unchecked) then copy over - again and again - the functions to every affected cells.
Having 5 sheets, 30 columns and nearly 700 rows on each sheet, it is becoming extremely annoying and time consuming.

Steps to Reproduce:
1.I'm having functions in thousands of cells, referencing data on another sheet, similar to the following:
{=SUMIFS($sheet2.$L501:$ANE501;MONTH($sheet2.$L$4:$ANE$4);"=2";YEAR($sheet2.$L$4:$ANE$4);"=2023";$sheet2.$L$6:$ANE$6;"<>x";$sheet2.$L$6:$ANE$6;"<>eb";$sheet2.$L$3:$ANE$3;"=innos")}
which supposed to be an Array function to work properly
2.with autoFilter on the referenced $sheet2, save the doument in xlsx
3.reopen document

Actual Results:
Array notations are gone

Expected Results:
Array notations preserved


Reproducible: Always


User Profile Reset: No

Additional Info:
might be a conflict with AutoFilter
Comment 1 raal 2023-04-01 18:57:45 UTC
Hello, can you prepare test file in .ods format? The we could easily reproduce the bug - save as .xlsx.