OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

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


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


After reading




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.


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

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.

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:

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


Concordia University of
                                      Edmonton Twitter Concordia University of
                                      Edmonton Instagram Concordia University of
                                      Edmonton Facebook

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]