Bug 75509 - Incorrect display of digits in default Numeric formatting of a field when language isn't English
Summary: Incorrect display of digits in default Numeric formatting of a field when lan...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium major
Assignee: Not Assigned
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
Reported: 2014-02-25 20:43 UTC by Pleinlouie
Modified: 2021-08-28 06:27 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:
Regression By:

Screen (54.75 KB, image/png)
2014-02-25 20:43 UTC, Pleinlouie
odb coop (25.51 KB, application/vnd.oasis.opendocument.database)
2014-02-26 23:24 UTC, Pleinlouie
Default of Decimal-field without decimal places in tables except when formatted in English (3.02 KB, application/vnd.sun.xml.base)
2014-03-21 19:44 UTC, Robert Großkopf

Note You need to log in before you can comment on or make changes to this bug.
Description Pleinlouie 2014-02-25 20:43:17 UTC
Created attachment 94728 [details]

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,
 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 
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:
Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f - Set to new, change summary - Sophie
Comment 6 Robert Großkopf 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 Großkopf 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 Comment hidden (no-value)
Comment 9 QA Administrators 2016-01-17 20:05:39 UTC Comment hidden (obsolete)
Comment 10 Alex Thurgood 2016-01-19 13:17:42 UTC
Still present in 

Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Locale : fr-FR (fr.UTF-8)

with test file
Comment 11 QA Administrators 2017-03-06 14:46:04 UTC Comment hidden (obsolete)
Comment 12 Anton Abrosimov 2018-10-21 00:40:22 UTC
I can confirm this bug in LO V6.1.2, V6.1.3 with Russian langpack.

You can use my Docker container for making tests and more details: https://gitlab.com/abrosimov_bug_reports/libreoffice_bug_number
Comment 13 QA Administrators 2021-08-28 03:53:23 UTC Comment hidden (obsolete)
Comment 14 Robert Großkopf 2021-08-28 06:27:16 UTC
Bug is still present in LO on OpenSUSE 15.2 64bit rpm Linux.