Jump to content


  • Content Count

  • Joined

  • Last visited

Posts posted by sle7en7

  1. Although, is there are like a SUMIF function in VectorWorks?

    To tackle the issue of subtotaling? Meaning, say I have 3 different uses of areas which are stored under one record field and I want the subtotal for 3 types of AREA on either between database cells or on a separate spreadsheet cell, what should I do?

  2. I have another request since I can't code even to survive, and hopefully someone has already have one written somewhere but I was not able to find it.

    This time, I'm looking for an alphabetical sort script which will set the record field from A to Z on a stacking order basis or some other basis ... idk.

    Any ideas, or line of codes?

  3. This is somewhat related to this thread...

    When most of us are talking about creating a VP of the worksheet, it's not a magical feature where you setup a viewport only to show the worksheet content and manage the worksheet display from that viewport as you wish right? I mean, when someone says "create a VP of the worksheet", I imagine drawing a rectangle around the worksheet on the design layer and putting that VP in the sheet layer... It's just seemed like I'm doing something crude and that there is a more intelligent way of doing this that I don't know, so please let me know if such a way exists. And the purpose of writing this message is to find out if such a way exists (e.g; I put a referenced drawing in one of my files and show that as the source of my viewport... is this possible with worksheets as well?)

    Thank you.

  4. Hey Pat,

    Is there a way to do the numbering thing with database headers. Basically I have 200 something objects with a record attached, I do not want to go around putting numbers into each record value but I just want to automatically number them consecutively from a worksheet. Is there a fast way to do this, sorry I'm in a bit of a time crunch and not being as explorative as I should be... thank you very much.

  5. I was just wondering if there is a way to extrapolate cells like you do in excel where you just drag the lower right corner of the cell and it forecasts the trend of the originally selected cells in a vectorworks worksheet?

    I know you can't literally do that in a vectorworks worksheet but is there a way around it? For example automatically number certain objects with attached records? Or fill in a range of numbers from 1 to 360 per say.

    I guess this brings me to my other question which is really general and a topic of discussion but what are the infringement issues with Microsoft Excel? Meaning what are the obstacles ahead of VectorWorks Worksheet to be more like Excel?

    Thank you very much.

  6. Hello,

    I know this thread has been inactive for a while, but I have a question about this space tool. First of all I do not see a "space tool" under my space planning toolset. I have a Raum Tool CW which whenever I try to use pops up this message;

    "error occurred while opening plug-in. Make sure that there is a "Plug-ins" folder in the same folder as the application."

    The Raum Tool shows up as a .vwr document rather than as a .vso like other vectorworks plug-in objects in the VectorWorks file directory. Not sure if that is related but it's a piece of information.

    Other than that, how can I turn a rectangle or a polyline into a space object I guess? I'm using this particular file in 2D.

    Thank you very much.

  7. I was messing with worksheets again to create an areas table with length and width listed but do not want to put the information manually because I'm... umm LAZY, but fell short of the task basically.

    So after searching the forum a bit, I was unable to find a way to call the Width/Height of a rectangle in a database header. Is there a way to do this (like punching in "=S" to call a symbol's name) or is this information not stored as a default data like area, perimeter or ratio?

    Thanks for all the help in advance. :blush:

  8. ok PAT (or anybody),

    I have another question/problem. I'm attaching the worksheet I'm working on as well. I have done what you have told me I suppose;

    For editable fields, create a custom Record Format and attach that Record to the objects. Set the criteria for the column to show the fields from the custom Record. You can then enter the data either manually into the cells in the database or using the Data pane of the Object Info Pallette (OIP)

    This time, the custom record format I have created gets multiplied by the number of symbol instances in the file and result in a wrong "DIFFERENCE" number. I have tried couple of tricks ("VALUE" function or storing the record format as text information) but couldn't find a way around. You think there is a way around this?

    Thank you once again.

  9. I have a question as well; somewhat in the same ballpark. Say, I have a worksheet with a single database header.

    Can I limit the columns that the Database Sub Rows goes?

    Meaning, I want to create other columns which have editable rows in them for comparison purposes which I will manually punch in the numbers.

    Thank you for the support.


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