https://bugs.documentfoundation.org/show_bug.cgi?id=154484
Bug ID: 154484
Summary: FILEOPEN, FILESAVE, Array functions lost between saves
Product: LibreOffice
Version: 7.5.1.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
