[2013 feedback]

Hello Kimcz,

We haven't experienced the same delays here.

Please submit a bug report and attach the file(s) so we can investigate.

http://www.vectorworks.net/support/bugsubmit.php

Thanks

Hugues

htsafak@vectorworks.net

[Lines, Line styles & Sketch Options]

Hi Brave,

Could you please add some pictures showing the kind of lines and line styles you'll like to create ?

Thanks

[Worksheets]

Yes this is a bug.

This is fixed in the upcoming release.

[Worksheet Edit Issues- VW 2009]

Jim,

Looking at your worksheet, I see there are many floating cells (cells with text floating into adjacent cells). These types of cells have caused performance issues on the Mac. These issues were fixed in VW2010.

Try to reduce the number of floating cells to a minimum.

Hugues

NNA

[Controlling Wall Joins]

Hi Tomkhat,

You may want to use the Wall Join Tool in Capped Join Mode.

Select the Wall Join Tool and activate the Capped Mode in the Tool Bar. Now click the walls to join them.

Hugues

NNA

[Worksheet to text]

Select the worksheet and use the Convert to Group command. It will convert the worksheet into lines and text.

Hugues

NNA

[Copying Data from report to excel]

Hi Matt,

This was a bug in VW2008. It is fixed in VW2009.

Best Regards,

Hugues

NNA

[Worksheet Cell Functions]

Hi Pat,

Thank you for investigating this.

There is definitely a problem with the LOC criteria when used on objects inside symbols.

Symbols have their own space and the coordinates and boundaries of objects in it are defined relative to that space.

What's happening here is that the poly in symbol returns its location relative to the symbol and this is checked against the location of loc1603 that is in a different space.

Currenly, the only way you would get accurate results with LOC and objects in symbols is by having your reference location in the same symbol.

Could you please submit a bug? We'll address it in the next release.

Cheers

Hugues

[Worksheet Cell Functions]

Hi Ozzie,

Is 'Loc1603' a symbol ?

If yes , then this is the problem.

The LOC criteria is used to find objects that are located within the bounds of a named object. We have just found that it isn't working if that named object is a symbol. Looks like a bug.

If your polygon is within the bounds of another object in your symbol you can try with that one.

And also, use CRITERIAAREA instead of AREA to get the area in area units, so you can get rid of the divide by 1000000*0.08

Hugues

NNA

[Spread Sheet Reports]

concat() is new for VW2009.

[Worksheets!!!]

How big is your file ?

[Worksheets!!!]

Strange behavior. I have no explanation for that.

Please feel free to send me the file and I'll take a look at it.

Thanks,

Hugues

NNA

htsafak@nemetschek.net

[My 3 Wishes!]

Wyle C,

Have you tried the Dimension Exterior Walls... command ?

The command is located under the AEC menu.

AEC->Dimension Exterior Walls...

Thanks,

Hugues

NNA

[My 3 Wishes!]

Wyle C,

If you don't want the wall to unjoin when dragging, make sure that you have the Connected Wall Mode turned on ? It is the last mode button for the cursor tool.

Are you saying that dimensions associated to a wall don't change when the wall changes ?

Thanks,

Hugues

NNA

[Worksheets!!!]

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]

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

[Date in worksheet]

Hi da_muel,

Sorry, there isn't a function in the worksheet that returns today's date or the date the worksheet was updated.

[Auto Row Height and Text Wrap in Worksheets]

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]

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]

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.