Attached is a simplistic sample of what I did but it was not in version 2.3.  
So when I sorted the cells on the "lookups" page, it did not mess up the 
validity on the main page.  However, on inserting a new blank cell into the 
list, the item on the bottom disappeared from the list.  

The list range was B1 - B4.  By inserting a cell at B2, the reference from the 
main page "should" have been updated to B1 - B5 but did not.  I say "should 
have" because I expect if I define the beginning and end of a list, if anything 
is inserted in the middle, the end of the list should move accordingly.  Also, 
if you insert a column to the left of the list on the "lookups" page, the 
reference does not change to C1 - C4 but stays pointing at B1 - B4 which are 
now blank.  

That is why we had to go to excel because the lookups sheet changes from time 
to time.  If I need a new column and I want it in column A, and that moves over 
20 other lists, that means I have to update at least 20 VALIDITY formulas. 
(yuck!).

Perhaps this was by design that a validity is always a static reference but I 
prefer it knows where the cells went when a column or cell is inserted or 
removed.  

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]

Reply via email to