Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Autopilot functions need to sometimes use absolute references | ||
---|---|---|---|
Product: | Calc | Reporter: | ericinterplascom <eric> |
Component: | code | Assignee: | spreadsheet <spreadsheet> |
Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | OOo 1.1 | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
double 23098 *** This issue has been marked as a duplicate of 23098 *** closed double |
> 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.