ETFRCO Posted January 15, 2015 Share Posted January 15, 2015 Hello, Can anyone point me to a listing of all the functions available to be used in a worksheet? I have searched here and in the knowledgebase, but not found a good resource. My bound manual lists the most common ones, but there are a lot more available in the pull down list that I can't find any documentation for. Thanks! Quote Link to comment
Pat Stanford Posted January 15, 2015 Share Posted January 15, 2015 In VW2015 a search of the online help for "Worksheet Functions" appears to show 60+ functions. I have not done a direct comparison to the pulldown, but this should be most of them. Couple these with the ="Record"."Field" format to get information from objects in the drawing and you have all of the power of worksheets. The Help also refers you to the developer docs if you need more information on criteria. Quote Link to comment
Vectorworks, Inc Employee PVA - Admin Posted January 15, 2015 Vectorworks, Inc Employee Share Posted January 15, 2015 I extracted a few of the more common ones here: http://kbase.vectorworks.net/questions/1088/Worksheet+Functions+-+Windows http://kbase.vectorworks.net/questions/1090/Worksheet+Functions+-+Plants http://kbase.vectorworks.net/questions/1089/Worksheet+Functions+-+Doors But a trick you can use to find new, specific functions is Tools > Reports > Create Report, pick the type of object you want to look at the fields of, then add all the fields to the worksheet to be created. Then, you can look at the database header rows in the worksheet to find the functions for the desired objects/fields. Its reverse-engineering certainly, but I have never come across a comprehensive list. Quote Link to comment
Pat Stanford Posted January 15, 2015 Share Posted January 15, 2015 You can also use the script from the Vectorscript Resource Share forum to create a worksheet showing the fields available for a PIO. It will tell you the type of object and give you a "cut & paste able" version to use in other worksheets. https://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Number=108487#Post108487 Quote Link to comment
Vectorworks, Inc Employee PVA - Admin Posted January 15, 2015 Vectorworks, Inc Employee Share Posted January 15, 2015 THAT is a gem I hadn't seen before, mind if I make it into an article as well? Quote Link to comment
Pat Stanford Posted January 16, 2015 Share Posted January 16, 2015 You are welcome to make an article. Quote Link to comment
ETFRCO Posted January 16, 2015 Author Share Posted January 16, 2015 Thanks for the info, and especially the script! Quote Link to comment
Recommended Posts
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.