https://bugs.documentfoundation.org/show_bug.cgi?id=150843
Bug ID: 150843
Summary: Percentage Formatted cells are inconsistent in data
entry - Leading zeros create different results
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Marked as MAJOR error as data entry in a spreadsheet is a fundamental basic
expectation and would lead to errors in calculation whilst leaving little
visual clue to the fault.
If a cell is formatted to Percentage Format (to 2 decimal places in this
example but that's not important), then typing the following figures gives
inconsistent results.
10 gives 10.00%
.1 gives 10.00% If .1 is pasted, gives 10.00%
0.1 gives 0.10% If 0.1 is pasted, gives 10.00%
1 gives 1.00%
.01 gives 1.00%
0.01 gives 0.01%
During typing, typed entries starting with a digit are rendered as percentages
during typing but entries starting with decimal point (not tested for other
locales e.g. decimal comma) assume non percentage format but then applies
format after entry.
Anyone entering a column of numbers could easily be caught out by this. It
would appear like data entry error.
Reproduceable: Always
Expected: Consistency
--
You are receiving this mail because:
You are the assignee for the bug.
