https://bugs.documentfoundation.org/show_bug.cgi?id=95233
--- Comment #9 from r...@alum.mit.edu --- I think that actually _using_ STYLE() inside of conditional formatting is a strange thing to do. What I'm trying to do, though, is as ddescribed in bug 85264: "Request the ability to apply the format returned by a formula. This is in essence like the STYLE() function, except applied via conditional formatting rather than by explicit use of STYLE(). "Use case: applying a style to manually entered data. For example, a formula that returns a named style based on the year of an entered date (perhaps by means of LOOKUP()) would have the style applied by conditional formatting to the entered cell. "The date method of conditional formatting is not appropriate for this case; the basic conditional formatting could be used, but only up to 10 years (or other ranges). It's also less flexible, because the formula to be used for the computed conditional format could actually be a name; editing the value of the name changes the formula, which would allow the computed style to be changed easily everywhere." Conditional formatting will not work for this case because I have more than 10 possible styles to apply. In addition, I'd like the style to be the result of a formula, which I can change on the fly, rather than a purely static list or one of the limited options provided by conditional formatting. What I usually do for cells with formulas is =a1+b2+STYLE(LOOKUP(CURRENT(), FooRanges, FooStyles) where FooRanges and FooStyles might be adjacent columns that look something like this (this is an actual example -- number of meters I've rowed in a session, to be precise): 0 blank 1 slow 1000 default 2000 slow1 4000 200 5000 158 6000 155 7000 1525 8000 151 10000 150 12000 149 15000 148 17000 147 20000 146 21097 145nb 22000 143 23000 fast 24000 fast1 25000 fast2 26000 fast3 27000 fast4 28000 fast5 I'd like to be able to do this for text entry cells, but easily change the breakpoints (which are used elsewhere) without having to change both the lookup table and the conditional formatting (which won't even work in this case due to the number of ranges). Reopening 85264 would be one way of handling this. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
