Issue 99474

Summary:

Failure to save user-defined Cell Styles selected withConditional Formatting

Product:

Calc

Reporter:

lvles <lvles>

Component:

formatting

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

elish, issues

Version:

4.1.0-dev

Target Milestone:

---

Hardware:

OS:

Windows, all

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Spreadsheet containing conditional formatting issue	none
screenshot of original attachment	none

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
Rev.1543812
Win 7