No. This was done in Calc. I would have the first page setup with validations that point to column based lists on the second sheet. If I would insert or make any change in the list on the second sheet, the validation reference (on the first sheet) would change to some "seemingly" random list of cells somewhere else.
It was frustrating because, if I recall correctly, I did a "sort" on one of the lists on the second sheet so the dropdown on the first sheet would be alphabetical and the validation lost the correct list from the second sheet and picked some other column at random (it seems). It made it difficult since I can do this in excel and it never loses the correct reference. (NOTE: I never used excel during this, I had the individual purchase excel for their computer so that this would work correctly for them.) I am sharing this information in case someone wants to address it in openoffice. I am willing to setup open office on one of my virtual machines to give a demo of what I am talking about. It will just take me a little while to do since I have to do my secular work first (sigh). Craig -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 9:34 AM To: [EMAIL PROTECTED] Subject: [Issue 83569] Validation accross tab fails on change To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83569 ------- Additional comments from [EMAIL PROTECTED] Mon Dec 10 15:33:49 +0000 2007 ------- Hi, is the used file an Excel file ? If so, Excel isn't capable to use cross sheet references in validation lists. Frank --------------------------------------------------------------------- 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 This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. --------------------------------------------------------------------- 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]
