On Mon, 2 Oct 2006, Pete Theisen wrote:
> On Monday 02 October 2006 01:48, Eben King wrote:
>> On Mon, 2 Oct 2006, Pete Theisen wrote:
>>> Does anyone know how to do this short of just using a calculator and
>>> typing the numbers in?
>>
>> =sum(A1:A5) doesn't do it for you? I never use the toolbar buttons...
>
> Well, yes, but on a big job that is a lot of typing. Using a computer is
> supposed to make it easy and fast, particularly on something people do all
> the time.
>
> I am looking for the thing to click that sums the highlighted column.
Don't see that. How about hitting the button to insert "=SUM(xxx)" (not a
literal "xxx", but some range of cells), then replacing "xxx" with the range
you want?
> If I highlight and click in OO it changes the highlighted values to 0s,
I don't see that. Here, it replaces the active cell with "=SUM(A1)" with A1
highlighted. What I've done is, don't select a range, have the active cell
be where you want the sum to go. Hit the button, it inserts the formula,
then tweak the formula.
> not what I am looking for at all. What were they thinking? Were they
> thinking? This is version 2.0, by the way.
It calls itself "OpenOffice.org 2.0", but then goes on to say its version is
1.9.129. Rounding up, I suppose.
-- -eben QebWenE01R@vTerYizUonI.nOetP royalty.no-ip.org:81 TAURUS: You will never find true happiness - what you gonna do, cry about it? The stars predict tomorrow you'll wake up, do a bunch of stuff and then go back to sleep. -- Weird Al ----------------------------------------------------------------------- This list is provided as an unmoderated internet service by Networked Knowledge Systems (NKS). Views and opinions expressed in messages posted are those of the author and do not necessarily reflect the official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 17:47:00 EDT