| Summary: | EDITING: Copying VLOOKUP formula improperly increments table array. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | pmulligan |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 4.2.3.3 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | vlookup copy test | ||
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 |
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.