Pat Stanford

I believe that Associative Dimensions only work with 2D and Hybrid objects in Top/Plan view. So if you are trying to dimension objects in other views or non-hybrid objects, you are not going to get Associative. Associative dims will show a small green square at the points they are associated.

For the rotation, I think you will have to edit the symbols and rotate the objects in them to be horizontal in the definition. Which means that you will have to edit every place you use them in your drawing. For size, you can select the database header row cell and edit the Cell formation for Image. Best option will probably be fixed size, but that will make your different length poles all show the same. Maybe you want to use the Layer Scale or a Fixed Scale, but I you have objects that are very different sizes in the drawing then some of them will probably appear too large or too small. The image functions work best with objects that are all of similar sizes.

But Copy/Paste into a record format would be easier than a popup that you had to manually click for every door you needed to change in any case.

That is wireframe mode. Go to the View menu: Rendering and choose Shaded

There are a number of WS Functions that you can't pass criteria to in Spreadsheet cells. RunScript and standard Record.Field are the two most obvious and ones that could be made more useful by having a way to pass criteria. And I think the ObjectData - 'Universal Value' kind of supports criteria for Record.Field but as we said in the other thread, it is currently hindered by not handling compound criteria. Maybe Someday.

A Database SubRow (unless it is SUMmarized) and a Data Tag both return a reference to a single specific object. In this case of the Data Tag, that reference is to a Worksheet Image. Once you have the handle to the Image you can get the Handle and then the name of the parent Worksheet object. In a Database subrow, since the objects returned (except for the special case below) are not Worksheet Images, there is no way for a script to know what environment it is running from. So a worksheet script can't say "I'm running inside of Worksheet XYZ" (actually it could, but it does not do that now). So since you can't get the handle to the worksheet, you can't get the name of the worksheet either. The special case would be a worksheet which had a database row with a criteria of Object Type is Worksheet Image. In that case you could probably get the Worksheet name for each image. And maybe you could do some trickery in the criteria to only return a single Worksheet Image that happened to be an image of the worksheet producing the image and be able to get the worksheet name. But as I was once told: If you want to play be my guest. Create a worksheet with a database row returning Worksheet Images and see what it would take to get the criteria set to only show a single image. You could then use a =RunScript('WSNameToTag') script from above to return the actual worksheet name from the resource manager. I think the effort to define the criteria would be much harder than just typing in the name. But maybe if you only had one worksheet on each layer and could use just a layer criteria it might work, Good Luck.

Database rows can be sorted by any column by clicking the disclosure triangle in the database header row for that column and choosing Ascending or Desending. You can sort by Multiple Columns, but you may have to remove the sort and replace them if you want to change the sort priority. There is no sort capability for Spreadsheet rows.

Yes. The worksheet has no way of knowing what its name is. In this case, since you can't Data Tag a worksheet, but only a Worksheet Image, I use that to our advantage. I can get a handle to the worksheet from the worksheet image and then get the name of that worksheet. The Data Tag just happens to be able to use the WSScript_GetObject and WSScript_SetRetStr functions to do the I/O and find out the tagged object.

Copy the single line below and paste it into a blank Vectorscript named WSNameToTag WSScript_SetResStr(GetName(GetWSFromImage(WSScript_GetObject))); Once you have the script created, edit your tag to include the following line: #WS_RUNSCRIPT('WSNameToTag')# All of the punctuation is critical. Just copy and paste and it should work. The script will have to be included in every file that you want to use the Data Tag in. HTH

Maybe things have changes I did have not noticed. I learned about the hard code long ago before almost everyone had a mouse with s scroll wheel for zoom. I think that originally the Z and X keys were configured for zoom. And then those were needed some something else and 1 & 2 were added. But I just realized this weekend I have been using VW (Minicad) for 33 years (1991 MiniCad 3+). So there are a lot of things that I "know" that are no longer true. 😉

Ctrl-1 and Ctrl-2 are hard wired to Zoom In and Zoom Out. You can't override those settings. But it might be a good idea to post your desire to do so in the Wish List Forum. Glad you found the Num Lock so you can switch between view change and navigation.

From a strictly algebraic viewpoint, 1 Meter = 1000 mm, so if you enter D in MM you need to divide it by 1000 to get meters. So the following should get you the SRZ in meters while allowing you to enter D in mm. SRZ radius = ((D / 1000) × 50) to the power of 0.42 × 0.64 If you want the SRZ to be reported in mm, as well as entering D in mm then you will need: SRZ radius = (((D / 1000) × 50) to the power of 0.42 × 0.64) * 1000

Tell me more about what you are trying to do. Are you going to use this in a Worksheet Database of Title Bock objects? If not, how do you expect to determine which Title Block the data is being pulled from?

