I agree it would be very convenient, and also the existence of a function to extract the content of any particular cell in the spreadsheet so to ubicate it wherever needed (as label, name or value...). That could then be included in a loop of Hansl, vgr.

I've visited the program for Gnumeric you said, finally I think I will stick to making a macro in libreoffice to prepare the data for gretl, as it is a more general solution, you can do lots of things in the data with macros.

Sent: Sunday, May 26, 2019 at 10:55 AM
From: "Riccardo (Jack) Lucchetti" <r.lucchetti@univpm.it>
To: "Gretl development" <gretl-devel@gretlml.univpm.it>
Subject: [Gretl-devel] Re: New feature

On Sun, 26 May 2019, Allin Cottrell wrote:

> Daniel might want to consider batch conversion of Excel or ODS
> files to CSV using soffice or gnumeric. Then gretl's text
> processing facilities could be brought to bear on data files
> that contain descriptive labels as well as series names.

Yes. I've found the "ssconvert" utility from gnumeric very fast and
reliable.

Having said this, it would be nice to have a few more options to the open
command, such as the possibility of skipping some initial lines, or
designating a certain line as the one containing labels, and so on.

-------------------------------------------------------
Riccardo (Jack) Lucchetti
Dipartimento di Scienze Economiche e Sociali (DiSES)

Università Politecnica delle Marche
(formerly known as Università di Ancona)

r.lucchetti@univpm.it
http://www2.econ.univpm.it/servizi/hpp/lucchetti
-------------------------------------------------------_______________________________________________
Gretl-devel mailing list -- gretl-devel@gretlml.univpm.it
To unsubscribe send an email to gretl-devel-leave@gretlml.univpm.it
Website: https://gretlml.univpm.it/postorius/lists/gretl-devel.gretlml.univpm.it/