CS1 Posted February 17, 2008 Share Posted February 17, 2008 If I have a worksheet on my page to recalculate I can right click on the worksheet and click recalculate. What if I have 100 worksheets through out my file? If I do a Custom Modification I can change the attributes of the worksheets but cant recalculate. Quote Link to comment
Pat Stanford Posted February 18, 2008 Share Posted February 18, 2008 Check out this thread: http://techboard.nemetschek.net/ubbthreads/ubbthreads.php?ubb=showflat&Number=96413&an=&page= Pat Quote Link to comment
Vectorworks, Inc Employee Hugues Posted February 19, 2008 Vectorworks, Inc Employee Share Posted February 19, 2008 Hi CS1, the recalculate command in the right click menu recalculates all worksheets throughout your file. You don't have to use a script unless you just want a particular set of worksheets to be recalculated. Hugues NNA Quote Link to comment
Pat Stanford Posted February 19, 2008 Share Posted February 19, 2008 Just to clarify. If you right click on a worksheet and select Recalculate from the contextual menu, every worksheet in the drawing will be recalculated. I was not aware of this. Perhaps that item should be renamed to Recalculate All WS or something. All the other contextual menu options only work on the active object. Probably not a problem, but could be an issue for some people. Pat Quote Link to comment
Laura Stone Posted August 20, 2008 Share Posted August 20, 2008 We have lots of worksheets on our drawings and generally only want to update one at a time as it otherwise can take up to an hour. Is there a way of doing this? Laura Quote Link to comment
Pat Stanford Posted August 20, 2008 Share Posted August 20, 2008 1. If you have the worksheet in the drawing, right (ctrl) click on the worksheet image and select Recalculate from the contextual menu. 2. If you have the worksheet in Edit mode, just select Recalcuate from the pulldown menu (triangle) above the row headers. Pat Quote Link to comment
Laura Stone Posted August 20, 2008 Share Posted August 20, 2008 As far as I can work out these two methods recalculate all of the worksheets, I only want to recalculate the one I have open, or even better only one cell. Is there any way of doing this? Quote Link to comment
Pat Stanford Posted August 20, 2008 Share Posted August 20, 2008 Alright, if you want to be difficult about it try this: ;-) Create a new Vectorscript and paste in the following two lines. You don't need begin end or anything other than these two lines. After you save the script, it will recalculate only one worksheet and only if it the worksheet image is the first selected object on the active layer. RecalculateWS(GetWSFromImage(FSActLayer)); ResetObject((FSActLayer)); Pat Quote Link to comment
CS1 Posted August 21, 2008 Author Share Posted August 21, 2008 the recalculate command in the right click menu recalculates all worksheets throughout your file. You don't have to use a script unless you just want a particular set of worksheets to be recalculated. When I right click that option is not present, I have been in to my workspace and searched "all menu items" and cant find anything that resembles "recalculate" that I can add to my list of right click options. Quote Link to comment
Laura Stone Posted August 21, 2008 Share Posted August 21, 2008 Thanks Pat - that works perfectly. Laura Quote Link to comment
Vectorworks, Inc Employee Hugues Posted August 22, 2008 Vectorworks, Inc Employee Share Posted August 22, 2008 the recalculate command in the right click menu recalculates all worksheets throughout your file. You don't have to use a script unless you just want a particular set of worksheets to be recalculated. When I right click that option is not present, I have been in to my workspace and searched "all menu items" and cant find anything that resembles "recalculate" that I can add to my list of right click options. Make sure you are right clicking on a selected worksheet image. Quote Link to comment
Vectorworks, Inc Employee Hugues Posted August 22, 2008 Vectorworks, Inc Employee Share Posted August 22, 2008 Hi Laura, Here is another tip if you are working with large files and large worksheets that take time to recalculate. If you are editing a worksheet and you don't want it to automatically recalculate everytime you enter a cell, you can turn off the Auto-recalc preference for that worksheet. Just open the worksheet preferences dialog and uncheck the Auto-recalc check box. Editing a cell will now just update that cell and you can manually recalculate the worksheet later on. Hugues NNA 1 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.