Issue 112941 - Range fixed with $ in Vlookup
Summary: Range fixed with $ in Vlookup
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO320m18
Hardware: All All
: P2 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-07-05 17:44 UTC by motorparts
Modified: 2014-01-15 13:42 UTC (History)
4 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

test vlookup (8.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-11-14 03:54 UTC, Jenny Kieffaber
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description motorparts 2010-07-05 17:44:57 UTC
Summary: The Vlookup range is not fixed with $ signs. This has unfortunately has to be done manually.

When selecting the range of the Vlookup, let's say A2 to B100, which gives a Vlookup range definition like 
'file:///PathOfMyFile/File01.ods'#$Sheet1.A2:B100, Calc should automatically add the $ signs in the first 
and the last cell reference in order to allow the formula to be duplicated without incrementing the Vlookup 

This should give a Vlookup range like  'file:///PathOfMyFile/File01.ods'#$Sheet1.$A$2:$B$100
Comment 1 Jenny Kieffaber 2013-11-14 03:54:07 UTC
Created attachment 81917 [details]
test vlookup
Comment 2 Jenny Kieffaber 2013-11-14 04:01:52 UTC
I tested a Vlookup function and confirmed that when copying this function to another cell the range is incremented.  I used the same formula in Excel (replacing ; with ,) and it has the same functionality as OO.
Comment 3 Edwin Sharp 2014-01-15 13:42:24 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1557669
2014-01-14_04:11:13 - Rev. 1557927