Bug 115687 - Calc breaks off input
Summary: Calc breaks off input
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.1.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-02-13 15:26 UTC by POLAR
Modified: 2018-02-13 17:40 UTC (History)
0 users

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 POLAR 2018-02-13 15:26:34 UTC 
Description:
Calc truncates some types of input after pressing enter.

Steps to Reproduce:
1.open Calc
2.type 0.009 in a cell
3.press enter

Actual Results:  
9
Now the cell shows 9 and it saved only "9".

Expected Results:
0.009


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0
Comment 1 Xavier Van Wijmeersch 2018-02-13 16:08:43 UTC 
no repro

Version: 6.0.1.1
Build ID: SlackBuild for 6.0.1 by Eric Hameleers
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 2 Gilward Kukel 2018-02-13 16:44:08 UTC 
because Calc treats the . as the thousands separator.
Type 0,009 or change the language to English, or if you want the text "0.009" type '0.009 or change the cell format to text
Comment 3 POLAR 2018-02-13 16:57:54 UTC 
But 0.03, 0.01 are properly displayed and saved
Comment 4 Gilward Kukel 2018-02-13 17:10:29 UTC 
yes, 0.03 and 0.01 are displayed as text because they can't be numbers because there are not exactly 3 digits after the thousands separator
Comment 5 Xavier Van Wijmeersch 2018-02-13 17:40:17 UTC 
for comment 3
yes because you setup in tools-options-libreoffice calc-calculate =>
check option "limit decimals for general number format" to 2 decimals
then you have the result for 0.009 => 0.01

so its not a bug, feel free the reopen when not agree