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

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

HI,

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.
>       
>

I do not recall changing that. In current Gnumeric (1.12.47) it returns TRUE. Gnumeric is only released in source and it is not supported on Windows. 1.12.17 is from June 2014. Most of the import of cell content text formatting was written more recently than 1.12.17.

On import from ODF GNunmeirc converts everything into its own data structures and it is not clear to me how, in 1.12.17,

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

would be distinguished from

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

after import.

Andreas

>       
>       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