Date: Sun, 29 Sep 2019 12:25:10 -0400 (EDT) From: Allin Cottrell <cottrell(a)wfu.edu&gt; Subject: [Gretl-users] Re: Gretl crashed again while opening data series with data string that gretl didn't like. To: Gretl list <gretl-users(a)gretlml.univpm.it&gt; Message-ID: <alpine.LFD.2.20.3.1909291219440.28689(a)myrtle.attlocal.net&gt; Content-Type: multipart/mixed; boundary="-1463795199-887823326-1569774310=:28689" ---1463795199-887823326-1569774310=:28689 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable On Sun, 29 Sep 2019, Fred Engst wrote: > Sorry, Allin, more work for you. > When I opened excel file downloaded from FRED called usrec.xls > window opened asking import from c1 r1, so I clicked OK, > it crashed. > This is repeatable. I'm not seeing a crash on Linux. Could you send me a copy of your=20 usrec.xls in case it differs somehow from mine, please? > I found out that the reason for crash has to do with the headers=20 > from the FRED file that had a lot of information before the real=20 > data starts on row 11. > After deleting the first 10 rows, if I save the file > 1. in csv format, it will be OK. The dates are ok too. > 2. in xlsx format, it will not crash, but the dates were not read-in. I= had to set the dates myself. > 3. In xls format, I get this message: > > Expected numeric data, found string: > "1854-12-01" at row 2, column 1 > Perhaps you need to adjust the starting column or row? I'm seeing that message on Linux, but no crash. > So, it shouldn=E2=80=99t crash just because I imported the wrong kind o= f=20 > data. Agreed, it shouldn't. > Furthermore, there is some kind of inconsistency between the=20 > different file format when gretl deciding on the date value. The USREC.xls that I downloaded from FRED is broken (inconsistent)=20 in the dates column. Dates up till 1899-12-01 are flagged as=20 strings, but those from 1900-01-01 are not. This is confusing gretl. Allin

On Sep 29, 2019, at 11:06 PM, Fred Engst <engst.uibe(a)gmail.com&gt; wrote: Sorry, Allin, more work for you. When I opened excel file downloaded from FRED called usrec.xls window opened asking import from c1 r1, so I clicked OK, it crashed. This is repeatable. I found out that the reason for crash has to do with the headers from the FRED file that had a lot of information before the real data starts on row 11. After deleting the first 10 rows, if I save the file 1. in csv format, it will be OK. The dates are ok too. 2. in xlsx format, it will not crash, but the dates were not read-in. I had to set the dates myself. 3. In xls format, I get this message: Expected numeric data, found string: "1854-12-01" at row 2, column 1 Perhaps you need to adjust the starting column or row? So, it shouldn’t crash just because I imported the wrong kind of data. Furthermore, there is some kind of inconsistency between the different file format when gretl deciding on the date value. Thanks in advance for all your work. Fred Attached is the crash report. <gretl_2019-09-29-221714_Fred-Engsts-MacBook-Pro-2018.crash>

Attached is the excel file.