Michelle Konzack wrote:
Hello Brian,
Am 2010-04-07 00:00:01, hacktest Du folgendes herunter:
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!
Yes and Excel 2.0+ has saved me headaches because it.
When using Calc, I had tonns of errors because it has changed the ROW
NUMBERS in calculatins and when I found out that it adapt it t the new
ROW, I had to change all back by hand.
Is there an option to stop this?
In my case, it is a VERY annoying feature-bug.
Thanks, Greetings and nice Day/Evening
Michelle Konzack
Systemadministrator
24V Electronic Engineer
Tamay Dogan Network
Debian GNU/Linux Consultant
I believe this feature is similar to Excel. If you want to keep
the same row when pasting as it was when copying, use $ in front of the
row number. EX: B2= A$2 + $C2 + $D$2 When pasted into B4 you get B4 =
A$2 +$C4 + $D$2. When pasted into E6, you get E6= D$2 + $C6+ $D$2. I
learned this from someone who was taking a course in Excel 2007.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
