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)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
 
Reported: 2014-02-25 20:43 UTC by Pleinlouie
Modified: 2023-08-30 03:06 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Screen (54.75 KB, image/png)
2014-02-25 20:43 UTC, Pleinlouie
Details
odb coop (25.51 KB, application/vnd.oasis.opendocument.database)
2014-02-26 23:24 UTC, Pleinlouie
Details
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
Details

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]
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 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 

Version: 5.0.3.2
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 7.2.0.4 on OpenSUSE 15.2 64bit rpm Linux.
Comment 15 QA Administrators 2023-08-29 03:18:23 UTC Comment hidden (obsolete)
Comment 16 Robert Großkopf 2023-08-29 05:32:05 UTC
Bug still exists on 
Version: 7.6.0.3 (X86_64) / LibreOffice Community
Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265
CPU threads: 6; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
Comment 17 QA Administrators 2023-08-30 03:06:03 UTC
Dear Pleinlouie,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug