Regina, Thanks for the detailed analysis. This is definitely a very messy situation. Notes below.
-----Original Message----- From: Regina Henschel [mailto:rb.hensc...@t-online.de] Sent: Saturday, November 8, 2014 12:32 To: dev@openoffice.apache.org 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. Yes. [..] > > <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. <orcnote> 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. </orcnote> > Assuming that the TextFormatCode text value cannot be taken from a > cell reference A reference to a cell is possible. <orcnote> 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. </orcnote> [ ... ] > > 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? <orcnote> 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. </orcnote> [ ... ] --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
