Jump to content

Hugues

Vectorworks, Inc Employee
 View Profile  See their activity

  • Posts

    916

  • Joined

  • Last visited

 Content Type 

Posts posted by Hugues

    Worksheets!!!

    in Architecture

    Posted

    CS1,

    This is strange.

    Try again and double-check to make sure that the worksheet lists only objects that meet the layer criteria.

    To check that, add a column in the worksheet and enter =L to return the object's layers.

    Also, are you comparing the results from the Custom Selection command and those from the worksheet database ? You may see differences in the number of objects that meet the criteria. The reason is that because DLVPs objects are not selectable, no search is performed in DLVPs when running Custom Selection.

    Thanks

    Hugues

    NNA

    "Custom Selection": Objects in symbols

    in General Discussion

    Posted

    Hi team,

    Custom Selection selects the objects but doesn't change the active layer to make them visible.

    If you want to do a cross document selection using Custom Selection, you'll get the best feedback if all layers are visible and the options Show/Snap/Modify Others is set.

    Objects in symbols will also be selected but you'll have to enter the symbol to edit it.

    Hugues

    NNA

    Auto Row Height and Text Wrap in Worksheets

    in Architecture

    Posted

    Hi Sam,

    I am sorry but there is nothing you can do except what you are already doing that is increase the height of the database header row.

    The reason for this problem is that rows in the same database are not allowed to have different heights in Vw08. What you see in the editor is actually misleading at the end the database row will always pick the height or the database header row.

    AutoFit row height only works well with wrap text in spreadsheet cells.

    We have resolved this issue in Vw09.

    Thanks.

    simple windows schedule question

    in Architecture

    Posted

    As Ariel mentioned, you can place a SUM icon on the column where you don't want the numbers to add up. But you can only use a maximun of 3 SUMs in a database.

    If you run out of SUMs, the workaround is to add a quantity column at the end of your worksheet, enter the formula =COUNT. Now you can use a reference to this column to divide the columns where you want to eliminate the summation.

    With H being the quantity column, the formula in your windows width column could then look like this: =(Window.OverallWidth)/H4

    Wrapped cells with auto calc row height problem

    in General Discussion

    Posted

    The database functions like a block and the database header controls the format and the height of the database cells. You can not set the height for individual database rows. However, database row heights should automatically adjust to fit wrap text, but it doesn't in VW2008 and this is a bug that will be resolved for the upcoming release.

    Thanks,

    Hugues

    NNA

    Cell references in worksheet formulae

    in General Discussion

    Posted

    Hi Pat,

    Worksheet criteria functions are use in database with no criteria as parameter (e.g. =XCenter ) since the database provides the criteria.

    But you can also use them in spreadsheet cells and pass the criteria of your choice. They will return the value for the object that match the criteria. If multiple objects match the criteria it returns the sum of all values (e.g. =AREA(T=RECT) ; returns the area of all rectangles in the drawing).

    Also, the 'record'.'field' syntax works in criteria functions and it find all objects that have this record field attached to it.

    Thanks

    Hugues

    NNA

    Cell references in worksheet formulae

    in General Discussion

    Posted

    Hi Laura,

    This should work.

    The problem in your worksheet is that the criteria in the XCenter and YCenter functions is comparing string with numbers

    The 'Co-ord'.'Ref' field is formatted as a text in your record.

    =XCENTER((('Co-ord'.'Ref'=A3))) doesn't work because cell A3 is a number.

    =YCENTER((('Co-ord'.'Ref'='3'))) works because '3' is a string.

    You should change the format of your record field to an integer.

    Thanks

    Hugues

    NNA

    Recalculate multiple worksheets

    in Architecture

    Posted

    Hi Laura,

    Here is another tip if you are working with large files and large worksheets that take time to recalculate.

    If you are editing a worksheet and you don't want it to automatically recalculate everytime you enter a cell, you can turn off the Auto-recalc preference for that worksheet.

    Just open the worksheet preferences dialog and uncheck the Auto-recalc check box. Editing a cell will now just update that cell and you can manually recalculate the worksheet later on.

    Hugues

    NNA

    Recalculate multiple worksheets

    in Architecture

    Posted

    the recalculate command in the right click menu recalculates all worksheets throughout your file.

    You don't have to use a script unless you just want a particular set of worksheets to be recalculated.

    When I right click that option is not present, I have been in to my workspace and searched "all menu items" and cant find anything that resembles "recalculate" that I can add to my list of right click options.

    Make sure you are right clicking on a selected worksheet image.

    Worksheets and Odd Fonts

    in General Discussion

    Posted

    Do you get the same result with GDI+ Imaging ON and OFF ?

    I understand from your post that the problem is with this specific cell only. What happens when you clear the cell and reformat it ?

    Can you reproduce this problem consistently from a new worksheet ?

    Hugues

    NNA

    Using worksheets to calculate floor area totals

    in Architecture

    Posted

    Yes of course you can combine criteria in worksheet criteria functions.

    For example,

    =CRITERIAAREA((ST=FLOOR) & (L='Design Layer-1') & (C='class1'))

    give you the areas of floors of 'class1' that are on 'Design Layer-1'.

    You can use the Paste Criteria command to build and insert the criteria into your function.

    It seems like CRITERIAAREA and some other new functions are missing in the documentation. Thank you for pointing this out. I'll make sure that they are documented in the next version.

    Hugues

    NNA

    Worksheet / Design Layer Viewports / Framing Members

    in General Discussion

    Posted

    Hi Andre,

    This is not a bug but rather a confusing design.

    The "viewports" criteria is actually used to tell the engine to search into the annotation space of sheet layers viewports.

    Note that if you create a sheet layer viewport your objects are not counted twice even though the "viewports" check box is checked.

    Design layers viewports don't have an annotation space and this is the reason why the "viewports" check box has no effect.

    I agree that we need a simple criteria to search design layers viewports. However this would have to be a new criteria since it doesn't make sense to tie it with the search into viewport annotations.

    Hugues

    NNA

×
×
  • Create New...