Posted: Tue Jan 30, 2007 3:30 pm Post subject: Writer, copy a formula from one cell to another
I often use the possibility of doing some calculation within tables in Writer.
For example I have a table with 2 rows and 3 col.
In cell A1 I type the numer 1, in cell B1 I type the numer 2. Than I go to cell C1, press F2 and in the Calculation bar (?, don't know if it is the correct name) that appears I write a formula, let's say "=A1+B1" (without "). After I've hitted return key in cell C1 appears number 3.
Now I go back to cell C1, press F2 again and I copy the formula I put in the calculation bar. Than I go to cell C2, press F2 and in the calculation bar I paste the formula. What I see is again "=A1+B1" and not the expected "=A2+B2" as we were in Calc.
Is there a way to make the pasting in a smart way?
You can easily copy a formula.
Example: You have some numbers in the range A1:A10, some other numbers in B1:B10. Select C1 enter in the formula bar (wihout pressing F2) =, then click on A1, enter+, click on B1 and press Return. The sum A1+B1 is saved in C1. OK.
Then select the range C1:C10, go to Edit -> Fill -> Down, and you'll see, it's miraculous. I'd like to "wiki" this tip. Maybe today, if I've time to do it.
I used this function for illustrating Euler's method. A wiki on Euler?? (with screenshots !)
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
Posted: Wed Jan 31, 2007 8:54 am Post subject:
Quote:
wikied here in French only (sorry).
I've added it to French to English to-do list. No promises on when I'll get to it, though. Somebody's welcome to beat me to it; just let me know if you do!
Oh yes, the whole of this is a mathematical subject. Euler was a Swiss mathematician who lived in the 18th century, in Germany and Russia. He was a great arithmetician, but he worked in other areas of mathematics.
On wikipedia, you'll find an interessant page about him (the second section is a bit _a lot_specialized) but the first one is very readable.
Thank you very much for all your translations.
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
Posted: Wed Jan 31, 2007 10:53 am Post subject:
Thanks for the answer and the link. It's been a long time (20 years!) since I've done higher math, but I remembered enough to at least recognize a lot of the terms. I did crack open my Matrices and Linear Algebra book "just for fun" a few years back, but I didn't get very far!
You can easily copy a formula.
Example: You have some numbers in the range A1:A10, some other numbers in B1:B10. Select C1 enter in the formula bar (wihout pressing F2) =, then click on A1, enter+, click on B1 and press Return. The sum A1+B1 is saved in C1. OK.
Then select the range C1:C10, go to Edit -> Fill -> Down, and you'll see, it's miraculous. I'd like to "wiki" this tip. Maybe today, if I've time to do it.
I used this function for illustrating Euler's method. A wiki on Euler?? (with screenshots !)
Jacqueline
Jacqueline, thanx for your answer but probably I wasn't clear enough to explain that ,y problem was with Writer tables. The tip you wikied is for Calc (and I knew it )
I say I "was" because I found how to do it!
Thanx again!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum
)
. But maybe the wikied tip is not needless and your tip could be added ?