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@gretlml.univpm.it escribió:
Asunto:
[Gretl-devel] Re: bug in xls importer?
De:
Allin Cottrell <cottrell@wfu.edu>
Fecha:
15/9/21 23:28
Para:
Gretl development <gretl-devel@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