Search the Community
Showing results for tags 'workseet'.
-
Recalculate worksheet command without clicking on worksheet?
SCParker posted a question in Troubleshooting
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 -
Hi all, in Vectorworks 2021 it's possible to use real Symbols in the Speaker Array Tool. So far so good, I'm really happy about this feature. One thing amazes me. It seems that the Symbols disappear in the worksheets if you set angles inside the Speaker Array, which we'll always have. In the attached Picture you can see the Problem. Array 1 is without angles. Array 2 with a Bumper Angle Array 3 with Bump/ Sub at 0° and Speaker at -4° Worksheet Count in the first Situation is good. Does somebody has any idea what I have to change or is this a bug? Thank you in advance
- 3 replies
-
- speaker array
- workseet
-
(and 1 more)
Tagged with:
-
Hi vw community, I hit my limits to find reason why my worksheet (spreadsheet setup) is working perfectly fine in blank file (with only one slab style and worksheet itself) but have real struggle to recalculate in file with model - building in it (many layers, viewports ...etc). Takes 10-15 minutes! I attach one screenshot with shown and described formula structure and other with look of desired result. Core criteria is vsel=true, so I basically select any slab that has slab style and while worksheet opened hit 'recalculate active worksheet' and get all information about individual components and result of object as a whole. There must be something ill with formulae...but I dont know what. I have noticed that whenever i import worksheet to any full project file, worksheet for some reason picks up some very high componentthicknessvalue for component no.1...? (3945 mm or similiar). It doesnt happen in blank file.... Would appreciate your time and help as I cant seem to resolve it. I will be willing to share worksheet if needed. Thanks in advance.
- 6 replies
-
- workseet
- spreadsheet
-
(and 1 more)
Tagged with:
-
Hi There, I'm having trouble creating a revision history worksheet from my title block borders. As shown in the screen shot below you can see that the revision number keeps repeating the current revision as oppose to the revision the drawing had when it was issued . I though I might be able to fix this myself using the Set Cell Formula, but I can't get that to work either 😞 Thanks for your help!
- 11 replies
-
- revision history sheets
- workseet
-
(and 1 more)
Tagged with:
-
when resizing worksheet column (making it wider) with just text in cells (set to wrap text) for some reason the text reshapes as it supposed but leaves blank space at the bottom of each cell as if there were extra blank lines (there are none). The only way to get rid of the blanks is, so far, to cut the text directly from the cell, hit return and paste it back in. Is there a trick to globally fix it?
-
I've attached a file that i'm using to learn worksheets. I'd like to add up the cells that contain the thickness of the roof component and show the total thickness in a separate cell. I've tried using the SUM function as suggested by JimW in another post but i'm doing something wrong. Any help is greatly appreciated. Worksheets.vwx