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

> 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?

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.

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]".