Pat Stanford

Do you have Unified View turned on? There is a setting to hide the page breaks there as well as in Page Setup.

If you edit it through the Resource Browser you are changing the defaults. Only new symbols inserted after the change will reflect the changes. If you need to edit multiple symbols that have already been inserted you can select multiple symbols in the drawing and then change them both in the OIP. Or even easier since you have the same symbols SUMMED in the worksheet is to change them there. It will change all of the individual records at once.

I am not seeing that in the file you attached. I can edit the record in the Data tab of the OIP and recalculate the worksheet and it shows the changes. I can edit the worksheet and the changes show up immediately in the Data tab. Have you tried it on your sample file? Could it be corruption in your larger file?

Do you happen to have 13 viewports in your drawing? By default, objects are counted both on the design layer and in each viewport. You might need to edit the criteria to list include only the design layers you are interested in.

If you are on VW2012 you can just drag a SUM tile to the columns you don't want totaled. Make sure you select a row in the database first. Before 2012 you were limited to 3 SUM tiles now it is unlimited. Your idea of dividing by the count was the best previous work around.

From the Community Guidelines While NV staff will speak up occasionally, the forum is intended to be a user to user support mechanism.

MK, We talked about this before. The record format has 4 fields times 50 instances each with a separate name (issue01, issure 02, ...). Yes, you could make a worksheet with this info. No, you can't make anything useful from it.

Take a look at this thread: Get PIO Names It might help you to get the proper names for your fields

http://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Number=96244#Post96244

Try resetting your monitor to a smaller resolution then back.

In VW2012 it will both raise and lower points to folllow the roof.

1. Draw the Symbol 2. Attach the record to the symbol 3. Create a piece of text in the drawing 4. Select the symbol instance and the text 5. Select the Link Text to Record command See help on Link Text to Record for more info.

I thought the script was doing this. Can you send me a file (at the address in my signature) with one wall with wall peaks and one without to try the script on?

Currently there are not functions accessible in the worksheet to do this. Are these showing up in a database row live from the drawing or is this something that has been brought over once? If it is live from a database we could create a Vectorscript that would read the data, truncate the string and write it to a user record that could then be used to display in the database. This would not be a live link and you would have to run the script every time you changed MYSTRING. If it is onetime manually entered, we could write a script that would edit the text in the worksheet.

No way I know of to link directly to Excel. If you want to manipulate the data you could create a VW worksheet and then export it and import it into Excel. You can also go the other way, but no live active links. Or maybe you could using the OBDC database routines, but I don't know enough about that to talk.

Robert's original script put up a dialog box asking for the height to set the walls to and then used that height. I was too lazy to troubleshoot that, so I just deleted it and now the script only deletes all the wall peaks and resets the wall.

Check your 3D Conversion Resolution and 2D Conversion Resolution in the Vectorworks Preferences.

Ok, try this script instead. I has been extremely quickly (not thoroughly) tested in VW2012. http://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Number=167482Post167482 Assume all usual legal language here. Use at your own risk. Make a backup first. Do not use while operating heavy machinery. No not use while using alcohol or illegal drugs. Make a backup first. Make a backup first. etc. etc. etc.

Here is an update to the script that no longer let's you set the height, but does remove all the wall peaks and resets the wall so the changes show. The original script fails to function properly under VW2012. Procedure Fix_Walls; var desired_ht:REAL; PROCEDURE HandleWalls(h:HANDLE); VAR result:BOOLEAN; BEGIN ClearWallPeaks(h); ResetObject(h); END; BEGIN ForEachObject(HandleWalls,SEL); END; Run(Fix_Walls);

I just tried it in VW2011 and you are correct it does not work. It does work in VW2012 where I tested originally. The only way you are going to get this to work reasonably is to upgrade. I don't have time right now to work on a script to fix something that has already been fixed in a later version. Sorry

When you create a PIO, you create a "hidden" record format that is called the parameter record. Depending on the type of PIO (Point, line, etc.), you will get some default parameters and you can then add as many other as you want/need. In the worksheet, there are two different types of rows, spreadsheet rows and database rows. Spreadsheet rows are like rows in Excel. Database rows automatically crease a sub row for each item that matches the criteria of the database. You create the database by clicking and holding on the Row Header (the column with the row number) and selecting Database. You then enter the criteria you want to use. As an easy way to play and see kind of how this works (assuming you have Architect), make a new blank file and put in a couple of windows. Make sure that you click the button in the OIP that says On Schedule. Now go to the Tool:Reports:VA Create Schedule and Select Window Schedule. Select the Place WS on Drawing option. Double click on the worksheet on the drawing to open it up for editing. Click and hold on the little black downfacing triangle at the top left and choose Database Headers from the popdown menu. This will expose row 4 (not 4.1, 4.2, etc.). The cells in this Database Header Row contain the formulas for all the subrows. If you click and hold on row header for row 4 and choose Edit Criteria, you will see the criteria for the objects that are displayed in the database subrows. HTH.

Derek, That is a default ability of all PIOs. Just set up a database and use the record.field format in the worksheet and you should be fine. For example ='door'.'width' will give you a column in the database showing the width field of the door PIO. Change it in the worksheet and it will update the object. Change the object and Recalculate the worksheet and it will update. If you don't have spaces in your PIO field names you dont' have to use the quotes, but it is safer.

Tim, Before I spend a lot more time on this please try something and see if it will work for you. Select the cells in column B and Format Cells and set the format to TEXT. Now delete each of the values in column B, hit enter to truly clear the old value and reenter the number. If should now be left justified in the cell rather than right. If you want to check and see if it is really stored as TEXT instead of a number, create a dummy formula and try to add 1 to it. You should get a #VALUE error if it is text. When I do this, I can change the formula for the Position in C11 to =B9 instead of the hard coded 1 and it still works. In my original post I was thinking you were using database rows rather than CriteriaArea functions. You just need to make sure that the cells you are referencing are really text. But I will stand by my assertion that you can't use cell values in setting up Database Row criteria.

If you active layer is rendered and Unified View is not on, you will only see the active layer (plus any that are high in the stacking order.

Criteria are not dynamic in VW2012, so no, you can't just change a cell and have the criteria change. Criteria can be set by Vectorscript, so you could write a script that would read the contents of a cell and then change the criteria to match, but you would have to manually run the script to get the worksheet to update and recalculate. The down side of this is that it would be possible to change the cell, but not run the script. When you print it it says it is for Floor 2, but the data is still for floor 1. If the script idea would help you, send me a file with the worksheet (and some sample data) and a description of what you would like to happen and I will see what I can do. As for the area being off by a factor of 2, are your rows SUMMED? If so, do you have viewports in your drawing? If so, it is probably counting both the original object on the design layer and the ghost copy in the viewport. You will need to edit the criteria to exclude one of those or to only include a specific design layer. Or is it possible that you actually have a second copy on the design layer?