OASIS Open Document Format for Office Applications (OpenDocument) TC

Hi Lars,

just to be more precise here. I guess the real problem is that the formula spec does not cover all potential spreadsheet instances ---- or are we wrong here?

Maybe this is a question for the formula SC? What you do think?

~Florian

>>> "Florian Reuter" 

Florian,

Florian Reuter wrote:
> Hi Lars,
>
> just to be more precise here. I guess the real problem is that the formula spec does not cover all potential spreadsheet instances ---- or are we wrong here?
>
>   
I haven't started proofing the formula proposal in detail but from 
memory it does deal with arrays. I seem to remember that cells that 
contain matrices are flagged in some manner.

So, perhaps, only perhaps because I don't know, treatment of a cell as a 
matrix where it doesn't have the appropriate flag is an error.
> Maybe this is a question for the formula SC? What you do think?
>
>   
I suspect so since formulas would be where such flags and errors would 
be defined.

Hope you are having a great day!

Patrick
> ~Florian
>
>   
>>>> "Florian Reuter" 

Hi Florian,

On Tuesday, 2007-08-14 12:30:14 +0100, Florian Reuter wrote:

> just to be more precise here. I guess the real problem is that the formula spec does not cover all potential spreadsheet instances ---- or are we wrong here?

You might want to read the formula spec, in this case section "5.8
References". Or what are you referring with "cover all potential
spreadsheet instances"?

>    
>    
> 
> What we want to illustrate with the above fragment is the question what a "table" multiplied by constant means?

You don't multiply the table with a constant, you multiply B1*C1 and B1
does have no office:value attribute, so your result is zero.


> If we leave that up to the implementation two (or more...) possible interpreations might be
> a) **ERROR
> b) Table is treated as an inline-array, thus the reasult might be 
>       
>  
> So what we wanted to outline here is that there is a definition whole in the ODF spec. 

There isn't. Same as in HTML, if there is no text in a cell, it has no
content, e.g. in 
nested
 the
text "nested" is not part of the outer cell's content.

> Our preferred solution would be to remove subtables/sections, etc from the schema.
> 
> Proposal:
> ========
> 
> Change the ODF schema in a way, that table-cells in a spreadsheed applications can not contains subtables, sections and headings.

-1 for deprecating nested tables, undecided about sections and headings
and other things that make sense almost only in text processors.

Btw, your mailer setup still produces mails that break every thread you
reply to. Please ask your colleague Kohei how to setup GroupWise
properly to have that fixed, thanks.

  Eike

-- 
 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS

On Mon, 2007-20-08 at 15:39 +0200, Eike Rathke wrote:
> Hi Florian,
> 
> On Tuesday, 2007-08-14 12:30:14 +0100, Florian Reuter wrote:
> 
> > just to be more precise here. I guess the real problem is that the formula spec does not cover all potential spreadsheet instances ---- or are we wrong here?
> 
> You might want to read the formula spec, in this case section "5.8
> References". Or what are you referring with "cover all potential
> spreadsheet instances"?

A spreadsheet in Open Document Format need not use the OpenFormula specs
but could use any other formula specs desired by including the
appropriate prefix in the formula. So clearly there could be (in fact
there are) spreadsheet instances not covered by OpenFormula.

Andreas
-- 
Andreas J. Guelzow, Professor
Dept. of Mathematical & Computing Sciences
Concordia University College of Alberta