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
