To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104255 Issue #|104255 Summary|Calc LOOKUP not working across multiple tabs in OpenD |oc 3.1 Component|Spreadsheet Version|OOO310m11 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|chrispustowka
------- Additional comments from chrispusto...@openoffice.org Sat Aug 15 15:06:57 +0000 2009 ------- I have been using several "interconnected" spreadsheets for some time now without any issues. I have some "master files" which contain large tables of data in multiple tabs. I have other spreadsheets which perform LOOKUP functions against these master spreadsheets. They have always worked properly - Until I upgraded to OpenDoc 3.1! I have several different examples where this is happening. All my files are on my network, and I can prove it is an OpenDoc 3.1 issue, because when I open the exact same files from my other computers which have older versions of OpenDoc, they update the cells correctly! So to summarize... 1. With Open Doc 3.1 2. If you have a "master" spreadsheet containing data on MULTIPLE tabs 3. And from a separate spreadsheet you use the LOOKUP function to find values from that "master" spreadsheet, the values that come from the first tab of the master appear to work correctly, but values that are supposed to come from the 2nd, 3rd, etc tabs often are not correct. More unfortunately you do not get an error, but rather the system pulls values from the wrong tab! This obviously has big implications! 4. When I load the same files from an older version of OpenDoc, all works correctly. I can provide separately copies of my spreadsheets if you wish, but they do contain sensitive information, and of course the LOOKUP functions include file path names that will need to be changed on your end. Let me know. Thanks...Chris --------------------------------------------------------------------- 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