https://bugs.documentfoundation.org/show_bug.cgi?id=85264
--- Comment #9 from [email protected] --- Comment added to bugt 95233: 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 [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
