Jump to content

length and height calc in worksheet

Recommended Posts

Can someone tell me how to format a cell in a VW worksheet so that it will display the length and height of a rectangle separated by an "x"? My company makes sales displays, and we do a lot of rectangular wall frames, so a spreadsheet would work great for us. I know how to format one cell to give the height and a different cell to display width; How to do both so that a cell would say, for example, "52 x 48"??????

Link to comment
  • 3 weeks later...

The only way to have a measurement display such as 52"x48" in a single cell would be with VectorScript.

There is a visual shortcut to give you the appearance of 52"x48" by using three columns in the spreadsheet. Have column a be assigned the [52"], columb b assigned [x], column c assigned [48"]. You can then adjust the justification and cell size to have the three columns apear as 52"x48". The middle column will be skinny, the third column can be set with a left justification.

If it is just for visual aid purposes, this is much easier than trying Vector Script.

Good Luck!


Link to comment
  • 1 year later...

i've been through many of the old posts re. the difficulty of getting "real/3d" height + width of walls out of a worksheet + would like some help....i can't use vectorscript, but i can fiddle the worksheet database...

most important, how do i get 3d wall height in a worksheet database? <all my walls are flat topped>

2nd, how do i get wall thickness in a worksheet database?

in the past i've fooled around with classes for different heights + widths but it makes for a lot of unnecessary work

any simple solutions would be greatly appreciated

gideon scott confused.gif" border="0

Link to comment

If you have VectorWorks Architect, you can draw your walls with the "Wall Type" tool, this automatically places a wall record on the wall with the information you want. Architect also will create the worksheets to pull this information off the file for you.

Please note, that the wall records are only updated when the "VA Create Schedule" command is run, so be sure to re-run this command after you make changes to your walls.

Matthew GiampapaNNA Technical Support

Link to comment

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.

  • Create New...