Advice about using Grid

Hello!

I write these lines to ask some advise about what control is the best for this kind of tasks: I'll need to create a sheet like excel, to allow some predefined calculations and some input from the user.

For example in the sheet 1 the operation A1+A2=A3 will be executed each time the user loads that screen and others operations more in the same sheet... user can add the value in A2. SO I need to control some events, edit options, make calculations, etc.

I want to know if the wxGrid is the best control for the task or you can recommended another one?

Thanks in advance!

···

--

Saludos / Best regards

Mario Lacunza
Email:: mlacunza@gmail.com
Personal Website:: http://www.lacunza.biz/
OpenOffice.org:: http://es.openoffice.org/
OpenOffice.org Perú:: http://openoffice-peru.com/
Hosting:: http://mlv-host.com/
Mascotas Perdidas:: http://mascotas-perdidas.com/
Google Talk: mlacunzav Skype: mlacunzav
MSN: mlacunzav@hotmail.com Y! messenger: mlacunzav

You might find it worth taking a look at PySpread
http://manns.github.com/pyspread/ either to give you some hints, to use
as is, or to join in the maintenance effort.

Gadget/Steve

···

On 24/06/2012 6:11 PM, Mario Lacunza wrote:

Hello!

I write these lines to ask some advise about what control is the best
for this kind of tasks: I'll need to create a sheet like excel, to
allow some predefined calculations and some input from the user.

For example in the sheet 1 the operation A1+A2=A3 will be executed
each time the user loads that screen and others operations more in the
same sheet... user can add the value in A2. SO I need to control some
events, edit options, make calculations, etc.

I want to know if the wxGrid is the best control for the task or you
can recommended another one?

Thanks in advance!

Hello

looks nice but I need to embed the sheet into my program, only cells no toolbars and ets... anyways I'll look the code too, thanks!!

What control are you using for it?

Saludos / Best regards

Mario Lacunza
Email:: mlacunza@gmail.com
Personal Website:: http://www.lacunza.biz/
OpenOffice.org:: http://es.openoffice.org/
OpenOffice.org Perú:: http://openoffice-peru.com/
Hosting:: http://mlv-host.com/
Mascotas Perdidas:: http://mascotas-perdidas.com/
Google Talk: mlacunzav Skype: mlacunzav
MSN: mlacunzav@hotmail.com Y! messenger: mlacunzav

···

El 24/06/12 13:13, Gadget/Steve escribió:

On 24/06/2012 6:11 PM, Mario Lacunza wrote:

Hello!

I write these lines to ask some advise about what control is the best
for this kind of tasks: I'll need to create a sheet like excel, to
allow some predefined calculations and some input from the user.

For example in the sheet 1 the operation A1+A2=A3 will be executed
each time the user loads that screen and others operations more in the
same sheet... user can add the value in A2. SO I need to control some
events, edit options, make calculations, etc.

I want to know if the wxGrid is the best control for the task or you
can recommended another one?

Thanks in advance!

You might find it worth taking a look at PySpread
http://manns.github.com/pyspread/ either to give you some hints, to use
as is, or to join in the maintenance effort.

Gadget/Steve

<Snip>
The other control that I would consider for this sort of thing is
ultimate list control.

Gadget/Steve

···

On 24/06/2012 7:25 PM, Mario Lacunza wrote:

Hello

looks nice but I need to embed the sheet into my program, only cells
no toolbars and ets... anyways I'll look the code too, thanks!!

What control are you using for it?

Saludos / Best regards

Mario Lacunza

looks nice but I need to embed the sheet into my program, only cells no toolbars and
ets... anyways I'll look the code too, thanks!!

What about XLSGrid? It's a spreadsheet.

https://groups.google.com/forum/#!msg/wxpython-users/RxpGvUQqKu8/9GslNb1_eUYJ

I think it would be easy to use ObjectListView for this too (wxPython: Using ObjectListView instead of a ListCtrl - Mouse Vs Python). The UltimateListCtrl is a good alternative. There’s also some new versions of the ListCtrl in wx2.9 that might be worth looking at.

  • Mike
···

On Sunday, June 24, 2012 12:11:59 PM UTC-5, Mario Lacunza wrote:

Hello!

I write these lines to ask some advise about what control is the best
for this kind of tasks: I’ll need to create a sheet like excel, to
allow some predefined calculations and some input from the user.

For example in the sheet 1 the operation A1+A2=A3 will be executed each
time the user loads that screen and others operations more in the same
sheet… user can add the value in A2. SO I need to control some events,
edit options, make calculations, etc.

I want to know if the wxGrid is the best control for the task or you can
recommended another one?

Thanks in advance!

Saludos / Best regards

Mario Lacunza

The main control of pyspread is the class Grid that is derived from
wx.grid.Grid. You can find it in /src/gui/_grid.py

Martin

···

On Sun, 24 Jun 2012 13:25:58 -0500 Mario Lacunza <mlacunza@gmail.com> wrote:

looks nice but I need to embed the sheet into my program, only cells
no toolbars and ets... anyways I'll look the code too, thanks!!

What control are you using for it?

Hi
Yes I saw it, I think I’ll use it too like my software have a basics calculations.

Thanks to all for your answers!

Mario Lacunza

···

Enviado desde mi Motorola Atrix2

El jun 25, 2012 3:38 p.m., “Martin Manns” mmanns@gmx.net escribió:

On Sun, 24 Jun 2012 13:25:58 -0500 > > Mario Lacunza mlacunza@gmail.com wrote:

looks nice but I need to embed the sheet into my program, only cells

no toolbars and ets… anyways I’ll look the code too, thanks!!

What control are you using for it?

The main control of pyspread is the class Grid that is derived from

wx.grid.Grid. You can find it in /src/gui/_grid.py

Martin

To unsubscribe, send email to wxPython-users+unsubscribe@googlegroups.com

or visit http://groups.google.com/group/wxPython-users?hl=en

Hello Mike,
I'll check both too, Im using Ubuntu Linux 12.04 and wxPython 2.8 but I can see its present too in this version... thanks!

Saludos / Best regards

Mario Lacunza
Email:: mlacunza@gmail.com
Personal Website:: http://www.lacunza.biz/
OpenOffice.org:: http://es.openoffice.org/
OpenOffice.org Perú:: http://openoffice-peru.com/
Hosting:: http://mlv-host.com/
Mascotas Perdidas:: http://mascotas-perdidas.com/
Google Talk: mlacunzav Skype: mlacunzav
MSN: mlacunzav@hotmail.com Y! messenger: mlacunzav

···

El 25/06/12 09:56, Mike Driscoll escribió:

On Sunday, June 24, 2012 12:11:59 PM UTC-5, Mario Lacunza wrote:

    Hello!

    I write these lines to ask some advise about what control is the best
    for this kind of tasks: I'll need to create a sheet like excel, to
    allow some predefined calculations and some input from the user.

    For example in the sheet 1 the operation A1+A2=A3 will be executed
    each
    time the user loads that screen and others operations more in the
    same
    sheet... user can add the value in A2. SO I need to control some
    events,
    edit options, make calculations, etc.

    I want to know if the wxGrid is the best control for the task or
    you can
    recommended another one?

    Thanks in advance!

    -- Mike Driscoll <kyosohma@gmail.com>
    Saludos / Best regards

    Mario Lacunza

I think it would be easy to use ObjectListView for this too (wxPython: Using ObjectListView instead of a ListCtrl - Mouse Vs Python). The UltimateListCtrl is a good alternative. There's also some new versions of the ListCtrl in wx2.9 that might be worth looking at.

- Mike