https://bugs.documentfoundation.org/show_bug.cgi?id=163917
--- Comment #11 from m_a_riosv <[email protected]> --- Sorry, maybe I mix modified formulas with the change of the option. Reviewing the file with error N14 #REF! =INDEX(B5:J5;1;10) N15 9 =COLUMNS(B5:J5) N16 5,72 =INDEX(B5:K5;1;10) N17 10 =COLUMNS(B7:K7) seems in your initial formula, there are less than 10 columns in B5:J5, so extract the value from column 10 is out of range, in the file working fine the range is B5:L5 11 columns. -- You are receiving this mail because: You are the assignee for the bug.
