Jump to content

Worksheet Populating Triple

Recommended Posts

I've created worksheets pulling data from symbol records.  They've been working fine for the past few months.  All of sudden it's populating each symbols data three times.  Anyone seen this before - have a solution?

Share this post

Link to post

Correct.  Worksheets count objects in Design Layers, and Viewports.  So if you have one object on a Design Layer, 1 Design Layer Viewport that contains that object, and 2 Sheet Layer Viewports that are displaying that object (even if it is outside of the crop), you will end up with a count of 4 even though there is only a single object on the drawing.


The solution is to be more specific in your Criteria and specify exactly what layer(s) you are looking for objects on or what viewport you want to count objects in.


Glad you figured it out.

Share this post

Link to post
2 hours ago, Pat Stanford said:

...and 2 Sheet Layer Viewports that are displaying that object (even if it is outside of the crop)...


Is this true?


I thought they only count objects in Viewport Annotations. But you use worksheets far more than I do.

Share this post

Link to post

Yes it is true. Each instance of a symbol in a viewport will be counted as a separate item from the one on the design layer.


Strange but true. Not too bad of work around to set the criteria, but disconcerting the first time you hit the problem.


I probably answer this question at least once per month here on the forum.

Share this post

Link to post

Just tried in 2020 and it doesn't happen there either. I'd venture to guess that if it did ever happen that way it would've been a bug, since that sounds like a terrible way to count things 😉


I only recall it counting in these places:


Share this post

Link to post

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.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


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.

  • Create New...