To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80778 Issue #|80778 Summary|data validity sheet references aren't by name Component|Spreadsheet Version|OOo 2.2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|jmberg
------- Additional comments from [EMAIL PROTECTED] Fri Aug 17 11:07:29 +0000 2007 ------- If you reorder sheets, data validity references change. Try this: * create a new spreadsheet document with three sheets * go to Sheet2 and enter 1, 2, 3, 4, 5 in to the range $A$1:$A$5 * go to Sheet3 and enter a, b, c, d, e in to the range $A$1:$A$5 * go to Sheet1 and in any cell enter a "Cell Range" data validity, using "Sheet2.$A$1:$A:$5" * verify that it shows you the values 1,2,3,4,5 in the drop down * reorder the sheets to the order Sheet1,Sheet3,Sheet2 * see that it shows the values a,b,c,d,e in the drop down! --------------------------------------------------------------------- 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]