Re: gnumeric-list Digest, Vol 83, Issue 16

[Cloudform C <cloudform511 gmail com>]

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-request 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-request gnome org

You can reach the person managing the list at
       gnumeric-list-owner 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 <cppljevans 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 windhorn q com>
To: <gnumeric-list gnome org>, <cloudform511 gmail com>
Subject: RE: PyWorkbooks - now with distutils, pdf documentation, and
       works   with excel as well as Gnumeric
Message-ID: <BLU160-w388D071DFE973291E0CB4684B70 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 windhorn q com or a windhorn ieee org



------------------------------

Message: 3
Date: Wed, 23 Mar 2011 12:27:09 -0500
From: Larry Evans <cppljevans 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 <jww1941 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 90805 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
*********************************************