Am 14.06.2013 um 19:11 schrieb Allin Cottrell <cottrell(a)wfu.edu>:
On Fri, 14 Jun 2013, Henrique Andrade wrote:
> I'm trying to open an Excel spreadsheet but Gretl shows me an error
> message. I don't understand what is going wrong once I've worked with this
> data before with no issues (please find attached the "teste.xlsx" file).
Thanks. The trouble with this xlsx file is that the "empty"
cells (e.g. the missing "cambio" value for 1995/01/01) are not
truly empty, rather they are marked as string cells containing
an empty string. (If you open the file in gnumeric you see a
single-quote character in those cells, indicating their
"stringy" nature.) This is weird/broken; however, we can work
around it by treating cells containing empty strings as empty.
That's now done in CVS.
(As a general point, xlsx files often tend to contain
invisible nonsense, only apparent if you unzip the file and
inspect the underlying XML. Go Microsoft!)
May it be that there is 'nonsense'. I think that Excel should not be used as a
'simple' spreadsheet program, but foremost for it's powerful 'Tables'
and 'PivotTables' (in combination with functions and UDFs).
That this a rarely the case is a pity.
Gretl-users mailing list