Re: [Gretl-devel] Built-in spreadsheet improvement

On Sun, 21 Feb 2010, Henrique Andrade wrote: > I think I need to change my question (I wrote one thing while thinking > about something else, sorry). > >> On Sat, 20 Feb 2010, Henrique Andrade wrote: >> >> I would like to suggest the inclusion of the options "--sheet=", >> "--rowoffset=", and "coloffset=" in the GUI. What do you think? > As you sad, "the choice of column and row (under "Start import > at" in the GUI dialog) play exactly the same role as --coloffset > and --rowoffset in CLI mode." > > But what I'm suggesting is: > > I would like to suggest the improvement of the options > "--rowoffset=", and "coloffset=" in the GUI and CLI, in order to > allow the selection of specific rows and columns. Let's suppose > we want to open only the first and third row of the table. How > could you do that using the options"--rowoffset=", and > "coloffset="? Not possible via --rowoffset plus --coloffset, and not possible via the GUI either. But personally I don't think this is worthwhile. It is difficult enough to parse spreadsheet files without adding this extra complexity. I would say, if you want to send to gretl specific chunks of a spreadsheet, then: i) In your spreadsheet program, add a new worksheet. ii) Copy the bits of the data that you want to send to gretl, paste these into the new sheet, and save the file. iii) In gretl, use the worksheet selector to choose the specific sheet containing the material you want, and open the data. iv) Back in the spreadsheet program, delete the new gretl-oriented sheet if you have no further use for it.