Re: how to convert VB scripts to Gnumeric python

[Morten Welinder <mortenw gnome org>]

> So it's expected a Gnm.Cell and not the col, row provided in the program.

That's a sign you're picking up an old introspection file.  "make install"
might help.

M.

On Fri, Apr 13, 2018 at 9:18 PM <dm-gnome mercuryresearch com> wrote:

> Also using your test program, as is I get an error when it hits the

> sheet.cell_set_value

> operation, saying it got 3 variables instead of the 2 expected. When I
> change it to two, I get:

> TypeError: argument cell: Expected Gnm.Cell

> So it's expected a Gnm.Cell and not the col, row provided in the program.


> I suspect I'm probably testing a bit ahead of your patches on github.


> On 04/13/2018 06:00 PM, dm-gnome mercuryresearch com wrote:
> > OK, I've updated from github (I installed goffice and gnumeric) and
> > I'm getting a crash on my application's file IO:
> >
> > ** (pubrep:23096): WARNING **: Couldn't connect to accessibility bus:
> > Failed to connect to socket /tmp/dbus-E0H2kRCBCm: Connection refused
> > shell to uri
> > workbook view from uri
> >
> > ** (pubrep:23096): CRITICAL **: go_doc_init_read: assertion
> > 'doc->priv->imagebuf == NULL' failed
> > Segmentation fault
> >
> > This appears to be happening on the line
> >
> > s_wbv=Gnm.WorkbookView.new_from_uri(s_uri, None, io, None)
> >
> > Which is the actual workbook file open read. Though this may just be
> > me (perhaps I need to update other libraries?)
> >
> > This worked on goffice-0.10.32 with the patches I'd used on gnumeric.
> > So we'll need to sort out what changed.
> >
> >
> > On 04/13/2018 11:17 AM, Morten Welinder wrote:
> > > Major progress on my end.  I found two major sources of crashes (1:
> > > many of our
> > > boxed types were bad; 2: some pygobject versions fail on
> > > transfer-full arguments).
> > >
> > > You can follow the battle at
> > > Â Â Â
https://git.gnome.org/browse/gnumeric/tree/README-introspection
> > > although that file may move.  This file also contains the "blessed"
> > > API.
> > > This is still evolving.
> > >
> > > My main test script is at
> > > Â Â Â
https://git.gnome.org/browse/gnumeric/tree/test/t3001-introspection-simple.py
> > > It does pretty much everything one can do to a workbook other than
> > > file i/o.
> > > (That's somewhere on my list.)
> > >
> > > Note: I have marked lots of functions as "skip" because they are
> > > low-level functions
> > > not intended for scripting.  Most of GnmCell's methods are like
> > > that.  They don't do
> > > what you would expect of them and there are proper alternatives,
> > > typically in Sheet.Â
> > >
> > > Morten
> >
> > _______________________________________________
> > gnumeric-list mailing list
> > gnumeric-list gnome org
> > https://mail.gnome.org/mailman/listinfo/gnumeric-list