[libreoffice-users] Calc - Format code - How to omit an unneeded decimal point before a currency symbol, text or unit

Abstract:
Calc
Format Code
How to omit an unneeded decimal point before a currency symbol, text or unit?


Hi to all interested,

when I use the format code 0.##
PI() yields 3.14 and
23 yields 23 (note the omitted decimal point).

With the format code 0.## [$$]
23 yields 23.
and the unneeded decimal point is not omitted as desired.

Same with the format codes
0.## [$TEXT]
0.## ""
0.##" UNIT"
0.## "UNIT"
and
0.??

0.##"" on the other hand works, but is not very useful.

Is this a hard constraint, a bug or is there a way around it, e.g. a condition like [>0] which 
detects rounding?

Regards, Tobias Simon


Bonus:
0.?? should replace an unneeded decimal point with U+2008 Punctuation Space.
-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted