Re: [libreoffice-users] Calc issue: display wrong values until double clic

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): 
> > https://i.imgur.com/5cGNup2.png how it should be displayed, with the 
> > right number (see "Prix HT" column: https://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+unsubscribe@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