https://bugs.documentfoundation.org/show_bug.cgi?id=151897
--- Comment #6 from m.a.riosv <[email protected]> --- Created attachment 183429 --> https://bugs.documentfoundation.org/attachment.cgi?id=183429&action=edit Sample file with INDIRECT instead INDEX Sorry, I was doing something no in the right way to test. Deleting a cell with data in column A: - 20 with CONCAT. - 18 with TEXTJOIN. The issue, I don't think it's a bug, but how the formula works to get the array to analyze the word. ROW($A$1:INDEX($A:$A;LEN(A2)), is slow, I think, because all data it's iterated inside INDEX, only to force the array with the word length. ROW(INDIRECT("1:"&LEN(A2))), also force the array, but without such calculate cost. -- You are receiving this mail because: You are the assignee for the bug.
