https://bugs.documentfoundation.org/show_bug.cgi?id=170670
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #1 from ady <[email protected]> --- Repro in LO Dev 26.8 (2026-02-07). I do believe that Calc modifying the format in the way described in comment 0 is unexpected. I am not completely sure which should be an adequate format in order to obtain the desired result for "zero" values (instead of Calc modifying the custom format to something different). I have not tested positive neither negative values, for 2 reasons: _ these formats are not modified by Calc in unexpected ways; and, _ using comma as either group separator or decimal separator does not affect the current behavior on the format for "zero" values. In the meantime, a workaround (to what the OP is looking for, with the format as expressed on comment 0 ) can be: "[>0]#,##0_);[<0](#,##0);-#_)" (without the initial and final quotation marks) IOW, change '"-"_)' to '-#_)' (without the single nor double quotation marks). -- You are receiving this mail because: You are the assignee for the bug.
