At 02:46 06/04/2010 +0200, Michelle Konzack wrote:
Someone [you suppressed who] wrote:
If so, it can be achieved by mouse-dragging the formula as shown
under 'Copying Formulae' in help.
You really mean, I should copy around 80.000 fields by hand? That's sick!
This is an odd comment - unless you are very unknowledgeable about
spreadsheets (which you don't suggest). If you have many rows to
fill with corresponding formulae, you can copy and paste into a
selected range of cells or even an entire selected column using only
a few clicks. Yes, you do it by hand, but it doesn't involve 80 000
separate operations. It's not "sick".
In Micr[os]oft Excel you define it one time and if you are in the
next line it is automatically there...
That's not true - and it would be particularly unhelpful if it
were! You need to fill or paste formulae into other cells in Excel -
just as in any spreadsheet, including Calc.
I have not found a function "=SUM(over)", which mean, calculate
the SUM of any values of the fields on the top of THE CURRENT field.
Then you haven't looked:
o Put the cursor into your result cell.
o Click the sigma symbol to the left of the Input Line. (Sigma is
mathematics for sum.)
o Adjust the range of cells that Calc offers if it is incorrect:
drag it to position the top left corner and drag the bottom right
corner to position that.
o Press Enter or click the green tick.
Oh, and you won't find that in Excel, I believe!
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
