https://bugs.documentfoundation.org/show_bug.cgi?id=159930
--- Comment #2 from Jim Avera <jim.av...@gmail.com> --- I think this is a bug because the documentation nowhere mentions that a digit symbol must precede the decimal, and in fact there is an EXAMPLE in the docs of a format without anything before the decimal (although it does not involve negatives). The format string docs are at https://help.libreoffice.org/latest/en-US/text/shared/01/05020301.html?&DbPAR=CALC&System=UNIX The counter-example (sort of) is «.#,, "Million"» at https://help.libreoffice.org/latest/en-US/text/scalc/guide/format_value_userdef.html?DbPAR=CALC#bm_id3143268 FWIW, in the real application I had to hand-type the format string because the Format Cells dialog options do not support what was needed (percentages with different colors for both positive & negative values). I probably omitted any leading '#' in a mistaken attempt to allow the column to be narrower when all values were < 1.00% -- You are receiving this mail because: You are the assignee for the bug.