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


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


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