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
No repro. Please attach a sample ODS.
Earlier versions like the 6.4.7.2 release set in the Version field had a bug that starting input with a decimal separator character cleared the trailing % character (as with any other non-digit character), hence input wasn't a percentage. This was fixed long ago. It's anyway recommended to upgrade from such an old legacy version. *** This bug has been marked as a duplicate of bug 133485 ***