openoffice 2.4
Vista Home Basic
My question is: I am trying to do a simple budget in CALC. In Excell I put in the function with the cell range and when I put in a new number in the cells that are indicated in the range, the cell with the function, such as =SUM(B2:B15) automatically resums and the new sum is displayed. I need to redo the formula in CALC. How do I make it automatically resum?
[Solved] Simple SUM
[Solved] Simple SUM
Last edited by Hagar Delest on Mon Jun 09, 2008 5:13 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
Reason: tagged the thread as Solved.
Re: Simple SUM
The same way will also work in Calc.
OOoSVN - Version control for OOo documents under Unix
LibreOffice on Arch Linux
LibreOffice on Arch Linux
Re: Simple SUM
Tools/Cell contents /Check autocalculate.
[It's in the Help under "recalculate"]
David.
[It's in the Help under "recalculate"]
David.
Re: Simple SUM
Thank you, that worked. Don't have to select autocalculate in excel so I couldn't quite figure it out since I am very new to this software--just today! Although so far, it is very easy to use and the price is right!
Re: Simple SUM
You do have to if you want to not recalculate. In fact, I always turn it off as a matter of course and calculate manually with F9. I don't want recalculation until I'm finished. A personal whim. perhaps.rainwoman wrote:Thank you, that worked. Don't have to select autocalculate in excel
David.