Re: [office] OFFICE-3768 empty cell proposal for section 4.7

From
Andreas J Guelzow <>
Date
2020-05-03T21:52:01+00:00
ID
Thread
Re: [office] OFFICE-3768 empty cell proposal for section 4.7
Hi,

    
For me (and Gnumeric), this is an empty cell:

    
<table:table-cellÂoffice:value-type="string"Âtable:style-name="ce2">

    

      
<text:p/>

    

    
</table:table-cell>

    

      

    
After reading 

      

    

      
<table:table-cellÂoffice:value-type="string"Âtable:style-name="ce2">

      

        
<text:p/>

      

      
</table:table-cell>

      

        

      Â
      and

    

    

    

      
<table:table-cellÂoffice:value-type="string"Âtable:style-name="ce2">

      </table:table-cell>

    

      

    
are indistinguishable. The <text:p/> element
          exists only as markup in the saved file, not in the idealized
          spreadsheet. Wanting to distinguish between these two requires
          that otherwise completely identical cells would have meta flag
          whether they are empty or not.

    

        

    
Andreas

        
      

        

      

      

    

      

    

      

    
On 2020-05-03 2:21 p.m., Regina
      Henschel wrote:

    

    Hi
      all,
      

      

      what do you think about the proposal below?
      

      

      I'm not sure about child elements <text:h>. LibreOffice does
      not create such child element in a spreadsheet. When reading a
      file or copy&paste a table from a text document, LibreOffice
      treats an <text:h> element same as an <text:p> element
      and saves it as <text:p> element.
      

      

      Kind regards
      

      Regin
      

      

      

      Proposal
      

      ========
      

      4.7 empty cell
      

      The technical term "empty cell" is used in this part of the
      specification in defining functions and expressions. The technical
      term "empty cell" stands for a cell, for which non of the
      following properties is true:
      

      ÂÂÂ The cell has a table:formula attribute.
      

      ÂÂÂ The cell has a <text:p> child element.
      

      ÂÂÂ The cell has an office:value-type attribute and the
      corresponding value attribute office:value, office:date-value,
      office:time-value, office:boolean-value, or office:string-value,
      respectively.
      

      

      Note:
      

      The markup
      <table:table-cell><text:p/></table:table-cell>
      generates no "empty cell" but a cell containing an empty string.
      

      

---------------------------------------------------------------------
      

      To unsubscribe from this mail list, you must leave the OASIS TC
      that generates this mail. Follow this link to all your TCs in
      OASIS at:
      

https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php 

    
    
-- 

      

        

          

            

              

                
                  
                    

                       
                        
                          
                            

                              
                                

                                  Andreas J. Guelzow,
                                    PhD FTICA 

                                

                                  Registrar
                                    & Director of Enrolment Services

                                

                                  Professor,
                                    Mathematical & Computing
                                    Sciences

                              
                            

                            

                              
                                
Direct:
                                  +1 780 479 9290

                                  Toll-Free: +1 866 479 5200

                              
                            

                            

                              
                                

                                

                                

                                  
                                       
                                

                                

                                  concordia.ab.ca