To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116643 Issue #|116643 Summary|VLOOKUP bug Component|Spreadsheet Version|OOO320m1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|lezemore
------- Additional comments from lezem...@openoffice.org Wed Jan 26 18:02:38 +0000 2011 ------- I have a Spreadsheet of medium complexity and size running in v3.2.1. I manipulate this daily, adding a new sheet, deleting another and updating or copying formulae. The updated Spreadsheet, although Saved, shows data in numeric error (i.e. the wrong values) reported using VLOOKUP targeted upon the new data sheet. When I save the Spreadsheet and reload it, the values are then reported correctly. The apparent reason for the incorrectly reported values are that VLOOKUP is still targeted at the prior day's data sheet, although the VLOOKUP formula has been updated to point to the latest data sheet. If you would like screenshots to demonstrate the issue, please ask. I cna send them in MS Word format document (or ODF if you prefer). Regards, Geoff. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org