Gnumeric question

[William Muriithi]

Hallo,

> I'm not sure what you mean by "compare."

In Excel, they is a tool I think under option that one can use to
essentially check the difference of value in two columns, its just a
fancy too for what we are doing below
> What you seem to be describing putting a formula in one cell, and
> having it be applied to other cells.
Correct
> In *most* spreadsheets, you have to do that by putting the formula in
> the first cell, and then copying from that cell to the others.
>
> The way I would accomplish that would be by "copying" the value in
> cell E2; put the cursor on it, then select "Copy". (control-C; menu
> entry "Edit/Copy").
>
> Then, I would highlight the region I want to copy it into (e.g. -
> select cells E2 thru E6), and select "Paste" (control-V; menu entry
> "Edit/Paste").
Thanks, it worked. I did use it yesterday successfully. Initially, I
was double clicking and then ending up taking the formula.
> Lotus Improv introduced the notion of having a single formula applied
> automatically to an entire row or column; there has never been any
> port of this to Linux.  There was a successor to Improv, called
> Quantrix, which runs only on Windows and MacOS.  There is a clone of
> Quantrix available on SourceForge called FlexiSheet; it only runs on
> MacOS.
>





Thanks

William
> At any rate, applying a single function to many cells isn't something
> that spreadsheets usually support.  If you want a function used
> everywhere, they provide "copy/paste" to copy it into all those
> places.
>
> You won't find OpenOffice is materially different from Gnumeric, by
> the way; they both have the same basis for their set of functionality,
> as they are both basically tracking the base feature set of Microsoft
> Excel.
> --
> http://linuxfinances.info/info/spreadsheets.html
> "The definition of insanity is doing the same thing over and over and
> expecting different results."  -- assortedly attributed to Albert
> Einstein, Benjamin Franklin, Rita Mae Brown, and Rudyard Kipling
> --
> The Toronto Linux Users Group.      Meetings: http://gtalug.org/
> TLUG requests: Linux topics, No HTML, wrap text below 80 columns
> How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists
>
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists