https://bugs.documentfoundation.org/show_bug.cgi?id=171017
--- Comment #4 from ady <[email protected]> --- I am not sure what exactly is the report about. For items 1, 2 and 3, we could correct the formula and they should go away. The array formula in the range S2:Y2 starts with: =IF($Z2=0; 0; ... Since you are using an array formula that should result in (1 row and) 7 columns, that "true" statement for the IF() (that currently is just one "zero" value) should rather be an array of zeros; more precisely 1 row x 7 columns of zeros. After entering the corrected formula with CSE, select again the range S2:Y2 and fill down the formula (in the attachment, up to row 282). That should take care of items 1, 2 and 3. For item 4, it seems that you are reporting that the undo does not correctly and completely restore the array formulas as they were before deleting (and shifting up) the range S4:AE4. Is that it? Am I understanding correctly? -- You are receiving this mail because: You are the assignee for the bug.
