https://issues.apache.org/ooo/show_bug.cgi?id=99474
--- Comment #1 from Jonathan <[email protected]> --- Created attachment 80534 --> https://issues.apache.org/ooo/attachment.cgi?id=80534&action=edit 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. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
