Gnumeric question

[phiscock-g851W1bGYuGnS0EtXVNi6w at public.gmane.org]

Why not use open office 'calc'? It has a zillion functions, including
comparison.

Peter

> Hi Pals,
>
> I am using gnumeric over here and have a quick question. I have 4
> columns of numbers. Lets say column A, B, C & D. I want to compare
> column A and B.
>
> I do not think Gnumeric has the compare function. Okay, it may be
> there but I have not been able to find it. So I defaulted to
> subtructing the content of column B from content of column A.
>
> The formula is not working across the rows. For example, I thought I
> could put this in the first row of column E.
>
> =A1-B1
>
> Then, if I highlight the whole of column E, I assumed the formula
> would ripple all the way done. For example, I would have A2-B2 on the
> next row, A3-B3 on third row and so forth. Noop, not working.

Copy the first formula and then paste it into all the other cells. The
cell references will adjust.

>
> Any pointer on a good direction? I did a bit of googling, but nothing
> helpful has popped up yet. I am just raising this here just in case
> someone may know how to do it off head.
>
> Regards,
>
> William
> --
> 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
>


-- 
Peter Hiscocks
Syscomp Electronic Design Limited, Toronto
http://www.syscompdesign.com
USB Oscilloscope and Waveform Generator
647-839-0325

--
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