openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dennis E. Hamilton" <>
Subject RE: color names in Math
Date Sat, 08 Nov 2014 22:09:24 GMT

Thanks for the detailed analysis.  This is definitely a very messy situation.
Notes below.

-----Original Message-----
From: Regina Henschel [] 
Sent: Saturday, November 8, 2014 12:32
Subject: Re: color names in Math

Hi Dennis,

some corrections :( Read my other mail too.

Dennis E. Hamilton schrieb:
> Fascinating.  So there is basically an interoperability bug between the Starmath code
and the MathML RGB coding.


> <orcnote>
>     In the OpenFormula specification of ODF 1.2, the TEXT function format
>     code is left as implementation-defined.  That raises two obligations
>     it seems to me:
>       1. "Implementation-Defined" means the OpenOffice definition must
>     be published in some easily-found form that others can consult for
>     testing, verification, and determination of interoperability cases.

The only reference I know is the in-build help.

	I could only find two examples under TEXT function.  I tried some 
	of the formats under Number Format Codes and I could not make a
     TEXT with Format work at all, using AOO 4.1.1 on Windows 8.1 x64.

>     Assuming that the TextFormatCode text value cannot be taken from a
>     cell reference

A reference to a cell is possible.

	Oh, I read the ODF 1.2 Part 2 6.20.23 incorrectly.  So it is Format
     Code and it is any expression that produces a text value.  So yes,
     References are possible.

     OK, then rewriting between the user and the document format is not
     useful, since these can be from the values in other cells.  So that
     also means any international variations have to all be accepted by
     an OpenFormula consumer with the same implementation-defined
     FormatCode cases.

[ ... ]

>       2. It also means that the definition by other implementations of
>     OpenFormula need to be considered.  The obvious ones that come to
>     mind are the Excel support for ODF OpenFormula, the support in
>     Gnumerics, and of course LibreOffice.  All of these implementations
>     are expected to publish their definitions for TextFormatCode values,
>     and some cooperation would be valuable in this context.
> </orcnote>

That might be better discussed in the ODF TC. Perhaps the OASIS Wiki 
would be a good place to collect such information - with the constantly 
recurring question, who will do it?

	Only Members of the ODF TC can create content on the OASIS Wiki for
     the ODF TC.  Also, I think only members can create JIRA issues.
     They are readable in public, but not writable by anyone but the TC.

[ ... ]

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message