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

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

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