OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Help with Open Office Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
robertcray
Newbie
Newbie


Joined: 19 Jan 2010
Posts: 4

PostPosted: Tue Jan 19, 2010 9:11 pm    Post subject: Help with Open Office Calc Reply with quote

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
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Tue Jan 19, 2010 10:22 pm    Post subject: Reply with quote

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
View user's profile Send private message
robertcray
Newbie
Newbie


Joined: 19 Jan 2010
Posts: 4

PostPosted: Wed Jan 20, 2010 6:13 am    Post subject: Hel;p with Open Office Calc Reply with quote

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
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Wed Jan 20, 2010 7:05 am    Post subject: Reply with quote

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
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Wed Jan 20, 2010 7:35 am    Post subject: Reply with quote

FWIW, text numbers will normally be left aligned and real numbers, right aligned.
Back to top
View user's profile Send private message
robertcray
Newbie
Newbie


Joined: 19 Jan 2010
Posts: 4

PostPosted: Wed Jan 20, 2010 8:37 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group