Worksheet and DLVP Problem

[MikeC]

I seldom use worksheets but the first time I have since upgrading to VW2008 I found a problem that is insidious and potentially damaging if you rely on worksheets.

I found this when doing some simple floor area calculations.

I drew a polyline over a floor plan in the floor plan layer, gave it a name on the data tab, then extracted the area from the named object using a worksheet. The area was 3 times what it should have been, exactly 3 times !

The problem was that the floor had been used in other layers via a design layer viewport. The worksheet was finding the original object and every DLVP copy, adding them together, then returning the combined total.

I do not know if the same happens to other object types but if you use both worksheets and DLVP then you should check your numbers.

[brudgers]

Yes it happens with other objects.

The worksheet criteria can be edited to add inclusionary or exclusionary criteria.

I have found that an inclusionary criterion such as layer-->is-->X will avoid having to edit the criteria every time another DLVP is added.