-
Posts
916 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Articles
Marionette
Store
Posts posted by Hugues
-
-
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
-
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
-
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
-
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
-
Hi da_muel,
Sorry, there isn't a function in the worksheet that returns today's date or the date the worksheet was updated.
-
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.
-
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
-
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
-
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
-
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
-
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
-
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
-
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.
-
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
-
Yes, you can do this.
=E2*F2 is the formula you need to write in cell G2.
Hugues
NNA
-
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
-
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
-
MicThorn,
Also be aware that Two-way worksheets is not available in VW Fundamentals. You'd need a Design Series product.
Hugues
NNA
-
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
-
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
-
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
-
Yes, simply copy the database row and paste it into another row.
-
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
-
Hi Michael,
Yes, that's true. Pat is right!
I'll see if this behavior can be changed.
Thanks
Hugues
Worksheets!!!
in Architecture
Posted
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