Jump to content

Worksheet function question

Daryl Wood

Recommended Posts

  • 5 months later...

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.

Link to comment

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.

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