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.
"In principle", gretl could save you a few clicks by offering to
import specific rows and/or columns, but the saving of a few
clicks would come at the cost of very substantial coding effort.
Offer me lots of money and I _might_ be interested, otherwise I'm
afraid not ;-)
Allin.