[Gretl-devel] Problems with the .xlsx

Dear Allin, I think we still have some problems with the .xlsx files: Sometimes Gretl (version 1.9.7 / build date 2012-03-01 / Windows Vista) can't see the data structure. This is a intriguing issue because even when the spreadsheets are equal (at least visually) Gretl shows a different behavior. Please take a look at the Teste.xlsx file attached. In that file we have two sheets with the same information. With the command, open C:\Users\f1831737\Desktop\Teste.xlsx --rowoffset=8 --sheet="IBC-Br SA" Gretl doesn't define the data structure (time series). But with the command, open C:\Users\f1831737\Desktop\Teste.xlsx --rowoffset=8 --sheet="IBC-Br SA (2)" Gretl defines my data as a time series. If I try to open via the GUI I get the following message/results: <message> 'IBC-Br SA' -> worksheets/sheet1.xml Found 6 variables and 385 observations" </message> And Gretl can not see the correct data structure. The same command in the second sheet gives me: <message> 'IBC-Br SA' -> worksheets/sheet1.xml didn't get worksheet xmlParseFile falhou em xl\rId2 </message> And Gretl doesn't open the data. Allin, sorry for bugging you (and all the list members) again with this subject, but I think the easiness of the data opening is one of the most important features of Gretl and, because of that, it's very important maintain its correct functioning. -- Henrique Andrade