Created attachment 99966 [details] vlookup copy test Expected Behavior: When copying a VLOOKUP formula, the data array value should not increment/change. Only the search criterion should increment/change. Actual Behavior: When copying a VLOOKUP, the data array increments/changes along with the search criterion. Result: Several lookups fail due to the resultant bad data array reference in the copied VLOOKUP formula. Workaround: Have to edit the initial VLOOKUP data array with the "$" symbol before the row and column label to keep it from changing during a copy.
This bug also exists in 4.1.6.2
I've got the same issue on with version 4.2.1.1 on Windows 7 64-bit.
Hi, sorry but what you put as workaround in the file is the proper way to do it. Only absolute references aren't changed when copying formulas. You can set up as absolute only rows or columns with the $. Please search in the help for: relative references LibreOffice documentation for calc: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.