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: libreoffice-bugs@lists.freedesktop.org Reporter: heartwoodj...@gmail.com 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.