Issue 112941 - Range fixed with $ in Vlookup
Summary: Range fixed with $ in Vlookup
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-07-05 17:44 UTC by motorparts
Modified: 2014-01-15 13:42 UTC (History)
4 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
test vlookup (8.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-11-14 03:54 UTC, Jenny Kieffaber 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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.

Scenario:
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 
range.

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
Debian