Editing Custom Styles in Calc

users
#1

I use custom styles in Conditional Formatting. For example, I highlight cells that contain values that are more than 2.5 standard deviations on either side of the mean value of the data.

I am unable to delete styles that I no longer need or to change their characteristics (e.g. background color) to better meet my needs.

What should I do?

#2

Highlight the area, then Format > Clear Direct Formatting.

Tink.

#3

I use custom styles in Conditional Formatting. For example, I highlight cells that contain values that are more than 2.5 standard deviations on either side of the mean value of the data. I am unable to delete styles that I no longer need or to change their characteristics (e.g. background color) to better meet my needs.

You should be able to do either of these, of course.

What should I do?

Perhaps explain what you tried, what you expected to happen, and what actually happened? Otherwise, anyone can only guess.

o Go to Format | Styles and Formatting (or click the Styles and Formatting button in the Formatting toolbar, or press F11).
o Click Cell Styles.
o Ensure that the drop-down menu at the bottom allows the display of the relevant style.
o Right-click the relevant style and go to Modify... | Background - or to Delete... .

I trust this helps.

Brian Barker

#4

That's the bit that people will need in order to help, of course. Sadly I cannot.

Brian Barker

#5

Okay, here goes in painful detail.

I wanted several custom styles to highlight values in a range that could be considered to be outliers relative to the other values in that range.

Sample cell contents:

A1 2.5
B1 "Sale"
C1 "Commission"
D1 "Miles"
A2 "μ"
B2 =AVERAGE(B4:B2003)
C2 =AVERAGE(C4:C2003)
D2 =AVERAGE(D4:D2003)
A3 "σ"
B3 =STDEVP(B4:B2003)
C3 =STDEVP(C4:C2003)
D3 =STDEVP(D4:D2003)

Formatting of numbers:
Column B $0.00
Column C $0.0000
Column D 0.0

Custom Styles:
Style Outlier_B: Same as column B except with special display effects
Style Outlier_C: Same as column C except
with special display effects
Style Outlier_D: Same as column D except with special display effects

Conditional formatting using Format→Conditional Formatting→Condition… :

Range B4:B2003 Formula is AND(ISNUMBER(B4),OR(B4<(B$2-$A$1*B$3),B4>(B$2+$A$1*B$3))) Apply Style Outlier_B

Range C4:C2003 Formula is AND(ISNUMBER(C4),OR(C4<(C$2-$A$1*C$3),C4>(C$2+$A$1*C$3))) Apply Style Outlier_C

Range D4:D2003 Formula is AND(ISNUMBER(D4),OR(D4<(D$2-$A$1*D$3),D4>(D$2+$A$1*D$3))) Apply Style Outlier_D

Now my problem is that I want to change the special display effects.

I press F11. I see a small panel ("Styles and Formatting"). There are five icons at the top (two on the left and three on the right. The icon images mean nothing to me but fortunately each has a tool tip.

Left side
° Displays the list of the available Cell Styles for indirect cell formatting.
° Displays the Page Styles available for indirect page formatting.

Right side
° Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles and Formatting window.
° Creates a new style based on the formatting of a selected object.
° Updates the Style selected in the Styles and Formatting window with the current formatting of the selected object.

The body of the panel displays:

Default
Heading
Heading1
Outlier_B
Outlier_C
Result
Result2

The bottom of the panel says All Styles but can be any of:

Hierarchical
All Styles
Hidden Styles
Applied Styles
Custom Styles

With All Styles selected the context menu for the standard five styles is

° New …
° Modify …
° Hide

and for my custom styles

° New …
° Delete …

In the Hidden Styles view there is one style listed. It is not listed in the All Styles list. Its context menu is

° New …
° Modify …
° Show
° Delete …

The Applied Styles list is empty.

The Custom Styles list has my three custom styles with the same context menu as before.

My problem is that my custom styles don't have Modify … on the context menu.

Delete … does appear to work though the deleted style reappears later.

My custom styles were created within the _new_ Conditional Formatting dialog box which, by the way, does not appear to be documented in the Help list.

LO 4.1.3.2
Kubuntu 13.10