OASIS Open Document Format for Office Applications (OpenDocument) TC

Hi all, I thought it might be useful to have a test document with edge cases. In case you resave the document, please make sure, that the cell contents <text:p/> <text:p><text:s/></text:p> are still there and not removed by your application. I've got Excel 365, but not Gnumeric. Andreas, can you please look, what Gnumeric results? Kind regards Regina Attachment: TestEmptyCell_ODF12strict.ods Description: Binary data

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). Andreas On 2020-04-15 8:55 a.m., Regina Henschel wrote: Hi all, I thought it might be useful to have a test document with edge cases. In case you resave the document, please make sure, that the cell contents <text:p/> <text:p><text:s/></text:p> are still there and not removed by your application. I've got Excel 365, but not Gnumeric. Andreas, can you please look, what Gnumeric results? 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

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 Regina

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. Andreas 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 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