Issue 99474 - Failure to save user-defined Cell Styles selected withConditional Formatting
Summary: Failure to save user-defined Cell Styles selected withConditional Formatting
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.0-dev
Hardware: PC Windows, all
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-02-20 20:45 UTC by lvles
Modified: 2013-11-29 13:33 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Spreadsheet containing conditional formatting issue (14.00 KB, application/octet-stream)
2013-04-14 17:46 UTC, Jonathan
no flags Details
screenshot of original attachment (327.91 KB, image/jpeg)
2013-11-29 13:32 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description lvles 2009-02-20 20:45:20 UTC
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.
Comment 1 Jonathan 2013-04-14 17:46:20 UTC
Created attachment 80534 [details]
Spreadsheet containing conditional formatting issue

In this spreadsheet the colours in the boxes should reflect the totals of the boxes for each pair of matchups across each side of the table. For example where Gia and Gmb cross on either side of the blacked out middle section (G20 and H19) there is a 2 in one box and a 1 in the other. This totals 3. The conditional formatting for these 2 boxes means that the style() chosen should be the Style named 3 ie Style(G20+H19). If you change the values in these 2 boxes so they total 0, 1, 2, 3 or 4 the same style should automatically be chosen and when I first made the spreadsheet it was. However after saving and reloading the spreadsheet Calc has created a bunch of styles with names like Excel_CondFormat_1_4_1 and set them instead of using default. If you click on any coloured box go into conditional formatting and then simply click ok the conditional formatting will then function correctly with that box, however in order to make all boxes work for that session you have to ok the conditional formatting for each and every one of them individually.
Comment 2 Edwin Sharp 2013-11-29 13:32:46 UTC
Created attachment 82002 [details]
screenshot of original attachment

Excel 2010 vs. Calc 4.1
Comment 3 Edwin Sharp 2013-11-29 13:33:57 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1543812
Win 7