Re: [Gretl-users] Open document data import.
On Tue, 6 Jan 2009, John C Frain wrote:
Is there a problem with open document import in recent versions
of gretl 1.9.1cvs. On Windows XP gretl cvs (built date
2009-1-1) will not recognise the date column in the attached
data set. Gretl 1.7.9 cvs 2008-12-12 built in Ubuntu 8.04 will.
The attached is only the first few records of a data set
containg over 5000 records.
Current CVS gretl on Linux will read the dates from that file OK.
I'll have to test on Windows.
If I export the data set to excel (XP) I get a message similar
to that below when I try to read the import the excel data set
(in both windows and ubuntu). 32146 is the integer
representation of the first date in the data set...
The difficulty here is that the dates column in your file is
defined via a formula. Gretl can handle XLS-format dates OK, but
not if they're created via formula. However, I've now added a
check to see if there's a date formula in the first column, so it
should work in future.
Allin.