[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
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
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
|
Attachment:
Empty-2choices.ods
Description: application/vnd.oasis.opendocument.spreadsheet
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]