Bug 113260 - FORMATTING Adding decimal place display incorrect value
Summary: FORMATTING Adding decimal place display incorrect value
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-10-19 09:35 UTC by Cley Faye
Modified: 2020-11-18 04:04 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Cley Faye 2017-10-19 09:35:27 UTC 
Description:
Adding lots of decimal places using the toolbar button cause the displayed formatted value to be incorrect, although the real cell value remain correct.

Steps to Reproduce:
1. Open a new calc document
2. Put 111111111111111 in a cell
3. Add 16 decimal places using the toolbar button "Add decimal places"

Actual Results:  
The cell display "11111111111111.1000000000000000"

Expected Results:
Expected the cell to display "111111111111111.000000000000000"
Not getting any '1' on the right of the decimal separator was the expected result.


Reproducible: Always

User Profile Reset: Yes, completely deleted ~/.config/libreoffice/4 before reproducing, and changed locale to C.

Additional Info:
Same thing happen with french locale (using ',' as a decimal separator).
It doesn't happen with 14 digits, so it might be related to storage of integer and double.


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36
Comment 1 Jean-Baptiste Faure 2017-10-19 13:46:38 UTC 
Reproducible with current master and Version: 5.4.4.0.0+ under Ubuntu 16.04 x86-64.

Setting as NEW

Best regards. JBF
Comment 2 pierre-yves samyn 2017-10-19 13:59:45 UTC 
Hi

Reproduced on windows 7/64 & Version: 5.4.1.2
Build ID: ea7cb86e6eeb2bf3a5af73a8f7777ac570321527
CPU threads: 2; OS: Windows 6.1; UI render: default; 
Locale: fr-FR (fr_FR); Calc: group

Regards
Pierre-Yves
Comment 3 Jean-Baptiste Faure 2017-10-19 14:41:03 UTC 
Changed version and OS according to comment #2.

Best regards. JBF
Comment 4 Laurent Godard 2017-10-19 15:32:38 UTC 
reproduced

Version: 5.4.1.2.0+
Build ID: 1:5.4.1-1
Threads CPU : 8; OS : Linux 4.13; UI Render : par défaut; VCL : gtk3; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

after de 15th added decimal, .1 decimal propagate.
ending with something like

111111111111111.1000000000000000
adding a decimal
111111111111111.11000000000000000
aso
111111111111111.111000000000000000
111111111111111.1111000000000000000
111111111111111.111111000000000000000
Comment 5 m_a_riosv 2017-10-19 22:25:34 UTC 
If I'm not wrong precision limit for numbers in calc is 15 digits plus sign.
Seems to me that the number of decimal digits should be limited 15.
Comment 6 Jacques Guilleron 2017-10-20 07:13:38 UTC 
Hi all,
There is no issue in
LO 5.1.0.2 Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc
CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; 
Locale : fr-FR (fr_FR)
This issue, as described in comment 4, begins with
LO 5.1.0.3 Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; 
Locale : fr-FR (fr_FR)
Comment 7 QA Administrators 2018-10-21 02:50:41 UTC Comment hidden (obsolete)
Comment 8 Cley Faye 2018-10-21 10:30:26 UTC 
Checked with:

Version: 6.1.2.1 (x64)
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
Threads CPU : 8; OS : Windows 10.0; UI Render : GL; 
Locale : fr-FR (fr_FR); Calc: CL

Seems to be fixed.
Comment 9 nandwall 2020-11-18 04:04:02 UTC Comment hidden (spam)