https://bugs.documentfoundation.org/show_bug.cgi?id=171017
--- Comment #15 from Colin <[email protected]> --- (In reply to ady from comment #13) > @Colin, > > Sorry, but there should be one bug per report. Posting a list of procedures > that have not much in common is not a way to analyze the situation. > > I'll try to answer to your questions, but I think most of this should go to > <https://ask.libreoffice.org>. > > First, INDEX() in particular might not be necessarily the problem, but > rather one example of a generic issue regarding UNDO and array formulas. > @ady Thanks for your efforts and helping to remind me that I locked down the range so that I could replicate the formula but then failed to release the absolute references, thereby causing my own problem. I normally make the "opposite" mistake and fail to make the source array absolute so the lookup then "wanders" down the column. It also reminded me that as the calculations on that array will never change once the ID is entered and the entropy established, I should simply produce a formula on the top row and then paste values only to the inserted rows - thus avoiding the unnecessary volatility - and my inferior array function. Would a replacement bug report of the ilk you identified, add anything to the system, or are the undo stack problems already fully identified? Again, Many Thanks -- You are receiving this mail because: You are the assignee for the bug.
