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

[Andreas J Guelzow <andreas.guelzow@concordia.ab.ca>]

The attached file has in A1:
<table:table-cell table:style-name="Gnumeric-default"><text:p/></table:table-cell>
and in A2:
<table:table-cell table:style-name="Gnumeric-default"/>

B1 and B2 have formula calls to determine whether A1 and A2 respectively are blank.

When I open the file in Gnumeric 1.12.47 they both return TRUE.

When I open the file in Libreoffice 5.1.6.2 I also get TRUE !?

Andreas

On 2020-05-03 6:26 p.m., Regina Henschel wrote:

> Hi
>       Andreas,
>       
>       
>       Andreas J Guelzow schrieb am 03-May-20 um 23:51:
>       
> > Hi,
> >         
> >         
> >         For me (and Gnumeric), this is an empty cell:
> >         
> >         
> > <table:table-celloffice:value-type="string"table:style-name="ce2">
> >         
> >         <text:p/>
> >         
> >         </table:table-cell>
> >         
> >         
> >         After reading
> >         
> >         
> > <table:table-celloffice:value-type="string"table:style-name="ce2">
> >         
> >         <text:p/>
> >         
> >         </table:table-cell>
> >         
> >         
> >         and
> >         
> >         
> > <table:table-celloffice: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.
> >         
> >         
> >       
>       
>       Was it changed in Gnumeric? I have tested it with the
>       GnumericPortable_1.12.17 for Windows (newer one does not exist).
>       
>       For a cell A2 generated from markup
>       
>       ÂÂÂÂ <table:table-cell table:style-name="ce2"
>       office:value-type="string">
>       
>       ÂÂÂÂÂ <text:p/>
>       
>       ÂÂÂÂ </table:table-cell>
>       
>       the function ISBLANK(A2) returns FALSE here.
>       
>       
>       Kind regards
>       
>       Regina
>       
>       
> ---------------------------------------------------------------------
>       
>       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

Attachment: Empty-2choices.ods
Description: application/vnd.oasis.opendocument.spreadsheet