https://bugs.documentfoundation.org/show_bug.cgi?id=85264
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #2 from [email protected] --- A style is a collection of cell settings, including font, background color, border, etc. Styles are each named; the F11 key opens the style editor, where you can create, modify, and apply styles. So I could for example define a style named "Emphasis" with a bold, red font and 2 point border. The STYLE() function can be used in formulas to apply a style to a cell. So I could have a formula Example 1: =A1+STYLE("Emphasis") that sets the cell to the value of cell A1 and applies the "Emphasis" style to it. The argument to the STYLE function can be computed, just like any other. One idiom I use a lot is Example 2: =A1+STYLE(LOOKUP(CURRENT(),Ranges,Styles)) where CURRENT() is the function returning the current value of the computation, Ranges is an array of values, and Styles is an array containing a list of style names. The expression can be even more complex than that. That all works fine for a cell containing a formula. If the cell contains a value that the user enters, this doesn't work. The only way to do variable formatting in a value cell is with conditional formatting. Conditional formatting is done via a list of conditions and styles. There can be up to 10 conditional styles in the list. A condition can be either a simple test or a formula, but the formula returns either true or false. The style corresponding to the first true condition is applied. There are a few other ways of doing conditional formatting, such as color scales, but those don't work for what I want to do. What I want to do is have a new kind of conditional formatting where the "condition" is a formula that returns the name of a style, in the same manner as examples 1 and 2. Fixed conditions are too unwieldly for this purpose; it's limited to 10 expressions, and if I want to add in another slot, I have to redo all of the conditions. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
