I really appreciate the feedback, but I would like to say that I don't want to wear out my welcome here at gnumeric-list. All of these questions should really be addressed on the forums. From this point forward, it would be best if people directed their questions/bugs to the sourceforge site. Thanks :D
- Larry: You have the last revision, which had a couple of bugs with the integrated cell macros. I apologize, the new revision is on the site. Also the documentation is fixed. As for the cell addressing -- I made it "python like" instead of "excel like" because I figured that people were using python while using this module :D If you want excel like addressing, I recommend using the string addressing, which DOES mimick the spreadsheet. So say something like B['A7:E20']. If you want the first row to be "1" (rather than 0) you can do: B.change_cellref(-1, -1). That will change it so that B[1,1] gives you cell A1. However, it will screw up any string addressing you do. Garrett On Thu, Mar 24, 2011 at 7:00 AM, <gnumeric-list-requ...@gnome.org> wrote: > Send gnumeric-list mailing list submissions to > gnumeric-list@gnome.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://mail.gnome.org/mailman/listinfo/gnumeric-list > or, via email, send a message with subject or body 'help' to > gnumeric-list-requ...@gnome.org > > You can reach the person managing the list at > gnumeric-list-ow...@gnome.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnumeric-list digest..." > > > Today's Topics: > > 1. Re: PyWorkbooks - now with distutils, pdf documentation, and > works with excel as well as Gnumeric (Larry Evans) > 2. RE: PyWorkbooks - now with distutils, pdf documentation, and > works with excel as well as Gnumeric (ALLEN WINDHORN) > 3. Re: PyWorkbooks - now with distutils, pdf documentation, and > works with excel as well as Gnumeric (Larry Evans) > 4. Re: PyWorkbooks - now with distutils, pdf documentation, and > works with excel as well as Gnumeric (John Walker) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 23 Mar 2011 07:21:08 -0500 > From: Larry Evans <cppljev...@suddenlink.net> > To: gnumeric-list@gnome.org > Subject: Re: PyWorkbooks - now with distutils, pdf documentation, and > works with excel as well as Gnumeric > Message-ID: <imcojm$v9l$1...@dough.gmane.org> > Content-Type: text/plain; charset=ISO-8859-1 > > On 03/20/11 17:14, Cloudform C wrote: > > I did alot of work. I split the base class and built both Excel and > > Gnumeric variants on top of it. I made it work with distutils (with a > > setup.py script) and added doctest documentation. > > > > You should be able to just install it, import it, and run it. Tell me > > what you think > > There's a typo in 'PyWorkbooks Documentation.pdf' on p. 5 which contains: > > >>> from PyWorkbooks.GnWorkbooks import GnWorkbooks > > but should use 'GnWorkbook' instead of 'GnWorkbooks'. > > Also, although it's not a typo, on p. 6 there's: > > all addressing is in row,col form > > however, in all spreadsheets, the addressing is in col,row form. > For example: > > B3 > > is column B row 3. It would be easier for someone used to this > spreadsheet col,row addressing to transition to using PyWorkbooks > if PyWorkbooks also used col,row addressing. > > HTH > > -Larry > > > > ------------------------------ > > Message: 2 > Date: Wed, 23 Mar 2011 16:05:47 +0000 > From: ALLEN WINDHORN <a.windh...@q.com> > To: <gnumeric-list@gnome.org>, <cloudform...@gmail.com> > Subject: RE: PyWorkbooks - now with distutils, pdf documentation, and > works with excel as well as Gnumeric > Message-ID: <blu160-w388d071dfe973291e0cb4684...@phx.gbl> > Content-Type: text/plain; charset="iso-8859-1" > > > ---------------------------------------- > > To: gnumeric-list@gnome.org > > > ...Also, although it's not a typo, on p. 6 there's: > > > > all addressing is in row,col form > > > > however, in all spreadsheets, the addressing is in col,row form. > > For example: > > > > B3 > > > > is column B row 3. It would be easier for someone used to this > > spreadsheet col,row addressing to transition to using PyWorkbooks > > if PyWorkbooks also used col,row addressing. > > I would rather keep the Python convention for numeric addresses > like "MyBook[2,1] = cell B3 in the current sheet of "MyBook" (so > that the matrix would have the equivalent form to the spreadsheet). > You can use the "B3" style of address using strings, in which case > it is actually "col, row". > > Allen > -- > Allen Windhorn (507) 931-1349 > P.O. Box 320 > Kasota, MN 56050 > a.windh...@q.com or a.windh...@ieee.org > > > > ------------------------------ > > Message: 3 > Date: Wed, 23 Mar 2011 12:27:09 -0500 > From: Larry Evans <cppljev...@suddenlink.net> > To: gnumeric-list@gnome.org > Subject: Re: PyWorkbooks - now with distutils, pdf documentation, and > works with excel as well as Gnumeric > Message-ID: <imdahe$mmm$1...@dough.gmane.org> > Content-Type: text/plain; charset=ISO-8859-1 > > On 03/20/11 17:14, Cloudform C wrote: > > I did alot of work. I split the base class and built both Excel and > > Gnumeric variants on top of it. I made it work with distutils (with a > > setup.py script) and added doctest documentation. > > > > You should be able to just install it, import it, and run it. Tell me > > what you think > > > > https://sourceforge.net/projects/pyworkbooks/files/ > > > > The contents of the downloaded zip file: > > > > http://sourceforge.net/projects/pyworkbooks/files/PyWorkbooksFiles.zip/download > > contains: > > PyWorkbooksFiles/PyWorkbooks Documentation.pdf > > Page 14 of that claims: > > Included in any distribution is > the folder titled GnumericTutorials. > > However, I couldn't find such a folder in the > table of contents(TOC) of the .zip file. > The TOC did have: > > -rw-r--r-- 9635 19-Mar-2011 21:05:40 > PyWorkbooksFiles/GnumericFiles/tutorial_external.gnumeric > -rw-r--r-- 1458 13-Mar-2011 17:45:38 > PyWorkbooksFiles/GnumericFiles/tutorial_external.py > -rw-r--r-- 2132 19-Mar-2011 21:12:02 > PyWorkbooksFiles/GnumericFiles/tutorial_external.pyc > > Should Page 14 instead read "folder titled GnumericFiles"? > I did open "/GnumericFiles/tutorial_external.gnumeric", and pressed F9 > as instructed by the contents of that worksheet as well as > page 15 of PyWorkbooks Documentation.pdf; however, there > were several cells with #NAME? in them indicated the function > calls in those cells were not being found. Before that, > I had copied the .gnumerics folder from the .zip file > to my home directory as instructed on page 14 of the .pdf file. > > Anything else I should do to make the tutorial work? > > -Larry > > > > > > > > ------------------------------ > > Message: 4 > Date: Wed, 23 Mar 2011 10:57:55 -0500 > From: John Walker <jww1...@optimum.net> > To: gnumeric-list@gnome.org > Subject: Re: PyWorkbooks - now with distutils, pdf documentation, and > works with excel as well as Gnumeric > Message-ID: <4d8a1883.90...@optimum.net> > Content-Type: text/plain; charset="us-ascii"; Format="flowed" > > > > Larry Evans wrote: > > >Also, although it's not a typo, on p. 6 there's: > > > > all addressing is in row,col form > > > >however, in all spreadsheets, the addressing is in col,row form. > >For example: > > > > B3 > > > That's not strictly true. In Excel VBA the adressing is > object.cells(RowIndex, ColumnIndex). > John W > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://mail.gnome.org/archives/gnumeric-list/attachments/20110323/57f88285/attachment.html > > > > ------------------------------ > > _______________________________________________ > gnumeric-list mailing list > gnumeric-list@gnome.org > http://mail.gnome.org/mailman/listinfo/gnumeric-list > > > End of gnumeric-list Digest, Vol 83, Issue 16 > ********************************************* >
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
