Apache OpenOffice (AOO) Bugzilla – Issue 99474
Failure to save user-defined Cell Styles selected withConditional Formatting
Last modified: 2013-11-29 13:33:57 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.
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.
Created attachment 82002 [details] screenshot of original attachment Excel 2010 vs. Calc 4.1
Confirmed with AOO410m1(Build:9750) - Rev. 1543812 Rev.1543812 Win 7