To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86863 Issue #|86863 Summary|Vlookup not included added data Component|Spreadsheet Version|OOo 2.3.1 Platform|Opteron/x86_64 URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|pacice
------- Additional comments from [EMAIL PROTECTED] Mon Mar 10 08:44:16 +0000 2008 ------- I have found that after a vlookup formula has been created, any data added to the datasource will not be included in the vlookup formula. For example, the search criterion is BOB BOB is not in the datasource array and a #N/A is returned. A line is inserted into the data array, and BOB is added to the Data array in the correct sort order. The vlookup line for BOB stays #N/A and will not update and show BOB. I have tried re-calc, saving and reopening the spreadsheets. I have discovered the problem fixes itself if saved in Excel format, opened in Excel and links updated, saved and closed, and re-opened in Calc. After that all reports correctly. --------------------------------------------------------------------- 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]
