Hi,
this file was created with Libreoffice 6.4.7.2 (in Ubuntu 20.04). I am
seeing now that a file properly saved by excel did not have this
problem. In any case, thank you for solving this error.
Ignacio
El 16/9/21 a las 0:00, gretl-devel-request(a)gretlml.univpm.it escribió:
Asunto:
[Gretl-devel] Re: bug in xls importer?
De:
Allin Cottrell <cottrell(a)wfu.edu>
Fecha:
15/9/21 23:28
Para:
Gretl development <gretl-devel(a)gretlml.univpm.it>
On Tue, 14 Sep 2021, Allin Cottrell wrote:
> One more observation: if I open Ignacio's Salarios.xls in gnumeric,
> then save it as xls, gretl can read both the numeric and the
> string-valued columns OK.
>
> I'm therefore reinforced in my belief that this is an OpenOffice bug,
> or maybe some inscrutable xls quirk.
Ah, but... we were led astray by one element of the xls file, but once
we figured out that was a false trail we failed fully to recompute.
Now we do so, meaning that in current git (and in the next release)
gretl will manage to import the string-valued series in Ignacio's
Salarios.xls successfully.
So thanks, Ignacio, for posting what eventually turned out to be an
instructive example.
Allin
--
Ignacio Díaz-Emparanza
Departamento de Métodos Cuantitativos
Universidad del País Vasco - Euskalherriko Unibertsitatea, UPV/EHU
Tfno: (+34) 94 601 3732