To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51103 Issue #:|51103 Summary:|Conditional formatting not working properly wuen |duplicating a sheet Component:|Spreadsheet Version:|680m109 Platform:|Opteron/x86_64 URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|lamberete
------- Additional comments from [EMAIL PROTECTED] Wed Jun 22 05:22:18 -0700 2005 ------- When you Copy a sheet that has conditional formating refering to one cell on itself, the new copy of the sheet steels refer to the original sheet in the conditional formatting options, instead to refer to the new, recently created, sheet. For example: I have cells A2:C10 with a conditional formatting that depends if the value in the cell is equal, bigger or less than the value at cell B1. Then I select copy/move this sheet (Sheet1). I select the copy checkbox and I create the new sheet called Sheet1_2. The conditional formatting of the cells A2:C10 of this new sheet refers to Sheet1!B1, instead of Sheet1_2!B1 like I think it should be. Sorry for my english. --------------------------------------------------------------------- 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]
