Bug 92985 - UI: General format: inefficient effect of "Add/Delete Decimal Place" buttons
Summary: UI: General format: inefficient effect of "Add/Delete Decimal Place" buttons
Status: RESOLVED DUPLICATE of bug 85410
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-07-28 16:26 UTC by Laurent Balland
Modified: 2020-07-25 04:03 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Laurent Balland 2015-07-28 16:26:42 UTC
Description: when value contains a lot of digits, General (default) format display only what is possible according to column width. In this case, when using buttons "Add Decimal Place" or "Delete Decimal Places", ### is displayed, because format is switch to "Number" (even if scientific format were used), and number of decimal places is calculated like if column had an infinite width.

Steps to reproduce:
1. Enter a value with a large number of digits, like =PI()*1000, in a cell with General format, and default width of column: 3141.592654 is displayed
2. Hit "Delete Decimal Place" button

Actual behaviour:
### is displayed because format is switch to "Number" with 9 decimal places, which is too big for the column width.

Expected behaviour:
3141.59265 should be displayed.

Bug is worst with scientific format: if value is =PI()*1E11 display is 3.1416E+011. Delete Decimal Place change in Number format with 2 decimal places
Comment 1 Michael Warner 2020-07-25 04:03:45 UTC

*** This bug has been marked as a duplicate of bug 85410 ***