Jump to content
Sign in to follow this  
Daryl Wood

Worksheet function question

Recommended Posts

Why doesn't this work? Anyone know?


Is it because VW's function interpreter cannot resolve the variable and only works on an real number?

I'm trying to build a worksheet formula.


Share this post

Link to post

I just sticked with same issue. =Deg2Rad(angle) works only if a number is entered instead of "angle". I tried to use a reference to another cell, it didn't work with "FramingMember.pitch" cell but was working with if I entered a number instead of formula in that cell. I think the question is about format in which the result is given. The ? symbol behind the number makes the mess. And WV Worksheets obviously are lacking of sufficient possibilities to manipulate with numbers and text strings to retrieve it in usable format or with usable content (? symbol stripped out).

My guess is that you were trying to calculate the length of framing member with formula like =(FramingMember.LineLength+FramingMember.overhang)/cosDEG2RAD(FramingMember.pitch), am I correct?

Otherwise - this calculation could be easily included in Framing member PIO, giving possibility to retrieve length of an element with single record.field call (for example, FramingMember.Length). There are 2 ways out of this - give this as a wishlist item and wait for next release of VW with a hope this will be included, or - make your own PIO which does exactly what you want.

Share this post

Link to post

The pitch field of the framing member object is defined as a text field.

You are correct that the Value function for conversion between a string and a number does not recognize the degree symbol.

The third option (after writing your own PIO or waiting and hoping), it to attach a custom record and write a small vectorscript (or ask for us to help you write it) that will go through all the framing objects and get the text version of the pitch and store it in the custom record as a numeric field that you can use in the worksheet.

I would also suggest that you file a bug report on the framing member object as the pitch should really be a number not a text field.

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.

Sign in to follow this  


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...