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+h...@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