> -----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, Kirill S. Palagin wrote: > >> 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 selection. > >> > >> Thanks a lot. > >> WBR, > >> K. Palagin. > > > >Try doing it in the opposite order. Enter the cell where you > want the > >sum. Click the "Sum" button, then select the area with the > values using > >the cursor. Click the green checkmark at the top or simply use the > >Enter key. > > > 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? > > James McKenzie
That's nice trick. But I want something different - in Excel select range (with values) A1:B4 and click Sum button. You will get two furmulas - SUM(A1:A4) and SUM(B1:B4) in row 5. Here is my queston - does current Calc's behavior (when clicking Sum with x*y (x and y >2) selection, Calc just randomly generates formulas (like "=SUM(#REF!3:D3)") makes any sense? WBR, K. Palagin. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]