On 14-07-02 06:39 PM, Dennis E.
There are no "formatting strings" in ODF. Number formatting is
achieved via the <number:number-style> element. The
interesting child element in this context is <number:number>.
Rob, I have no idea how an
enhancement request could be defined. I have not found
where the handling of formatting strings is prescribed in
I assume you are referring here to some sort of "native ODF
application" whatever its definition may be. ODF is a file-format it
really does not (and should not) say anything about an applications
Perhaps someone who says that is the problem can
point us to where that limitation can be found in the ODF
There is only one ODF format
definition and it is independent of production and
There is nothing in ODF that
would have round-tripping fail. If the application
can’t actually produce something in a document that you
attempted to represent, it should not have presented it to
you as if it would.
The only sensible definition of "ODF-native" that would make this a
true statement uses probably exactly this property I would think.
That is not something the ODF
specification can fix. Round-tripping
failures of an ODF-native product with itself are not
possibly originated in the ODF specification.
Not-with-standing this, since ODF allows for extensions in its
extended-conformance class, any application in fact can round trip
any file through (extended conforming) ODF.
(I am not on the ODF TC, so you
should first start by having someone identify where this
situation is determined in the ODF specification. Then the ODF TC can
decide if there is an actual issue.)
The default formatting of the column is
Then I created conditional formatting
to be 0,00 with the following formula: MOD(C2;0,01)=0
This is a great workaround!
Still, it is weird that the original
formatting works, and round-trips through .xlsx, but
not through ODF...
Also, MS Excel picks it up.
So, the functionality is there, but
it can;t be saved in ODF.
Should this be worded as an
enhancement request, and how do I do that?
Op 2 jul. 2014, om 22:12 heeft
Dennis E. Hamilton het volgende geschreven:
I think you can do this, but perhaps not the way
I don’t know where in the ODF specification there
is any rule about formats like "#.##0,00#", but
you can do it with conditional styles.
That is, try creating a conditional style on
whether the value *100 is an exact integer or not,
and then have 2 digits after the decimal or 3,
depending on the condition result. That’s
definitely possible in ODF and the only question
is whether it is supported by the Calc
implementation of your choice.
-- Dennis E. Hamilton
PGP F96E 89FF D456 628A
PS: It seems to me that accepting values and
presenting them as you expect, but not
round-tripping that form with itself, is a bug
regardless of how the ODF specification is being
interpreted for this case.
- - - - - Original Message - - - - - -
From: Rob Jasper [mailto:Rob@famJasper.nl]
Sent: Wednesday, July 2, 2014 10:11
Subject: [office-comment] Formatting in
I have a problem saving customer number format
#.##0,00# on ods files.
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:
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
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
This publicly archived list offers a means to
provide input to the
OASIS Open Document Format for Office Applications
In order to verify user consent to the Feedback
License terms and
to minimize spam in the list archive, subscription
List help: firstname.lastname@example.org
List archive: http://lists.oasis-open.org/archives/office-comment/
Feedback License: http://www.oasis-open.org/who/ipr/feedback_license.pdf
List Guidelines: http://www.oasis-open.org/maillists/guidelines.php
Join OASIS: http://www.oasis-open.org/join/
Andreas J. Guelzow
Professor of Mathematical & Computing Sciences
Concordia University College of Alberta