OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


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


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

PGP signature



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]