To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99474 Issue #|99474 Summary|Failure to save user-defined Cell Styles selected with |Conditional Formatting Component|Spreadsheet Version|1.0.0 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|lvles
------- Additional comments from lv...@openoffice.org Fri Feb 20 20:45:20 +0000 2009 ------- Applies to OOO300m15 Calc Build 9379 Calc fails to save the state of Format/Conditional Formatting/Cell Style for a user-defined cell style. Predefined cell styles are retained. On saving and reopening file, the Cell Style drop down box displayed "Excel_CondFormat[numeric & _]" rather than the user-defined format that appears in the list. Specifically, I defined three styles based on 10pt Times New Roman: Profit displays green text, Loss displays red text, Default displays black text. The conditional cell compares its entered value to the value in another column and uses <,>, and = conditions to select the cell text color. The conditional formatting is saved, but my defined styles "profit", "loss", and "default" are no longer selected after reopening the file. The selected styles continue to display in the drop-down Cell Style list. The defect came to my attention when I noticed that a change in cell value that ought to have changed the color of the text did not do so. --------------------------------------------------------------------- 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