Search the Community
Showing results for tags 'spreadsheet'.
Found 2 results
Hi I have a mesh, freely oriented in the space. I set a working plane in the needed orientation, then I Create Contours parallels to the X and Y axis on the mesh, obtaining NURBS curves. Then with Analysis menu I place a 3D Locus at each crossing point of X and Y contours, naming it and in an orderly way. At this point I would populate a Spreadsheet with the coordinates of each 3D Loci. I can observe that on Object Info palette, clicking on WP (purple WP icon) I get coordinates referred to the working plane. Now, if I create a database in a Worksheet row inserting the name, X, Y, Z I get always the Active WP (blue icon) coords. So, the question is: there is a way to tell to the formula inserted in Worksheet that I wish refer to the WP? Or I have to transform the coordinates to the WP Origin and Rotation? I attach an image of the Worksheet, the drawing and info palette showing the different values. Any help will be appreciated. Roberto Schermata 2020-01-10 alle 12.54.46.pdf
Guest posted a topic in General DiscussionI am trying to create a worksheet with multiple formulas in it. For this I need to be able to search different criteria in each column. The type is spaces. What is the order of the text I need to input into the cell to pick up with the criteria would do in a database row? I have looked through all of the following places and it is not very clear to a novice. http://developer.vectorworks.net/index.php/VS:Function_Reference_Appendix#attrCrit http://developer.vectorworks.net/index.php/VS:Search_Criteria#Search_Criteria_Format http://app-help.vectorworks.net/2016/eng/VW2016_Guide/Worksheets/Worksheet_Functions.htm Thanks!