Bug 79323

Summary: EDITING: Copying VLOOKUP formula improperly increments table array.
Product: LibreOffice Reporter: pmulligan
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG QA Contact:
Severity: normal    
Priority: medium CC: mariosv
Version: 4.2.3.3 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: vlookup copy test

Description pmulligan 2014-05-27 17:01:58 UTC 
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.
Comment 1 pmulligan 2014-05-27 17:03:59 UTC 
This bug also exists in 4.1.6.2
Comment 2 muldune6910 2014-05-27 17:54:52 UTC 
I've got the same issue on with version 4.2.1.1 on Windows 7 64-bit.
Comment 3 m.a.riosv 2014-05-27 22:21:59 UTC 
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.