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

Those structures are generated by Gnumeric and Excel 2016 if the cell contains the empty string, I.e. in a situation where the cell is not empty.


Sent from my Samsung Galaxy smartphone.

-------- Original message --------
From: Regina Henschel <regina.henschel@libreoffice.org>
Date: 2020-04-21 02:16 (GMT-07:00)
To: office@lists.oasis-open.org
Subject: Re: [office] OFFICE-3768 empty cell

Hi Andreas,

Andreas J Guelzow schrieb am 20-Apr-20 um 19:16:
> Hi,
> Gnumeric's results match on all rows except row 9. The difference is
> also that A9 in fact contains the empty string for Gnumeric.
> So I had a further look at Excel (in my case Excel 2016). If I enter an
> empty string in Excel 2016 in A1 (i.e. by typing just ') and enter
> =ISBLANK(A1) in A2, then A2 shows as FALSE. If I save the file as an ODF
> file and reopen, the Excel 2016 shows TRUE in A2 and has lost the
> content of A1.
> I do not know how I can enter the empty string into a cell in
> Libreoffice (without using a formula).

Yes, I too cannot enter an empty paragraph via UI in LibreOffice. But
spreadsheets are also generated by programs.

Imagine a program which uses a pattern
<table:table-cell><text:p></text:p></table:table-cell> and puts values
into the paragraph element or not, depending whether a value is
available or not. Those values might have their origin in measurement or
database, for example.

I have not found a rule which forbids such structure. Therefore I think,
the standard should consider it for defining "empty cell".

Kind regards

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:

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