[Wrapped cells with auto calc row height problem]

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

[Trouble with Window Schedule Consolidation]

Try to move the Quantity column to the end of the worksheet.

The location of this column matters in a summarize database. It is recommended to place that column right to the column where you reference it for best results.

Of course this is a bug.

Hugues

NNA

[Cell references in worksheet formulae]

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]

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]

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]

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.

[Trouble importing worksheets]

The file may be damaged. How was the file created and what was the original extension ?

Can you open the file in a text editor ?

Please send the file and I'll take a look at it.

htsafak@nemetschek.net

Thanks

Hugues

NNA

[Worksheet Formulas]

Yes, you can do this.

=E2*F2 is the formula you need to write in cell G2.

Hugues

NNA

[Changing Object Names and Record Fields]

Only record fields are editable in a two-way worksheet. If the object names are in a record they will be editable. The two-way worksheet was not designed to be a replacement for the Object Info Palette where you can edit everything from X-Y coordinates, Class, Layer etc...

Hugues

NNA

[Worksheets and Odd Fonts]

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

[Worksheet cells and record fields]

MicThorn,

Also be aware that Two-way worksheets is not available in VW Fundamentals. You'd need a Design Series product.

Hugues

NNA

[Using worksheets to calculate floor area totals]

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

[Using worksheets to calculate floor area totals]

Hi Markus,

If all you need is the total area of all floor objects, then you don't need to create a database. You can use this function in a spreadsheet cell.

=CRITERIAAREA(ST=FLOOR)

Hugues

NNA

[Using worksheets to calculate floor area totals]

Hi all,

yes this is a bug in the AREA function. We recommend the use of CRITERIAAREA that was introduced to solve that problem.

Also VOLUME and SURFACEAREA should be replaced with CRITERIAVOLUME and CRITERIASURFACEAREA.

Hugues

NNA

[Copying "Criteria" for "Database" in Worksheets]

Yes, simply copy the database row and paste it into another row.

[Worksheet / Design Layer Viewports / Framing Members]

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

[What to do in worksheets when there are zero values]

Hi Michael,

Yes, that's true. Pat is right!

I'll see if this behavior can be changed.

Thanks

Hugues

[Worksheet S%#$ the bed]

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

[What to do in worksheets when there are zero values]

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

[What to do in worksheets when there are zero values]

This is not a bug. Boolean statements within an if statement must be in parentheses.

You should write: =IF((B17=0),0,B17)

Hugues

NNA

[How to export Worksheets on drawing]

Worksheets on drawing export to DXF/DWG in VW2008.

["Framing Member" field: span in worksheet]

You can use this:

=('FramingMember'.'LineLength')

[Worksheet-"#VALUE!" Error]

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

[Worksheet-"#VALUE!" Error]

Make sure that your record fields are not formatted as strings.

Hugues

NNA

[Wrapped cells with auto calc row height problem]

Yes, the format of a database cell is always linked to the database header cell. The height of a database row is linked to the database header row.

Prior to VW2008, database cells were only selectable as a block. Now with the introduction of single selectable database cells and 2way worksheets, this linkage doesn't make sense anymore.

Hugues

NNA