Re: [office] Empty Cell by @office:value-type

From
Andreas J Guelzow <>
Date
2020-05-11T02:43:19+00:00
ID
Thread
Re: [office] Empty Cell by @office:value-type
Hi,

    

    

    
On 2020-05-10 4:35 p.m., Svante
      Schubert wrote:

    

    
      
The first cell is easy a cell with
        string content and string type. Clearly not empty andÂFALSEÂas
        the result of isBlank()!

    
    yes, agree

    
      
The second cell has an empty string.
        String type with empty paragraph. This case is explicitly
        mentioned in part 2 and the result of isBlank() should beÂTRUE!

    
    as I mentioned in an email, ODF specifically states that cells
    containing the empty string are not empty. So the correct answer
    here is FALSE. (Which is also what you said in the file
    proper).)

    
      
The third cell is a completely empty
        cell without descendant nodes. It can not be more blank.ÂTRUEÂshould
        be the result of isBlank()!

    
    yes agree

    
      
The fourth cell has an empty
        paragraph but no data type attribute.ÂÂTRUEÂshould be the
        result of isBlank()!

    
    First of all, this should really never exist. ODF is currently mute
    on what the value of this cell is. According to my reading, in the
    absence of the value type it is not defined what the value of the
    cell is. Since the value type is not given in this case, I am really
    do not know whether "the value type is not string" is true or false.
    It really cannot be true since we do not have a "corresponding value
    attribute".

    
      
The fifth cell has a paragraphÂwith
        text content but no data type attribute.ÂTRUEÂshould be
        the result of isBlank()! 

      

    
    same as the previous one.

    
      
The sixth cell has a paragraphÂwith
        text content but an invalid data type attribute.ÂTRUEÂshould
        be the result of isBlank()!

    
    
This is not valid ODF. So anything is possible. 

    

    
There is also a seventh cell, but again that is not valid ODF.

    
Andreas

    

    

    

    

    

    
-- 

    

    

      

        

          

            

              

                
                  
                    

                       
                        
                          
                            

                              
                                

                                  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