Le 05/02/2016 06:35, Brian Barker a écrit :
At 03:51 05/02/2016 +0100, you wrote:
I've a display bug with a xlsx file opened with LO: how it is
displayed in Libreoffice (5.0.5.1, 5.0.4.2 and 4.4.1.2):
http://i.imgur.com/5cGNup2.png how it should be displayed, with the
right number (see "Prix HT" column: http://i.imgur.com/rmgPPv1.png
It's not at all clear from what you say what exactly is the correct
version! So both "26.9" and "0,02€" are correct?
Hi Brian,
And sorry if it wasn't clear enough: the displayed value before double
clic is the wrong one (0,02€), 26,9 is the correct version.
How to fix it? How to avoid having false numbers displayed?
The format code has a rogue comma before the "\€" . If you take this
out, you get what I'm guessing you want.
What do you mean by rogue comma before the "\€"
Best regards
I trust this helps.
Brian Barker - privately
--
To unsubscribe e-mail to: users+unsubscr...@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
