Hi M., On Tue, Jun 07, 2005 at 08:00:32 +0200, M. Fioretti wrote:
> talking with KOffice developers I was told that the most urgent > problem, in order to achieve full spreadsheet compatibility between > KOffice and OO.o, is: > > > standardizing spreadsheet formula language first - yes, this is NOT > > part of OASIS at the moment, and is a potentially huge hurdle for > > interoperability. What exactly are you referring with "formula language"? > I am collecting relevant info for all developers who would like to > help with this problem, so any feedback on the issues below is very > welcome (together with any other general comment, of course) > > Where is OOCalc and/or OpenDocument formula language documented? > Examples? Specs? Are OOCalc and OpenDocument different from this point > of view? If yes, how? Do you mean the representation of spreadsheet formulas? The UI representation is slightly different from the representation in the file format, for example a cell reference in UI is Sheet.A1, in the file format it is [Sheet.A1] including the square brackets; references relative to the same sheet may omit the sheet name in the file format too, but the dot '.' is included there, like in [.A1]. But these things _are_ specified in the OpenDocument specification, see the Formula section of "8.1.3 Table Cells" and "8.3.1 Referencing Table Cells". > Could any part of the OO.o Calc codebase be imported in Kalc to > achieve full compatibility? Which one? Is it possible license wise, > to use it into a GPL program? IANAL, but as the OOo code is dual licensed, SISSL and LGPL, that should be possible. Though I currently don't have an idea what OOoCalc code could be reused in Kalc as I don't know the Kalc code, and I don't know where the incompatibilities are. > How many formulas depend from not immediately portable technologies > like Java or OO.o macros? None of the built-in functions or the AddIn functions OOo delivers. > In general, what is the relevant OO.o documentation to read, for a > developer willing to help with this? Of course the OpenDocument specification available at http://www.oasis-open.org/committees/office/ OOo specific information about the XML file format is available at http://xml.openoffice.org/ > And the OO.o developers list > where to go for a more technical common discussion? For XML specific topics it is [email protected], to subscribe mailto:[EMAIL PROTECTED], for Calc related topics it is this [email protected] here, to subscribe mailto:[EMAIL PROTECTED], and for general development topics it is [email protected], to subscribe mailto:[EMAIL PROTECTED] Hope this helps as a starting point. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
