https://bugs.documentfoundation.org/show_bug.cgi?id=167636
--- Comment #9 from [email protected] --- Seems this bug is also related to the use of absolute / relative ranges in the vlookup function, but also to the size of the "Array" parameter used this function. In the provided document, when I fill the range $formulas.D2:D7 with : =$C2*VLOOKUP(CONCATENATE($A2;" ";$B2);$data.A:B;2;FALSE()) or =$C2*VLOOKUP(CONCATENATE($A2;" ";$B2);$data.A:$B;2;FALSE()) or =$C2*VLOOKUP(CONCATENATE($A2;" ";$B2);$data.$A:$B;2;FALSE()) errors appear on document load. But there is no error with : =$C2*VLOOKUP(CONCATENATE($A2;" ";$B2);$data.$A:B;2;FALSE()) If I fill the same range with : =$C2*VLOOKUP(CONCATENATE($A2;" ";$B2);$data.$A$1:$B$84;2;FALSE()) there is no error on document load. But with : =$C2*VLOOKUP(CONCATENATE($A2;" ";$B2);$data.$A$1:$B$85;2;FALSE()) errors reappear on document load. If I fill the same range with : =$C2*VLOOKUP(CONCATENATE($A2;" ";$B2);$data.$A:$C;2;FALSE()) while the $data.C column is empty, there is no error on document load. But if the column $data.C contains any data, errors reappear. -- You are receiving this mail because: You are the assignee for the bug.
