To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110391 Issue #|110391 Summary|Bug / issue # 25653 is back in oo32m12 Component|Spreadsheet Version|OOO320m12 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|jfgorup
------- Additional comments from [email protected] Thu Mar 25 14:17:33 +0000 2010 ------- Saving a SCal spreadsheet in XLS format that contains a conditional format pointing to a cell in the current sheet gets fully qualified by OO (i.e. the cell reference get prefixed with the sheetname). This cause Excel to ignore all conditional format when loading the saved file by OO in OO3.2m12 build 9483. Furthermore if you try to edit the cell with the conditional format in Excel you get an error message saying that "You may not use reference to other worksheets or workbooks for Conditional Formatting Criteria". BTW OO does not have a problem read the xls file back, only Excel. This seems to have been raised in issue #25653 and then got fixed in subsequent OO release. Thanks JF --------------------------------------------------------------------- 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]
