To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80778
------- Additional comments from [EMAIL PROTECTED] Fri Sep 7 19:22:50 +0000 2007 ------- I guess the behaviour can't be changed now, but I still think it's rather weird that relative references to cells are updated when you shift around cells e.g. by deleting columns, but relative sheet references aren't updated when you shift around sheets. That is, if you have four sheets (Sheet1,2,3,4) instead of the three in my example and make a Sheet3.$A$1:$A$5 reference, and then delete Sheet2, your reference will all the sudden point to Sheet4. If it had been a cell reference and you'd deleted a column, which I feel is somewhat equivalent, the cell reference will be updated. In fact, I guess that when you have a Sheet4.... reference and delete Sheet3 your reference all the sudden is totally invalid because the "current sheet + 3" doesn't exist any more. I think this behaviour is highly unintuitive, everywhere else are relative references updated when things change but with the sheets. However, I don't feel strongly about the issue either, I've only used the data validity feature once [and promptly ran into the issue, however] --------------------------------------------------------------------- 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]
