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
Hello, can you prepare test file in .ods format? The we could easily reproduce the bug - save as .xlsx.