Re: [office] spreadsheet table:cell/table:table (was: [office]OpenDocument TC coordination callminutes 2007-08-13)

["Florian Reuter" <freuter@novell.com>]

I'll take a look at the formula spec.

I just want to make sure that we all have the sme understanding of the semantic of tables-in-tables and sub-tables for spreadsheets. 

I don't want the same to happen as with the paragraph numbering in ODF1.0 and ODF1.1 where it was simply not clearly specified and at the end two different interpretations where implemented.

~Florian



>>> Eike Rathke <erack@sun.com> 08/20/07 3:39 PM >>>
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"?

>    <table:table table:name="Sheet1" table:style-name="ta1" table:print="false">
>     <table:table-column table:style-name="co1" table:number-columns-repeated="3" table:default-cell-style-name="Default"/>
>     <table:table-row table:style-name="ro1">
>      <table:table-cell table:formula="oooc:=[.B1]*[.C1]">
>      <!--- what is the value ??? -->
>      </table:table-cell>
>      <table:table-cell >
>       <table:table>
>       <table:table-cell office:value-type="float" office:value="10">
>       <text:p>10</text:p>
>       </table:table-cell>
>       </table:table>
>      </table:table-cell>
>      <table:table-cell office:value-type="float" office:value="20">
>       <text:p>20</text:p>
>      </table:table-cell>
>     </table:table-row>
>    </table:table>
>    <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">
>     <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
>     <table:table-row table:style-name="ro1">
>      <table:table-cell/>
>     </table:table-row>
>    </table:table>
> 
> 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 
>       <table:table>
>       <table:table-cell office:value-type="float" office:value="10">
>       <text:p>200</text:p>
>       </table:table-cell>
>       </table:table>
>  
> 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 <td><table><tr><td>nested</td></tr></table></td> 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