| View previous topic :: View next topic |
| Author |
Message |
robertcray
Newbie
Joined: 19 Jan 2010
Posts: 4
|
 Posted: Tue Jan 19, 2010 9:11 pm Post subject: Help with Open Office Calc |
 |
|
Hi..I just started using a template from Openoffice.org.. I am using the template as a checkbook register. Usually when I enter the data and click the next line below it it calculates the new balance..I used it for like 1/2 an hour this morning then came back an hour later and started entering new data - but now it will not calculate the new balance..any ideas what I can do. I saved it closed it down and then restarted..but it still will not work..any ideas how to get this to work again would be appreciated.
Thanks
Robertcray |
|
| Back to top |
|
 |
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1844
Location: Sydney, Australia
|
| Posted: Tue Jan 19, 2010 10:22 pm Post subject: |
|
|
Is somebody playing tricks on you and turning off AutoCalculate while you are away from the keyboard?
Go Tools|Cell Contents and make sure there is a tick for AutoCalculate.
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
robertcray
Newbie
Joined: 19 Jan 2010
Posts: 4
|
| Posted: Wed Jan 20, 2010 6:13 am Post subject: Hel;p with Open Office Calc |
|
|
| Thanks for the reply. For some reason the Auto Calculate was not checked. I checked the box. Unfortunately it still will not work. Any other ideas. Thanks.. |
|
| Back to top |
|
|
ken johnson
Super User
Joined: 23 Apr 2009
Posts: 1844
Location: Sydney, Australia
|
| Posted: Wed Jan 20, 2010 7:05 am Post subject: |
|
|
What is the format of the cells into which you are adding data?
If the format is Text then the numbers you are adding are text and they will contribute nothing to the new balance.
Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8976
Location: Lexinton, Kentucky, USA
|
| Posted: Wed Jan 20, 2010 7:35 am Post subject: |
|
|
| FWIW, text numbers will normally be left aligned and real numbers, right aligned. |
|
| Back to top |
|
|
robertcray
Newbie
Joined: 19 Jan 2010
Posts: 4
|
| Posted: Wed Jan 20, 2010 8:37 pm Post subject: |
|
|
Hi Ken..I appreciate all the assistance you gave me. I got it to work finally. I needed to copy one of the "H" cell columns that was working and then paste that formula from line 31 down - which is the line where the calculator stopped working. After I pasted the formula in column H lines 31 and below that activated the calculate function in those lines. Thanks again..
Robert |
|
| Back to top |
|
|
|
