[Libreoffice-bugs] [Bug 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Dec 13 15:32:26 UTC 2020


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

--- Comment #5 from Robert Lacroix <ralacroix at hydro.mb.ca> ---
re: can someone tell me in which universe "calculation precision as displayed"
would even be desirable to use with currency formatting?

I might be able to answer my own question. Stock trading platforms carry prices
to hundredths of cents so if you want to match the settlement amounts with a
spreadsheet then you might want to set the calculation precision to round at 4
decimals, rather than use the ROUND(). Still that's a global setting. I might
want that to use that in one or two spreadsheets, but certainly not for all of
them unless I happen to be a stock broker.

-- 
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/20201213/52f58683/attachment.htm>


More information about the Libreoffice-bugs mailing list