Jump to content

Search the Community

Showing results for tags 'worksheet'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Announcements
    • Announcements
    • News You Need
    • Job Board
  • Feedback
    • Wishlist - Feature and Content Requests
    • Known Issues
    • Wishes Granted / Issues Resolved
  • General
    • Troubleshooting
    • General Discussion
    • Architecture
    • Site Design
    • Entertainment
    • Vision and Previsualization
    • Braceworks
    • Rendering
    • Workflows
    • Buying and Selling Vectorworks Licenses
    • Hardware
  • Customization
    • Marionette
    • Vectorscript
    • Python Scripting
    • SDK
    • 3rd Party Services, Products and Events
  • Solids Modeling and 3D Printing
    • Subdivision
    • Solids Modeling
    • 3D Printing
  • Vectorworks in Action
  • Archive
    • Resource Sharing
    • Machine Design


  • Knowledgebase
    • Tech Bulletins
    • Troubleshooting
    • Workflows
    • How To
    • FAQs


  • Marionette - Objects
  • Marionette - Networks
  • Marionette - Nodes
  • Marionette - Menu Commands

Product Groups

There are no results to display.

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start








Found 69 results

  1. ericjhberg

    Worksheets and Referenced Viewports

    So...we've come across an annoying bug. We are using a reference viewport system to build separate Production files, containing all of our sheets for a given project. These files reference in a Design file as we call it where all of the live linework is housed. The reason for this is not for discussion, it is just a workflow we have found works best for a multi-user/large multiple drawing set projects. With this workflow comes a strange bug when referencing worksheets through referenced viewports....they shrink. We often have to build our smart database worksheets/legends in the Design file and then reference those into the Production file through viewport references, but when we do, the worksheets shrink in vertical dimensions. We noticed this because we often have to put a reference symbol over the top of the worksheet for items (this is because the =image function in VW needs some serious attention), and when the worksheet and symbols come through the reference, they are no longer aligned and often are off by a completely illegible amount, no longer aligning with their intended worksheet row.
  2. Grethe Connerth

    Reports Records Database Worksheet Schedule

    Dear VW aficionados, could anyone please explain to me the difference between the below. Most likely I would understand a 'sketch or visualisation' to it better in comparison to reading the Help menu where I can't digest the content. --> Reports, Records, Databases, Worksheets & Schedules <-- Am getting utterly confused about these ;0)) Any input is appreciated. Cheers, Grethe
  3. Version 1.0.0


  4. Dear VW lovers, would anyone know if it is possible to export Renderworks Style Settings into a worksheet or excel spread sheet? I have multiple Renderworks Styles and currently I am creating screenshots and copy paste them into a file for comparison. This is a huge effort and I would love to have a faster and more convenient work around for this. Any input is much appreciated. Cheers, Grethe
  5. Nick Kargel

    worksheet sort icons missing

    The worksheet sort icons do not appear for me in 2018. "To sort or summarize a group of database sub-rows: If the database header rows are not displayed, select View > Database Headers from the Worksheet menu. Select the header row of the group of sub-rows to sort or summarize; the header row has a diamond next to its number. The three icons above the left end of the column header cells become available." Nope. They don't become available. I've just exported my file back to 2016, and it works. Feeling like I wasted my money on the "upgrade".
  6. I wish the worksheet functions be would be updated to include proper tools for pulling data from 3d geometry objects (basic dimensions like delta X, delta Y, delta Z, bounding box points, radii of spheres & cylinders etc.). The worksheet functions are outdated and clearly designed for a workflow of primarily 2d objects. This thread shows some of the shortcomings - The data should be able to be calculated regardless of the current view orientation (eg. you shouldn't have to switch to Top/Plan to have it work). Thanks, Kevin
  7. it would be extremely useful to be able to control upper lower case inside the worksheet. I frequently copy paste product specific information into various schedules and it is never formatted to match my spreadsheet. The workaround is to first past into standard text box, change it then select all cut and paste into worksheet - a bit of work.
  8. Hi, i tried to create a worksheet of the revision data of all title block borders of a document. However there is neither created a sheet layer which contains this worksheet nor a worksheet. I don't understand why, might be a bug in the title block border, issue manager? I actually am working with a german Vectorworks 2018 - SP2. Thanks in advance for your help. Regards, Matteo PK2016-v2018.zip
  9. It would be nice to be able to have different presentation of a same worksheet. For exemple I have a very big worksheet with lot of information. I need different presentation to show to different persons (like hiding some columns in one presentation and not in the other). Currently we are doing that with viewports that crops the part we do not want to show.... but is it a bit annoying the way we do that. It would be much better if we could simply have many instance of the worksheet and "hide" the columns (what we can currently do by giving the colums a width of zero) so the the "hidding" occurs only in that instance of the worksheet instead of reflecting into all of them...
  10. It would be really nice to be able to use the eyedropper tool within a worksheet so to be able to reapply similar formats from on cell to another quickly
  11. Markvl

    Worsheet Won't Summarize

    I've got a problem here that I can't figure out. It seems that I cannot "summarize" columns in my takeoff worksheet. Having ver. 2018, in the database row I should be able to select a column header and press the arrow key to the right and the dialog box pops up. If I select sum values the column should compress and show an overall value. It just won't do it. Bug? You will see in the pick that under column D I have an ascending symbol a plus sign and a 1 in that little box yet the columns below do not sum up.
  13. David Poiron

    Worksheet Database Row Calculations

    I have a worksheet with database rows showing areas and occupant load factors from space objects. I would like to do a calculation of the occupant load based on the values of these two fields (area/occupant load factor). I understand that calculations in database fields may only be possible using scripting. Does anyone know how this might be accomplished? I've seen a file with a scripted calculation using one parameter, but not two, although I cannot seem to be able to make one parameter work.
  14. Is it possible to use conditional formatting on worksheets? Example 1: If a cell in a line meets a certain criteria I want the line to be highlighted blue Example 2: If a Boolean value is true, I want the text to be bold Example 3: If a record format number value exceeds a specific set amount, it is highlighted in red
  15. I 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!
  16. John Meunier

    Window Style in Worksheets

  17. greentea

    Adding a row in a Report

    Hi there, I am wondering if someone can help me figure out how to add a row in a report. In the attached image, I have a report using the space tool to show the space name and area. I'd like to either: 1. Add a row between 1.2 and 1.3 in order to add a sum of the Total (E) Area, and then add maybe a blank row below to separate from the (N) areas. -or- 2. Make the space labels different somehow based on whether they are (E) or (N). So when I pull a report, I could call up only the (E) or the (N), rather than both. Are either of these possible, or one easier/quicker than the other? Does anyone have any recommmendations for setting up building areas/spaces in worksheets? I am trying to set this up so that it can be used in our office template.
  18. Hello, I have a worksheet that functions as a "Sheet Index" and I'm trying to simplify the criteria that shows the active sheets. Presently my sheets have a numbering system that places an "X-number" and when I ready to have them show up on the Index, I change the X-number to a letter different than X. The only way I have been able to make the sheets no so the I recalculate is to add the criteria (Layer/is not/X-and the exact number) for each sheet. I Would like to be able to specify all the "X-" and have them not show with a single criteria. I have tried Name, Field value etc.. but haven't figured out how to make this work. I'm asking this because for some reason the edit criteria dialog window will no longer let me keep doing this. It's seems to have a reached a limit to the number of criteria of 25, because if I try doing this for some additional sheets I have recently added the function no longer continues to work. Thanks in advance
  19. I've use a lot of concrete stairs and there is no way to obtain the volume, m3 or cubic feet, of a stair, other than rebuild the stair using extrudes or converting to a generic solid and using the 3D properties, but you canont put that data on a worksheet, and in the process you destroy the parametric the stair, and if you change the model you have to redo the stairs, all of them.
  20. Version 1.0.0


    More powerful, than a database or text application. A Vectorworks integrated label-script-example with Marionette. The attached example shows how to import address data from a worksheet (could be other data and sources) and additionally places symbol beside the address. The power of Vectorworks and Marionette allows us to put everything you like dynamically on that labels. As example sort by male and female names (if possibly :-) and generate a individual pictures. Just infinite possibilities.
  21. I would like the ability to add multiple rows in a worksheet not limited by the number of selected rows, or limited by dragging the bottom right handle of the ws. Currently if I want to add 7 rows in the center or a 4 row ws I need to: select rows 3&4 >insert rows, select rows 3-6 >Insert Rows select any single row from 2 to 7>Insert rows. I would like Insert Rows>selection or count?>7 enter.
  22. I believe this has been asked before: Is there a way to return the length of a dimension to a worksheet? Interestingly I can report the dimension height, width, x or y center etc. but am stumped to find the call for the dimension value itself. I'm associating Setback dimensions and would like their values to automatically populate the Zoning Check worksheet.
  23. We are often tasked with quantifying elements in our drawings and dividing these quantities up along different sections of the design. To provide an example, the following screenshot shows an excel spreadsheet being used to track quantities across 9 medians in this case. Each row is a separate line item that we need to provide quantities for and each column to the right, a separate median. Also note that each row is potentially a different unit. It would be great if Vectorworks' worksheets had the capability to do something similar using database headers. I know it is possible by writing individual formulas in cells of a spreadsheet, but that gets cumbersome and potentially creates errors as classes modify and things shift throughout a project. Its a lot to keep track of. I also know that this could be managed by a record with separate fields for each of the medians' quantities, but again, that would have to updated each time the drawing shape changes since there is no way to link a shapes properties (i.e. area, volume, length, etc.) to a record value. We can easily separate quantities using design layers, polygon location references, records, etc, so what I am imagining is a general database header formula...L='Demo' in this example. Then in columns I could use the =C formula to summarize rows based on classes (essentially the line items from the example) above, Use the formula =AREA(LOC='MEDIAN 1'), =AREA(LOC='MEDIAN 2'), =AREA(LOC='MEDIAN 3'), etc. for all of the columns calculating quantities. I don't really have a great way of separating the units (=area, =length, =volume, etc.) though, so I would have to create a database header for each different quantity (which can screw up the order)
  24. I have created a 3d chair just by extracting multiple basic shapes. And i cannot find a way to extract volume for that. Can anyone suggest a way
  25. Hello, I have a room finish schedule set up with the finishes of North, East etc... Now I need the schedule to give me a surface area of each of these walls for take-offs. What Criteria / formula do I need to input in order get this read out? I'd also like to display the Gross Height of the spaces. I've tried everything I can think of. Help! Thanks!



