To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112941 Issue #|112941 Summary|Range fixed with $ in Vlookup Component|Spreadsheet Version|OOO320m18 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P2 Subcomponent|editing Assigned to|spreadsheet Reported by|motorparts
------- Additional comments from [email protected] Mon Jul 5 16:44:57 +0000 2010 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
