Formatting in spreadsheet

[Rob Jasper <Rob@famJasper.nl>]

 Hi,

I have a problem saving customer number format #.##0,00# on ods files.

Background:

I am using LibreOffice. I have a spreadsheet in which I keep my stamp collection. 

In one of the columns I keep the orginal face value of the stamp. Normally this is a value of X dutch guilders and YY cents, which is denoted as X,YY (we use a , for decimal separator). Example 0,25 for a quarter.

My problem is that in the older stamps there are values like 12 and a half cents, which I denote at 0,125. So far so good. Now I want the extra 3rd digit only to be displayed when actually used. So, I see values like:

0,25
0,30
0,125

LO processes this fine, if a save the .ods file and reopen it the formatting of the column has changed to 0,000 . Above fields are then displayed as:

0,250

0,300

0,125

According to the LibreOffice folks the ODF standard does not allow this. If I save in oodoc (.xlsx) the formatting stays in tact. Of course I want to save in a real standard :-(.

Can you confirm the opinion of the LO people? 

If this is the case, than I really feel this is a flaw or omision in the standards.

How can I get this on the radar to be repaired in the standards?

Regards,
Rob Jasper,
Netherlands.