Bug 75509

Summary: Incorrect display of digits in default Numeric formatting of a field when language isn't English
Product: LibreOffice Reporter: Pleinlouie <pleinlouie>
Component: DatabaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: medium CC: gautier.sophie, iplaw67, jbfaure, robert, serval2412
Version: Inherited From OOo   
Hardware: All   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: Screen
odb coop
Default of Decimal-field without decimal places in tables except when formatted in English

Description Pleinlouie 2014-02-25 20:43:17 UTC
Created attachment 94728 [details]
Screen

Bonjour a tous je sais pas si je poste au bon endroit merci d’avance pour votre aide
j’ai crée un champs monétaire 1324,00$ canadien en lui attribuant par default 68,99$ mais dans ma table il inscrit 68,00$
j essaye de trouver la solution par moi même mais j ai du mal
j’ai type de champs NUMERIC,
 monnaie,
 saisie requise, non
, 2 décimales 
1, 0 non significatif
et dans valeurs par default j ai 68,99$
Il s’agit d’un bogue. Je ne sais s’il a été notifié chez LibreOffice…
Comment 1 Julien Nabet 2014-02-26 20:53:54 UTC
pleinlouie: please describe your bug in English + attach your odb file so we can give it a try.
Comment 2 Pleinlouie 2014-02-26 23:24:06 UTC
Created attachment 94793 [details]
odb coop
Comment 3 Pleinlouie 2014-02-26 23:24:38 UTC
Hi everybody sorry for my english but i try to do my best Lol i'm on a project to do a obd for my worker cooperative we are a little textil worker acrtionner coopérative so 
I created a Canadian monetary fields by assigning default $ 68.99 but in my table it registered $ 68.00 
I try to find the solution by myself but I have trouble 
I type NUMERIC fields 
currency 
Entry required not 
, 2 decimals 
1, no significant 0 
and default values ​​I have $ 68.99 
This is a bug. I do not know if it has been notified in LibreOffice …
I do not know if I post in the right place thank you in advance for your help 
I include the obd this time
Comment 4 Jean-Baptiste Faure 2014-03-08 14:48:01 UTC
Set status back to UNCONFIRMED because this bug report has not been independently confirmed.

Thank you for your understanding.
Best regards. JBF
Comment 5 sophie 2014-03-11 17:51:48 UTC
Hi, confirmed with the database provided and version Version: 4.2.2.1
Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f - Set to new, change summary - Sophie
Comment 6 robert 2014-03-21 19:44:23 UTC
Created attachment 96184 [details]
Default of Decimal-field without decimal places in tables except when formatted in English

Open the tables. In the first table you see a field formatted with German language to default 6,32 - shows 6,00. Same table, now formatted with English language to default 6.32 - shows 6.32.

Seems the default of the GUI works only right with a point, not with a comma.
Comment 7 robert 2014-03-21 19:49:25 UTC
This bug appears also in the first version of LO. I got the same result with LO 3.3.0 beta1. So I set the version to "Inherited From OOo". 
Also will change the title to show the bug doesn't appear in English language.
Comment 8 Alex Thurgood 2015-01-03 17:41:28 UTC
Adding self to CC if not already on

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.