RE: [oic] OOoCon and ODF tests

[Andreas J Guelzow <aguelzow@math.concordia.ab.ca>]

On Mon, 2008-11-10 at 05:48 +0100, Hanssens Bart wrote:
> Hi Andreas,
> 
> 
> Andreas Guelzow wrote:
> 
> >> Overall, formula interop was very good (at least for the
> >> configurations that were tested that day)
> >
> >Where in the ODF specs are spreadsheet formulas specified?
> 
> They aren't (at least not in 1.1). ODF 1.1 implementations
> tend to use an openoffice.org namespace or use a draft of the
> upcoming ODF 1.2 OpenFormula.

Well, there aren't any definitions available for the ooo= namespace.
Moreover while they might be using the OpenFormula Draft, I would more
likely suspect that they typically implemented functions that emulate
what MS Excel is doing. 

Since the OpenFormula draft is full of "implementation defined"
sections, I would love to know where those sample formulae came from. 

> So unfortunately, for the time being, interop in this area
> can only be achieved in a non-standard way.

I don't think that, with respect to spreadsheets, ODF and/or OpenFormula
brings us any closer to interoperability. So I was quite surprised to
read that spreadsheet formulas were used for this little exercise.

Andreas 
-- 
"Liberty consists less in acting according to
one's own pleasure, than in not being subject 
to the will and pleasure of other people. It 
consists also in our not subjecting the wills 
of other people to our own."  Rousseau


Prof. Dr. Andreas J. Guelzow
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta