To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107377 Issue #|107377 Summary|vlookup does not update index when inserting/deliting |columns Component|Spreadsheet Version|OOo 3.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|oger000
------- Additional comments from [email protected] Wed Dec 2 11:14:56 +0000 2009 ------- If you insert/delete a column between the first column and the colum referenced by the index (offset), the index-count is not updated. All other cell references are updated. Because its hard for me to explain I attac a simple example. Open it mark column "C" and write-click and do a "insert column". The value in line 20 calculated by the vlookup function should not change, but does because the index is not adjusted from "4" to "5". Same happens when inserting cells with "move to right". And (untested) the same will be valid for hlookup. MS-office-2000 has the same behavour (which makes it not better). Newer versions of MS-office I do not have at hand to test. --------------------------------------------------------------------- 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]
