I am setting a value for cell padding, but when I inspect it later, it has changed slightly e.g. set to 0.5mm. then on later inspection it will be 0.49mm.
Steps to reproduce in LibreOffice Calc, 7.3.2.2 (x64) on Windows 10. UK
- I have my units set to millimetre
- open a new sheet; select all cells; Format Cells (Ctrl+1)
- Borders > Padding
- uncheck Synchronise
- set Left padding to 0.50mm
- press OK to save
What I expect to happen:
- open the Format Cells dialog and the left padding should be 0.50mm
What actually happens:
- the value is set to 0.49mm
It’s not just the Left padding: all paddings have the same issue. It seems to corrupt all values slightly e.g. 1.00 is changed to 1.01 etc.
This does not happen when Synchronise is checked: I can set values like 0.49 or 1.50 and they are round-tripped as expected.