Re: gnubie questions

[Jody Goldberg <jody gnome org>]

On Thu, Mar 28, 2002 at 10:43:13PM -0500, ota pimlott net wrote:
>   - Is there a function to get the value of the cell at a given row
>     and column?  Ie, F such that =F(1, 1) is equivalent to =A1.
>     Seems like a no-brainer, but I couldn't find it in my scan
>     through the docs.
There are 2 approaches.
    =INDEX
    =OFFSET

Beware neither is fully supported yet, things do not get
recalculated all the time.

>   - Is there any feature that would allow me to identify two or more
>     cells with each other, requiring that they always have the same
>     value?  I would want to be able to change any one of them, and
>     have the others all change automatically.
I don't understand.

>   - Is there any feature to hide rows/columns by a pattern?  Say I
>     have a column containing a running total by month, and I want to
>     see only values for the end of each year.  Is there a way to
>     hide all but every twelfth row?
not without writing some code.

>   - What is the current status of extension languages?  I looked at
>     the Python support a bit (eg, gnome_glossary.py), but I don't
>     see any documentation, so it's hard to figure out what all the
>     possible hooks are.  What is the status of the guile plugin?
>     Are there any plans or work-in-progress anywhere?  I'll start
>     digging into the code tomorrow, but I thought I'd ask if there's
>     any other information I've missed.
The api is still in progress.  It seems likely that python will be
the first implementation with corba wrappers to the api soon
afterwards.