https://bugs.documentfoundation.org/show_bug.cgi?id=171017
--- Comment #20 from Colin <[email protected]> --- (In reply to ady from comment #19) > @Colin, > > My opinion is that the result of an array formula should be maintained > together, as an array. > An alternative, IMHO, would be to avoid the array formula, producing instead > independent INDEX() functions. But I never wrote the formula as a 7 x 200+ array. It was always just a formula copied from 1 row to 200+ more and CALC decided it was a homogenous array and the CALC engine can't cope with it so it's vetoed. Can you imagine a function creating five cells saying S O N A R with the same function on the next row calculating A R S O N and the user being told NO NO NO, you can't sort them alphabetically because they were created using a similar function - however, you can hide as many anagrams as you wish. I think it was just unlucky that the effort uncovered a real structural problem with CALC because the undo function is unable to cope with the limitations of the ARRAY it assumed was present. Seems counterproductive. I can't even conceive of the damage that could be caused (nor did I test for it) if another operation on another sheet was UNDONE and the data corrupted and unobserved through three or four backups. Please feel free to hide this discourse if it's inappropriate to Bug reporting. As suggested earlier, perhaps QA has an opinion. -- You are receiving this mail because: You are the assignee for the bug.
