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

[Bobby Powers <bpowers forio com>]

On Mon, Mar 14, 2011 at 9:09 AM, Garrett Berg <cloudform511 gmail com> wrote:

Thanks for all the feedback everyone.  A couple of things:

- Lee
The project is only about 5 days old and is still underdeveloped.  i am going to modify the post on the forum to refect that.  Eventually I am going to add all of the features that you request.  Thanks for all the great feedback :D

- Jean
Is the liscence because of python's liscence, or because of the license that I slapped onto my program (I think you mean the python liscence, but might as well check)?  I can change my license if that is what is necessary to get it into Gnumeric.  I find it really strange that you cannot package it... what about packaging it with the separate "extensions module" that contains the python module?

 

Your license.  At least py_external.py is licensed under GPLv3+, your contribution would need to be GPLv2 or GPLv2+.

yours,

Bobby

- Michal
I will do that.  Now that it is significantly more than just a linking script (it can completely control the workbook), I will probably name it Pygnumeric (hopefully that isn't taken)

On Mon, Mar 14, 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: I made a python module to bypass the special bindings
     (Lee McKusick)
  2. Full Macro Writer and spredsheet interfacing with python
     (G Bergeron)
  3. Re: Full Macro Writer and spredsheet interfacing with python
     (Jean Br?fort)
  4. Re: Full Macro Writer and spredsheet interfacing with python
     (Michal Kaukic)


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

Message: 1
Date: Sun, 13 Mar 2011 13:03:55 -0700
From: Lee McKusick <leemck gmail com>
To: gnumeric-list gnome org
Subject: Re: I made a python module to bypass the special bindings
Message-ID: <1300046635 1186 102 camel windy>
Content-Type: text/plain; charset="UTF-8"

I find your contribution interesting. Both Python running Gnumeric and
Gnumeric running Python have been things I wished I could do.

But my spreadsheet usage comes in surges with no activity between
projects. Also, most of the stuff I do winds up being exported to the
Google docs spreadsheet application. That adds another portability
problem.

Here is my comment and suggestion:

Package, organize and comment your programming accomplishment.

     * Put together a subdirectory of sample gnumeric spreadsheets and
       sample python scripts.
     * The tar archive or zipfile should create a subdirectory and
       unpack your files into that subdirectory.
     * Add enough comments and text material so the user can verify the
       examples are running correctly.
     * Write documentation.
             * In particular, write at least three paragraphs for the
               person who is not a python programmer.
             * The other really interesting problem is tell your
               readers how you pass data back and forth between the two
               programs.
             * Give a series of copy and paste command lines so that
               the samples can be executed correctly by the reader.
             * Finally, note the Python and Gnumeric version used. Tell
               the user generally about Python library files that may
               be needed.

Finally, there is the problem of how do you label, name and link to your
resulting project so that Gnumeric users and Python users can find your
project when they go looking for it.

Your accomplishment needs to have links and titles associated with it.
Here are the titles I might use:

How to run a Python script from within a spreadsheet.
How to run a Python script from Gnumeric.
Gnumeric Python run one in the other.
Get values computed by Gnumeric into a Python program.
Get values computed by Python into a spreadsheet.



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

Message: 2
Date: Sun, 13 Mar 2011 21:34:23 -0500
From: G Bergeron <cloudform511 gmail com>
To: gnumeric-list gnome org
Subject: Full Macro Writer and spredsheet interfacing with python
Message-ID:
       <AANLkTi=MtWx8RoacUxuPyc6JD1T3yxM_mn9v-OVAAWm7 mail gmail com>
Content-Type: text/plain; charset="iso-8859-1"

So I have spent literally ALL weekend writing this class that interfaces
with your guys' amazing spreadsheet program.  I hope your all happy with
it.  Please check out my writeup of it here:

http://cloudform511.posterous.com/the-true-python-spreadsheet-macro-class

Want to read column one?  Well just type gBook["A1:AA1"].  Want to change
it, try putting an equal sign.

I included a tutorial, which should be all you need to start writing python
macros in your spreadsheet.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.gnome.org/archives/gnumeric-list/attachments/20110313/5ea9b66e/attachment.html>

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

Message: 3
Date: Mon, 14 Mar 2011 07:32:13 +0100
From: Jean Br?fort <jean brefort gmail com>
To: G Bergeron <cloudform511 gmail com>
Cc: gnumeric-list gnome org
Subject: Re: Full Macro Writer and spredsheet interfacing with python
Message-ID:
       <AANLkTimkAA4nZYfQTcTv5Ypp-E3vyardPuCLvM5eqEUZ mail gmail com>
Content-Type: text/plain; charset="utf-8"

Thanks for this work.

The big issue with it is the license. GPLv3+ is incompatible with our GPLv2
only license. Not sure that using your work is legal because of the
incompatibility between these licenses.

There was an attempt for relicensing, starting with goffice, but it failed.
See https://bugzilla.gnome.org/show_bug.cgi?id=463248 for details.

Best regards,
Jean

Le dimanche 13 mars 2011 ? 21:34 -0500, G Bergeron a ?crit :
So I have spent literally ALL weekend writing this class that interfaces
with your guys' amazing spreadsheet program.  I hope your all happy with
it.  Please check out my writeup of it here:
>
> http://cloudform511.posterous.com/the-true-python-spreadsheet-macro-class
>
> Want to read column one?  Well just type gBook["A1:AA1"].  Want to change
it, try putting an equal sign.
>
> I included a tutorial, which should be all you need to start writing
python macros in your spreadsheet.
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.gnome.org/archives/gnumeric-list/attachments/20110314/a7cce85a/attachment.html>

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

Message: 4
Date: Mon, 14 Mar 2011 06:47:24 +0100
From: "Michal Kaukic" <mike frcatel fri uniza sk>
To: gnumeric-list gnome org
Subject: Re: Full Macro Writer and spredsheet interfacing with python
Message-ID:
       <f070b824cee782912d5222c9efbcd100 squirrel frcatel fri uniza sk>
Content-Type: text/plain;charset=utf-8

Thanks,

> So I have spent literally ALL weekend writing this class that interfaces
> with your guys' amazing spreadsheet program.  I hope your all happy with
> it.  Please check out my writeup of it here:
>
> http://cloudform511.posterous.com/the-true-python-spreadsheet-macro-class
>
> Want to read column one?  Well just type gBook["A1:AA1"].  Want to change
> it, try putting an equal sign.
>
> I included a tutorial, which should be all you need to start writing
> python macros in your spreadsheet.

please rename Your plugin, now it conflicts with sample Python functions
plugin. And You should add in the documentation that user need to activate
the plugin.

Mike





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

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


End of gnumeric-list Digest, Vol 83, Issue 6
********************************************

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list