Apache OpenOffice (AOO) Bugzilla – Issue 23099
Autopilot functions need to sometimes use absolute references
Last modified: 2003-12-02 16:27:44 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.
double 23098 *** This issue has been marked as a duplicate of 23098 ***
closed double