OASIS Open Document Format for Office Applications (OpenDocument) TC

  • 1.  Re: [office] OpenDocument TC coordinationcallminutes 2007-08-13

    Posted 08-14-2007 11:31
    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" 


  • 2.  Re: [office] OpenDocument TC coordination callminutes 2007-08-13

    Posted 08-14-2007 11:48
    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" 


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

    Posted 08-20-2007 13:40
    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


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

    Posted 08-20-2007 20:05
    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