[Linux] What toolkit for a good grid/spreadsheet widget?

[Vincent Delporte]

Hello

I'd like to use Python under Linux to write a business application,
and I'll need a good grid/spreadsheet editable widget, maybe not on
par with eg. ComponentOne's excellent VSFlexGrid
(http://www.componentone.com/newimage...rid_02_lg.gif), but
somewhat professional-grade.

Any recommendation? GTK doesn't seem to have one that is good enough
(GTKSheet http://gtkextra.sourceforge.net/ looks like a basic table),
so I was wondering about QT/PyQt and wxWidgets/wxPython. Any
recommendation?

Thank you
VD.

[Philippe Martin]

Vincent Delporte wrote:

Hello

I'd like to use Python under Linux to write a business application,
and I'll need a good grid/spreadsheet editable widget, maybe not on
par with eg. ComponentOne's excellent VSFlexGrid
(http://www.componentone.com/newimage...rid_02_lg.gif), but
somewhat professional-grade.

Any recommendation? GTK doesn't seem to have one that is good enough
(GTKSheet http://gtkextra.sourceforge.net/ looks like a basic table),
so I was wondering about QT/PyQt and wxWidgets/wxPython. Any
recommendation?

Thank you
VD.

http://www.wxpython.org/

Search for "Grid" here: http://www.wxpython.org/onlinedocs.php

Regards,

Philippe

[Phil Thompson]

On Thursday 03 August 2006 9:54 pm, Vincent Delporte wrote:

Hello

I'd like to use Python under Linux to write a business application,
and I'll need a good grid/spreadsheet editable widget, maybe not on
par with eg. ComponentOne's excellent VSFlexGrid
(http://www.componentone.com/newimage...rid_02_lg.gif), but
somewhat professional-grade.

Any recommendation? GTK doesn't seem to have one that is good enough
(GTKSheet http://gtkextra.sourceforge.net/ looks like a basic table),
so I was wondering about QT/PyQt and wxWidgets/wxPython. Any
recommendation?

PyQt4 has QTableWidget...

http://www.riverbankcomputing.com/Do...blewidget.html

Phil

[Vincent Delporte]

On Thu, 3 Aug 2006 22:07:04 +0100, Phil Thompson
<ph**@riverbankcomputing.co.ukwrote:

>PyQt4 has QTableWidget...

Thx for the two pointers. Are those widgets more than just tables, ie.
can I edit the contents, including displaying a combo box, can items
be grouped or hierarchized, or are they just basic, read-only tables
to display results?

I need this kind of widget to build a 2+ column interface to let users
type entries into the application as an alternative to MS Access-style
complicated entry masks.

[jean-michel bain-cornu]

Hi,

Thx for the two pointers. Are those widgets more than just tables, ie.
can I edit the contents, including displaying a combo box, can items
be grouped or hierarchized, or are they just basic, read-only tables
to display results?

I need this kind of widget to build a 2+ column interface to let users
type entries into the application as an alternative to MS Access-style
complicated entry masks.

Wx have got an excellent one. I was succesful to use it with editable
cells and to include a choice in a cell. However, it was pretty hard to
reach that, ie to extract a working sample from the demo. Once done
that, no more problems with it.
What I suggest you is to have a look on the demo, in the chapter "Core
Windows/Controls -Grid -wx.Grid showing Editors and Renderers".
Rgds,
jm

[Phil Thompson]

On Friday 04 August 2006 2:24 am, Vincent Delporte wrote:

On Thu, 3 Aug 2006 22:07:04 +0100, Phil Thompson

<ph**@riverbankcomputing.co.ukwrote:

PyQt4 has QTableWidget...

Thx for the two pointers. Are those widgets more than just tables, ie.
can I edit the contents, including displaying a combo box, can items
be grouped or hierarchized, or are they just basic, read-only tables
to display results?

I need this kind of widget to build a 2+ column interface to let users
type entries into the application as an alternative to MS Access-style
complicated entry masks.

Yes you can edit cells. QTableWidget implements it's own data model.
QTableView does the same but you supply the model - either a standard one or
one you have written. A standard one is QSqlDataModel so creating a table
that allows you to maintain the contents of an SQL table is about a dozen
lines of Python.

Phil

[Dave Cook]

On 2006-08-04, Vincent Delporte <ju*****@acme.comwrote:

Thx for the two pointers. Are those widgets more than just tables, ie.
can I edit the contents, including displaying a combo box, can items
be grouped or hierarchized, or are they just basic, read-only tables
to display results?

You can display combo boxes in cells in pygtk, as well as edit cells.

But both pyqt and wxpython also offer that. Try running the demos for each.

Dave Cook

[Philippe Martin]

jean-michel bain-cornu wrote:

Hi,

>Thx for the two pointers. Are those widgets more than just tables, ie.
can I edit the contents, including displaying a combo box, can items
be grouped or hierarchized, or are they just basic, read-only tables
to display results?

I need this kind of widget to build a 2+ column interface to let users
type entries into the application as an alternative to MS Access-style
complicated entry masks.

Wx have got an excellent one. I was succesful to use it with editable
cells and to include a choice in a cell. However, it was pretty hard to
reach that, ie to extract a working sample from the demo. Once done
that, no more problems with it.
What I suggest you is to have a look on the demo, in the chapter "Core
Windows/Controls -Grid -wx.Grid showing Editors and Renderers".
Rgds,
jm

Yes, I can also select which cell can be edited on the cell level.

[Vincent Delporte]

On Fri, 04 Aug 2006 10:58:42 GMT, Dave Cook <da******@nowhere.net>
wrote:

>But both pyqt and wxpython also offer that. Try running the demos for each.

Thx everyone!