To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111581 Issue #|111581 Summary|Conditional formatting / styling with cell adressing a |lways includes sheet name Component|Spreadsheet Version|OOo 3.2 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|PATCH Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|openofficebughunting
------- Additional comments from openofficebughunt...@openoffice.org Thu May 13 14:54:26 +0000 2010 ------- Scenario: XLS file being edited in Microsoft Excel 2003 and Open Office 3.2.0 German Calc - Conditional formatting / styling is done with cell adressing in Excel (e.g. $A1='test') - File is opened with Open Office, cell content is changed and file is saved - File is opened in Excel again, cell addressing is now different (e.g. 'Sheet1'!$A1), formula has now to be corrected to make changes Conclusion: Calc always adds the sheet name to the formula given for conditional formatting, even if it is the same sheet. This should not be done if it is the same sheet. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org