Issue 23099 - Autopilot functions need to sometimes use absolute references
Summary: Autopilot functions need to sometimes use absolute references
Status: CLOSED DUPLICATE of issue 23098
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2003-12-02 14:19 UTC by ericinterplascom
Modified: 2003-12-02 16:27 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description ericinterplascom 2003-12-02 14:19:03 UTC
> Series:
> 3. When doing vlookup, and dragging a series, you'll notice the first
> parameter increases as it should but that lookup array reference parameter
> also increases:
>    =VLOOKUP(K2;'City Abbreviations'.D1:E1039;2;0)
>    =VLOOKUP(K3;'City Abbreviations'.D2:E1040;2;0)
> I could do a SHIFT-F4 to convert a cell from relative to absolute:
> =VLOOKUP(K2;'City Abbreviations'.D1:E1039;2;0)
> becomes:
> =VLOOKUP($K$2;'City Abbreviations'.$D$1:$E$1039;2;0)
> but I have to manually edit the first paramenter:
> =VLOOKUP(K2;'City Abbreviations'.$D$1:$E$1039;2;0)
> IMHO, the function wizard should have made the array (the second parameter)
> absolute addresses instead of relative.  In fact, there may be more
> functions should be made absolute upon function creation by the Autopilot.
Comment 1 frank 2003-12-02 16:27:24 UTC
double 23098

*** This issue has been marked as a duplicate of 23098 ***
Comment 2 frank 2003-12-02 16:27:44 UTC
closed double