[Gretl-users] Re: fRUSTRATION TRYING TO LOAD AN XLSX DATASET

On 15/12/2025 18:16, Brian Revell wrote: What program did you use to create this file? For some bizarre reason, cell L14 is nonempty, although it looks like it is. I'm not knowledgeable enough with excel to explain why this happens, but: 1. the xml document contains the fragment "*<c r="L14" t="s"><v>4</v></c>*", which I interpret as "cell L14 contains 4", although it's invisible to the eye (at least in LibreOffice and Gnumeric) 2. If you navigate to the top of column L and press Crtl-down, the cursor does indeed jump to cell L14 (again:tried this with both LibreOffice and Gnumeric), although it seems to contain nothing. This confuses the importer. If you delete a few columns to the right of column G ("MSW_PCT"), then the file becomes readable. I guess we could try to robustify our importer, but I have no idea on how we could find a workaround for cases like this. ------------------------------------------------------- Riccardo (Jack) Lucchetti Dipartimento di Scienze Economiche e Sociali (DiSES) Università Politecnica delle Marche (formerly known as Università di Ancona) r.lucchetti(a)univpm.it http://www2.econ.univpm.it/servizi/hpp/lucchetti -------------------------------------------------------