Em 16 de fevereiro de 2010 Allin <cottrell@wfu.edu> escreveu:

On Tue, 16 Feb 2010, Henrique Andrade wrote:

> So I would like to request you to allow multiple selection on
> Gretl's built-in spreadsheet in order to copy, cut, and paste
> data just like Gnumeric, Excel, and others do. Is this possible?

Could you describe exactly what your colleagues would like to be
able to do?
 
Usually they need to update only the last 12 observations (monthly basis) of a series with some reviewed data. However, sometimes these data are not updated in the original spreadsheet, so they (my colleagues) need just to substitute part of the data.
 
In terms of modifications to gretl, I think it would be more
productive to spend time making "Data append/update" easier and
more fool-proof rather than trying to extend gretl's spreadsheet
capabilities: gretl will never be very good as a spreadsheet,
compared to the programs that specialize in that.
 
I think Patricio's suggestions are very good:

Em 16 de fevereiro de 2010 Patricio <patriciocuaron@gmail.com> escreveu:

I agree. A couple of suggestions:
  1. One thing that would be an improvement is that presently yo must have exactly the same number of observations in the data to be imported as you have in gretl. If you have 1990-2006 in gretl and 1980 - 2009 in a csv or in Excel, gretl says "Data frequency does not match". The improvement would be to use the same dialog that it shows up when you /main/file/open/import/excel, which lets you choose the first observation, and also don't stop if you are importing from a file with observations ranging from 1990-2009 due to the 'extra' 3 final observations.
  2. The spreadsheet import dialog could a sample of the first observations to be imported (just write a ascii-formatted table with the first cells to be imported).
    1. That dialog resizes badly, with lots of wasted space.
    2. The sheet to import from list box defaults to an unnecessarily small size that only shows 3 lines at a time; most my spreadsheets have way more that 3 sheets. And scrolling is too slow (default gtk control settings?).
    3. Csv imports could also benefit from a preview, even in an ascii-formatted table way.
  3. When you drag and drop a file into gretl's window, it asks to close the current session and open the draganddropped file. Maybe that dialog could be changed into: "You drag and dropped a file, do you want to: [append data] [replace data] [open in another session] [do nothing - cancel]".

Best,
Henrique