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

auto-calc entire sheet?

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


Joined: 09 Mar 2012
Posts: 2

PostPosted: Fri Mar 09, 2012 9:42 am    Post subject: auto-calc entire sheet? Reply with quote

I created a spreadsheet and several of the columns have equations using data entered in other columns.
I successfully dragged the little black plus sign at the corner of each column down and it copied the equation with the appropriate blocks corresponding in each line.
The problem is that each box is either blank or displays the answer of the first equation when I first copy the equation, until I go to that box and click on the end of the equation in that box, and hit space and enter, then it fills in the appropriate answer in that box.
The pain is that there are over 600 boxes to do that for, and I update the equations and data often.
Is there a way to get the entire sheet to update all the calculations in each box with one or two clicks?
I tried looking for an answer but couldn't find one, I would appreciate some advice.
- Rick
Back to top
View user's profile Send private message
DiGro
Super User
Super User


Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

PostPosted: Fri Mar 09, 2012 10:19 am    Post subject: Reply with quote

Did you try F9 ?

That should recalculate your sheet
_________________
DiGro

Windows 7 Home Premium and AOO 4.0.1 NL (Dutch)
Back to top
View user's profile Send private message
roo3d
Newbie
Newbie


Joined: 09 Mar 2012
Posts: 2

PostPosted: Fri Mar 09, 2012 10:40 am    Post subject: Reply with quote

that worked, thank you very much
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