Pat Stanford

You are not going to use Cut/Copy and Paste. You are going to have to read the cell, do the calculations and then write the data to the correct cell. Check out the GetWSCellValue in the Function Reference for getting values from cell. Use SetWSCellFormula to store a value into a cell. The name is a little misleading, but a number is considered a valid "formula" in a cell.

Try this: That should take you to the latest version that is posted. You might want to read back through the thread to see how it developed and the limitations. Put a single selected instance of the PIO in the drawing and run the script. Objects in Walls don't work.

Paste the following line into a new blank Vectorscript editor window: DSelectAll; SelectObj(INSYMBOL & INVIEWPORT & ('Space'.'11_Default Stamp'='Space Tag-Simple w/ Area')); Edit the space name at the end to what you need. Run the script. Sorry for the brevity, really short on time today. Regards, Pat

LOC is an interesting criteria. Create a polygon (rectangle, circle, basically any closed 2D shape) and give it a Name in the OIP (bottom of the Shape pane). Create a Worksheet with a database Row. Put in a Criteria of LOC is 'name that you gave the shape' This should give you one subrow for each object that is within the named shape. This works best in Top/Plan and then you can use the XCenter and YCenter functions to get the "insertion point" of the objects.

I don't use space objects enough to understand your question. Can you explain what you are trying to do? If the information you want is not already part of a record attached to the object you are either going to have to manually paste it into a worksheet database that lists that record.field in a database section, or you are going to have to run a script that will calculate the necessary information and store it in the record.

From the Function Reference Notes on GetFolderPath: Note that use of the negative values of these constants can be used to get the user-based folder path. The positive values are for application-based paths, which should not be used for writing. So try and see if you can get what you want with GetFolderPath(-1).

Either it is not a closed polygon or you have the fill set to None. If it is not closed you are effectively just extruding a line so there is no surface. If the fill is set to None it is a similar effect. Give it a solid fill and see what happens.

I only took a really quick look, but I don't see where you are storing the Temp back into the original string/array. I think you need to DELETE the original command and INSERT the temp at the same location. Python is certainly better at string manipulation, but this is well within the capability of VS.

You have to create the workgroup folder. Go to Vectorworks Preferences to the User Folders tab and you can create as many Workgroup folders as you want at whatever location you want. If you want others to be able to use it, it will beed to be stored in a location on the network they can access. You can use different Workgroup/Project folders to keep the content for different projects separated. I.e. If you were doing planting projects in both Florida and Alaska, you probably would not want to create one big plant file. Better to keep that information separate as they are not likely to overlap. Similarly if you were doing commercial and single family, it might be better to keep the data separate.

The STA file needs to be stored in the Templates folder. There are three parallel locations to store Vectorworks Templates and Default Content. These are the Application Folder, the User Folder, and the Workgroup Folder. I don't recommend the Application Folder as this location could possibly be overwritten by an update to VW. If it just you using the template, then I recommend the User Folder. If there are multiple people in the office who need access, I recommend you set up a workgroup folder and put it there. Search the Help for the location of the User and Workgroup folders on your operating system. Inside the User or Workgroup folder there should be a Libraries folder and in that a Defaults folder. Inside that there should be a Templates folder. If it does not exist, just create the folder. Store your templates files inside the Templates folder and restart VW. You should get your STA as an option the next time you go to create a new document. Application/User/Workgroup Folder:Libraries:Defaults:Template

I don't know why it is not showing up in the report creator, but you can add it manually. Worksheet View Menu, select Database Headers. Add a column to the report where you want the label to be shown. Select the database row cell to enter the formula in (i.e. 3, not 3.1, 3.2, etc.) Enter a formula of: =('Feeder Cable VW'.'End Label Text') Hide the database headers and you are set to go. Save the worksheet and use that from the resource browser (put it in a library file) rather than using the report creator to make the report each time so you don't have to manually add this. Submit a bug report on the report creator that the End Label Text should be an accessible part of the report.

Unless the data in a cell is text, you should not need the Value statement at all. Value takes a text representation of a number and converts it to the numerical value. 1. Set the formula in C1 to =A1*B1. What do you get? 2. Set the formula in C1 to =Value(A1)*B1. What do you get? 3. Set the formula in D1(or wherever does not mess with your worksheet layout) to =B1*2. What to you get? 4. Set the formula in D1 (or wherever) to =Value(B1)*2. What do you get? Hopefully this will let you figure out what is going on. If you need more help, please ask again.

The Worksheet script in this post shows how to use a script to read the Class Description.

Try SetDrawingRect and see if that will do what you want/need. If not, I think you will be stuck with opening the dialog box using DoMenuTextByName.

Whatever you say, but since you say this is intermittent, it seems like this could be a problem caused by less experienced users. This one below looks to me like it has a slash in the file name and is trying to create a new folder. Look right before 101_barba...