Jump to content
  • 0
SCParker

Recalculate worksheet command without clicking on worksheet?

Question

Hi All,

Is there a way to recalculate worksheets without actually having to select a worksheet and right-click to choose recalculate? I've searched for the command in the workspace editor with no luck.

 

Thanks, Scott

Share this post


Link to post

1 answer to this question

Recommended Posts

  • 0

As far as I know there's no built in command. You can write a script to do it though. I've got one to recalculate all worksheets in a file, but you could modify it to do just one specific instance by name. Vectorscript below. I set it up as a Plugin so I could make it a custom menu item. I borrowed and adapted this from someone else's work, so it's possible it could be simplified. Hope this helps.

 

-Dan

 

{Recalculate all worksheets in file}
Procedure WSrecalc;
VAR

foundObject: handle;
objname :String;
i, n : integer;
OK : boolean;

function DoRecalc (h : handle) : Boolean;

BEGIN
	RECALCULATEWS(h);
	RESETOBJECT(h);
	RESETOBJECT(GETWSIMAGE(h));
End;

Begin
n := NAMENUM;
	For i := 1 to n do begin
		foundObject := GETOBJECT(NAMELIST(I));
		If GETTYPE(foundObject) = 18 Then ok := DoRecalc(foundObject);
	End;
End;
Run (WSrecalc);

 

 

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×