https://bugs.documentfoundation.org/show_bug.cgi?id=92985
Bug ID: 92985
Summary: UI: General format: inefficient effect of "Add/Delete
Decimal Place" buttons
Product: LibreOffice
Version: Inherited From OOo
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
