Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Brian Barker <> wrote:

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

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 

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 

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 

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 

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:


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

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. 

Kubuntu 13.10


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.