Brian Barker <b.m.barker@btinternet.com> 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
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
--
Jim
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
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.