[Libreoffice-bugs] [Bug 90826] number format with text gives sign at wrong position

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=90826

Laurent BP <jumbo4444 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jumbo4444 at yahoo.fr
         Resolution|---                         |WORKSFORME
             Status|NEW                         |RESOLVED

--- Comment #17 from Laurent BP <jumbo4444 at yahoo.fr> ---
You must defined your positive and negative format:
"d = "0.00;"d = "-0.00
or
"d = "0.00;"d = minus"0.00

Calc cannot guess where you want your negative sign. For instance, you may want
it on left side of the cell:
+* 0.00;-* 0.00

If you do not define a format for negative values, then Calc use as default:
-format for positive value

Check help about Number format codes:
https://help.libreoffice.org/6.4/en-US/text/shared/01/05020301.html?DbPAR=SHARED#bm_id3153514

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200607/0300964d/attachment-0001.htm>