https://bugs.documentfoundation.org/show_bug.cgi?id=171017
--- Comment #17 from ady <[email protected]> --- (In reply to Colin from comment #15) > are the undo stack problems already fully identified? More than once the problems are known "by experience", but they cannot be replicated by following the same exact steps. Your case (item 4) can be replicated. In your "item 4", the Undo action "breaks" the original array functions and replaces most of them (except the first component of each array, i.e. cells in column S, rows 2:282) with non-array functions that reference the first component (range T2:Y282, each cell in each row by its own). IMHO, that should be filed as a new bug report, focused on that specific behavior / description, with the precondition that you first correct the array formula as suggested (and preferably with a simplified file/case; 5 to 10 rows, arrays of 1 row x 3 columns each). My guess is that the problem is not really about the INDEX() function specifically, but rather about the Undo action in relation to array formulas. I could very well be completely wrong. As for this report, IMHO I would suggest setting it as "invalid", in order to avoid (causing) potential confusion to other users (and devs) that might be searching for some other bug(s) with similar Summary terms but that would have no real similarity in its content. After all, this is already a relatively long report but with no clear focus (other than the conclusion we already established). Perhaps some QA dev might have a different opinion. -- You are receiving this mail because: You are the assignee for the bug.
