Jump to content

Hugues

Vectorworks, Inc Employee
  • Posts

    1,011
  • Joined

  • Last visited

Posts posted by Hugues

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

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

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

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

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

    • Love 1
  6. 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.

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

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

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

  10. Hi Andre,

    It seems like there is a data corruption in row 14. I would be interested in knowing how this happened. Was the file originally created in a previous version ? Did this happened during file translation.

    Any info would be appreciated.

    Thanks,

    Hugues

    NNA

  11. Very cool. A much more elegant solution than using the old square root of a square trick.

    So the syntax of the IF command is

    =IF((condition)[first comma = 'then']result1[second comma = 'else']result2) ?

    Do you ever need ( ) around the result1 or result2 if they are not simple statements?

    ie. =IF((B1=0),((3.14*A1)/2),(SQRT((A1/B1)*(A1/B1))*-1))

    I'm trying to understand the difference between

    =IF((B1=0), 0, A1/B1)

    and

    =IF(B1=0, 0, A1/B1)

    Michael

    Hi Michael,

    You don't need parenthesis around result1 or result2.

    You only need parenthesis for Boolean statements within an IF statement.

    Also note that you need to place quotation marks around text within an if statement.

    Thanks

    Hugues

    NNA

  12. gmm18,

    yes you can.

    Custom-made records are not different in nature from records derived from objects (plug-in object records)

    The #VALUE! error in the worksheet signals that one or more parameter in your operation has an invalid value.

    Check again the format of the record field (NOT the cell format in the worksheet) and make sure it is not a text.

    If it is in fact a number or integer, then the record might be corrupt. Send me the file at htsafak@nemetschek.net and I would investigate the issue.

    Thanks.

    Hugues

    NNA

×
×
  • Create New...