https://bugs.freedesktop.org/show_bug.cgi?id=83301
Matthew Francis <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Matthew Francis <[email protected]> --- It's documented in https://help.libreoffice.org/Common/Number_Format_Codes that 3 is the maximum number. It may be, among other reasons, that there are interoperability reasons for this (i.e. that it couldn't be exported to an Excel file with more than three). There is another way to do what you're trying to do, although it's slightly more long winded: 1. Create four styles for your four cases, so that for instance the first one has a name of '(all fast)' and a number format code of "(all fast)" <-- including the double quotes 2. Select the range you want to have the style apply to 3. Open the menu Format - Conditional Formatting - Condition... 4. Add four conditions: Condition 1: Cell value is, equal to, 0; Apply Style (all fast) Condition 2: Cell value is, equal to, 1; Apply Style (fast adj) ... and so on There also isn't a convenient way to name this whole set of conditions, but you can copy and then "Paste Special" with "Formats" selected to move them around -- 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
