On Wed, Jun 08, 2005 15:04:26 PM +0200, Eike Rathke ([EMAIL PROTECTED])
wrote:
> 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"?
Below is a mail from KOffice guys which answers to some questions of
mine, making examples. Hope it helps. Again, any feedback is
appreciated. For the record, what I am looking for is an exact
definition of the problem and of the kind of work that needs to be
done to fix it. I am *not* complaining or asking anybody to do it for
me yesterday.
Any further comment is welcome.
TIA,
Marco
#####################################################################
(the ">" quoted text is mine, the unquoted answers are from KOffice
programmer)
> You are absolutely right, sorry, I had not realized this: may I ask
> again the same questions about _this_ issue:
>
> Where is this documented? Examples? Specs?
Last time I checked OASIS does not specify standard formula names yet.
The best way is to start is then from Microsoft Excel documentation
(since we don't have the source code :-)
> Which kind of work must be done?
List all function names in English.
Document what each function does, how are the parameters, etc.
Create test cases (e.g. Excel file which shows the uses of a function,
along with expected result in standard and corner cases).
Note 1: Excel allows localized function name, e.g. SUM in German version
becomes SUMME. This must be investigated as well for translation purpose
(otherwise the translation might not be sync with Excel version in that
particular language). IMHO this is minor issue and can be tackled later on.
Note 2: Some functions are defined as "add in", Excel needs external
module to run this function. Even though there are 3rd party add-in
modules, I think we can first concentrate on standard/builtin add-in
provided by Microsoft Office (e.g. Analysis Toolpak).
> Could any part of the OO.o codebase be imported to add this?
> Is it possible license wise, to use it into a GPL program?
KSpread is LGPL, not GPL. So yes, OO.o code from Calc module may (not
necessarily always can) be imported. In the past Lukas has done this
with some statistical functions.
> Which other technologies does it depend on? Java, anything else?
Java is not needed, unless in OO.o some functions are implemented using
external module/plug-in/add-in in Java.
> In general, what is the relevant KOffice documentation to read, for a
> developer willing to help with this?
For user documentation, nothing is available on this.
Try with the source-code (of KSpread) and post questions here.
> Do you need any other kind of help: documentation, user-contributed
> OO.o spreadsheets to test, anything?
For documentation, in the past I have proposed to generate the DocBook
section containing help with all functions, this can be automatically
created from the corresponding XML help files which are used from
KSpread. However, although this is useful if being printed (as some kind
of reference, I know that manual for Excel, Lotus 1-2-3, and Quattro Pro
always includes such section), it does enlarge the size of the
documentation and was not favorable at that time.
As with test cases, I prefer if we use Excel as we need to be as
compatible as possible with Excel, not OO.o. Thus, we need also to use
Excel files (XLS format) to store the test. I would try my best to
ensure that such test files can be imported properly.
--
Marco Fioretti mfioretti, at the server mclink.it
Fedora Core 3 for low memory http://www.rule-project.org/
Great minds discuss ideas. Average minds discuss events. Small minds
discuss people. -- Admiral Hyman Rickover
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
