-
Posts
1,011 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Articles
Marionette
Store
Posts posted by Hugues
-
-
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
-
1
-
-
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
-
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
-
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
-
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
-
Worksheets on drawing export to DXF/DWG in VW2008.
-
You can use this:
=('FramingMember'.'LineLength')
-
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
-
Make sure that your record fields are not formatted as strings.
Hugues
NNA
simple windows schedule question
in Architecture
Posted
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