To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53641 Issue #:|53641 Summary:|Cross-sheet Data->validity references fail if sheets |moved. Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|mattsavigear
------- Additional comments from [EMAIL PROTECTED] Mon Aug 22 14:31:45 -0700 2005 ------- OpenOffice build 1.19.122: Data validity cell range settings do not cope with reordering of sheets. The sheet reference component of the target cell "address" seems to be stored only as an offset from the current sheet rather than by the actual target sheet ID. To reproduce: - Open a new spreadsheet document. - Place string data in some cells on sheet 3. - Set up a cell range type validity lookup on sheet 1, pointing to the cells on sheet 3. - Add a new sheet between sheets 2 and 3. - Cell range now points to a (blank) range on the inserted sheet instead of updating to continue referencing the original sheet 3. The same effect can be achieved by deleting sheets between the referring sheet and the target sheet for the cell range. All other cross-sheet references in formulae are correctly managed on sheet reordering. --------------------------------------------------------------------- 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]
