> -Original Message-
> From: Dan Lewis [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 24, 2006 1:57 AM
> To: users@openoffice.org
> Subject: Re: [users] Calc, _easily_ summing sparsely
> populated columns?
> > Hello.
> >
> > Is there easy (one-st
t; To: users@openoffice.org
> Subject: RE: [users] Calc, _easily_ summing sparsely
> populated columns?
>
> So this makes me ask - does current Calc's behavior (see
> below) make any sense?
>
> (when clicking "Sum" with x*y selection, Calc just ran
D]
> Sent: Tuesday, October 24, 2006 1:06 AM
> To: users@openoffice.org
> Subject: Re: [users] Calc, _easily_ summing sparsely
> populated columns?
>
> After reading all of the answers and workarounds that were
> passed on through the list it's save to say that the ans
Reply To: users@openoffice.org
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-6"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <[EMAIL PROTECTED]>
On Monday 23 October 2006 02:12 pm, Kirill S. Palagin wrote:
> Hello.
>
> Is there easy (one-step, mouse-onl
After reading all of the answers and workarounds that were passed on
through the list it's save to say that the answer to the OP's question
is NO. Calc behaves different from Excel in this matter.
Arnold Huzen
Joe Conner schreef:
That works if I need to sum just one column, but I am talki
That works if I need to sum just one column, but I am talking about
several columns at once. In this case it either does not work or I am
doing something wrong.
Try using a formula in the form of (without the quote signs) " =SUM(1st
COLUMN) + SUM(2nd COLUMN) + SUM(3rd COLUMN) " etc. for as
On 10/23/06, James Mckenzie <[EMAIL PROTECTED]> wrote:
Dan:
Maybe I can explain:
You click on the cell you want the sum in. Click on the formula bar and select
sum. You hold down the control button and then click (or unclick) the cells
you want to sum.
Can we do this with OpenOffice.org?
> -Original Message-
> From: James Mckenzie [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 23, 2006 11:30 PM
> To: users@openoffice.org
> Subject: Re: [users] Calc, _easily_ summing sparsely
> populated columns?
> >On Monday 23 October 2006 02:12 pm,
[EMAIL PROTECTED] wrote:
-Original Message-
From: Dan Lewis [mailto:[EMAIL PROTECTED]
Sent: Monday, October 23, 2006 11:21 PM
To: users@openoffice.org
Subject: Re: [users] Calc, _easily_ summing sparsely
populated columns?
Is there easy (one-step, mouse-only, shortcut or
> -Original Message-
> From: Dan Lewis [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 23, 2006 11:21 PM
> To: users@openoffice.org
> Subject: Re: [users] Calc, _easily_ summing sparsely
> populated columns?
> > Is there easy (one-step, mouse-only, shortcut o
-Original Message-
>From: Dan Lewis <[EMAIL PROTECTED]>
>Sent: Oct 23, 2006 12:21 PM
>To: users@openoffice.org
>Subject: Re: [users] Calc, _easily_ summing sparsely populated columns?
>
>
>On Monday 23 October 2006 02:12 pm, Kirill S. Palagin wrote:
>>
Reply To: users@openoffice.org
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-6"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <[EMAIL PROTECTED]>
On Monday 23 October 2006 02:12 pm, Kirill S. Palagin wrote:
> Hello.
>
> Is there easy (one-step, mouse-onl
Hello.
Is there easy (one-step, mouse-only, shortcut or mouse+shortcut) way of
inserting sum for several sparsely populated (with gaps) columns? Like
in that _other_ spreadsheet app you select an area with values, click
"Sum" button on the toolbar and column-wise sums are inserted right
below the
13 matches
Mail list logo