I hope I am wrong and someone will correct me, but I don't believe there is a way to generate a text string inside a worksheet and have it converted to a formula. This is one of the things that makes working with Revision and Issue records difficult. You could use a Vectortscript/Python Script to read the data from those cells and generate the formula in the desired cell, but I think the user interface would be challenging. I think the best solution would be a worksheet script.

Sorry for the delay. Crazy week. Worksheet Function Documentation is available here: https://developer.vectorworks.net/index.php?title=Worksheet_Functions#General_2 What the original poster was looking for (or kind of looking for) is a way to generate a display of Feet & Inches from a dimension in millimeters. The worksheet TXT function will generate a string representation of a dimension conversion. It will be a string and not a number, so you can't use it in calculations. In a document with Dimensions set to millimeters, and a dimension value stored in cell A3, this function will return a string showing the feet and inches value with fractional inches rounded to the nearest 1/16th of an inch. =TXT(A3, 'FeetNInches', 'Frac', '1/16') If you are in a country that used the comma as the decimal point in numbers you will need to use semicolons [;] to separate the function parameters instead of the commas I have shown. HTH. Ask if you need more help.

Is it possibly shifting between your printer for printer setup and Any Printer? Any Printer typically has larger margins than specific printers therefore a smaller print area.

Edit the Title Block Layout and make sure that the "placeholder" text for those fields is set to use Dynamic Text in the OIP. If they are then check the Dynamic Text settings and make sure they are set to the field you want. Ask again if you need more clarification.

You are trying to use the Database criteria in the worksheet cell instead of in the database header. Right click on the Row header (I usually start at Row 3 because it is easier to add extra lines above later when I figure out what titles I need). Choose Database from the popup menu. This will open the Criteria Builder When you click OK on the criteria builder, the Database function will be automatically created. To edit later, right click on the database row header and choose Edit Criteria. Or if you want to manually adjust the criteria choose the Edit Database Formula and the database formula will appear in the formula edit bar so you can change it. Sorry that I didn't pick up on your putting the database in the wrong place on your first post.

Because worksheet are older than dirt and there was not right click menu when they were created. 😉

I filed a bug last October (VB-199689) on the fact that ObjectData is not accepting compound criteria. There does not seem to be any progress on the bug since it was filed. So short answer today is you can't do what you are trying to do. 😞

Post the file happy to look. If you use the same criteria in a database row, how many objects does it return? It is likely that there are no objects that satisfy the criteria which is why it is returning zero. For the record.field functions, the criteria would be something like: ('Space'.'11_Name'='Room123') All three of the field you named are defined as Text, so you will need the single quotes around the value you are comparing them to. if you have a Space with the 11_Number of 99 then ('Space'.'11_Name'=99) won't work, but ('Space'.'11_Number'='99') should.

Close, but your parentheses are wrong. I think the below will work but have not tested it. =OBJECTDATA(((L='Ground Floor_SPACES') & (PON='Space')), 'universal value', 'Space', 'EnergyArea') ObjectData requires four "parameters" that have to be independent and separated by commas (semi-colons in languages that use commas as decimal point) 1. The Criteria. This specifies the objects to be used. You can use the Worksheet Insert menu can click Criteria to open the criteria builder with all the correct parentheses. 2. The ObjectData "Function". In this case it is 'universal value' 3. The Record Name. If this is left blank and the criteria is for a single object type the object parameter record will be used. In this case since there is a complex criteria (even though it specifies a single object type) I am not certain if it will find the correct record, so I have manually entered the name of the Space object Parameter Record. 4. The Field Name. HTH.

Unfortunately, I don't think it is a bug but rather a design decision. So it is unlikely to be changed for VW2024. There have been several other similar comments so it may get traction for a future version. There are ways to hide an application window. On Mac you can either minimize the app or you can hide the app. I believe there are similar functions on Windows. Learning the shortcuts for those may be your best way forward. But if this is a deal breaker, you will have to stay with VW2023 for now.

If the problem is only with that one file, it sounds like it could be some kind of file corruption. Try creating two new files and importing 1/2 of the layers with objects from the problem file into each one. If one of them opens slowly, then you know the problem is with the layers in that file. Repeat as necessary to identify the layer with the problem. Then duplicate the file and delete 1/2 the objects. If still slow then the problem is in the remaining objects. If not slow, then repeat with the other 1/2 of the objects. Or if both of the first 1/2 files are quick, then import the layers so you are back to one file and see what happens. And make sure you are running the latest update (3.1) to VW2024.

I am about out of ideas. What happens if you copy and paste the objects into a new blank file?