[odf-discuss] Failure of MOOX for numbers in spreadsheets

[Lars Noodén]

Thanks for the link to that thread.

Sander Marechal wrote:
> It looks like OOo does store the entered number correctly, but the
> visual formatting may differ. For example: entering 1234.1233999999999
> in a cell and doing a save&reload will show 1234.1234. But the original
> value is still preserved in the office:value attribute.

I'm finding that OOo 2.3 handles 1234.12339999999 correctly but not
1234.123399999999 or anything else of greater precision.

1234.12339999999 gets stored as 1234.12339999999, but
1234.123399999999 gets stored as 1234.1234

However, that's a bug in the application not the specification /
standard for the data.

Regards,
-Lars