Bug 112073 - Adding or removing decimal to a number coming from a fomula leads to ###
Summary: Adding or removing decimal to a number coming from a fomula leads to ###
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-08-28 21:00 UTC by Damien Petitjean
Modified: 2017-08-29 09:52 UTC (History)
1 user (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 Damien Petitjean 2017-08-28 21:00:40 UTC 
Description:
Adding or removing decimal to a number coming from a formula leads to ###.
No problem when the decimal number is a direct input in the cell.

Steps to Reproduce:
1. Input a formula like =-(2330*12+11172/18)
2. Try to add or remove decimals with the ad-hoc buttons


Actual Results:  
###

Expected Results:
A number with less or more decimals...


Reproducible: Always

User Profile Reset: No

Additional Info:
Decimal mark is the comma.


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:55.0) Gecko/20100101 Firefox/55.0
Comment 1 Regina Henschel 2017-08-28 22:43:50 UTC 
The ### indicates, that the column is not wide enough to show all digits. If you add or remove decimal places you leave the default number style where so many digits are used, that all are visible.
To solve your problem you can remove more digits or you can make the column wider.
Comment 2 Damien Petitjean 2017-08-29 09:52:54 UTC 
Indeed ! Thanks for the explanation.
I guess it would be more natural to add or remove digits from the number that is displayed.