Re: [oic] application scenario The Hague

[robert_weir@us.ibm.com]

KOffice wasn't at the Beijing workshop.  But we did try OpenOffice, 
Symphony, Google Spreadsheets and Excel (via the Sun Plugin).

In any case, we need to distinguish namespace compatibility from the 
compatibility of the calculation engine.  You need to get past the 
namespace issues (some newly introduced) to even get to the real 
calculations.  The two issues I know of are OO 3.1's use of the ODF 1.2 
namespace, which not all applications are prepared to handle.  And Office 
2007 SP2 uses an OOXML namespace (and syntax) which other applications do 
not understand.

There are three levels to be concerned with:

1) Namespace
2) Syntax
3) Semantics

Level 1 is trivial and not really an interesting workshop topic. 

Topics 2 &  3 are the core, and I would prepare spreadsheets in several 
combinations of namespaces and syntax so all implementations at the 
workshop could test their semantic understanding of the formulas, i.e., do 
they yield correct results, according to the draft OpenFormula.

-Rob

Andreas J Guelzow <aguelzow@math.concordia.ab.ca> wrote on 05/31/2009 
08:59:02 PM:


> On Sun, 2009-05-31 at 20:12 -0400, robert_weir@us.ibm.com wrote:
> 
> > For spreadsheet, I do have the test cases from the Beijing workshop. I 

> > think we can can make useful progress with those, since we're very 
close 
> > already, from the formula calculation perspective. 
> 
> Pretty close?
> 
> I have just tried out kspread 1.9.99 (from debian experimental). It
> can't read any of the formulae saved by Gnumeric or Openoffice.org 3.1.
> Of course there is a chance that kspread 2.0 has improved on that.
> So we have interoperability for formulae between which implementations? 
>