Pat Stanford

vs.PointAlongPolyN

I don't think it matters what order you select the items. I believe it is actually using the Stacking Order for the objects. So the first object drawn will be at the bottom of the stacking order and will be returned by LSActLayer. The last object drawn will be at the top of the stacking order and will be returned by FSActLayer. You can change the stacking order by using the Send to Back/Send Backward/Send to Front/Send Forward commands. The VS/Python equivalent is MoveBack/MoveBackward/SendFront/SendForward

Materials are basically a data standard that can be used to identify the properties of bulk site materials like Concrete, Stucco, Wood, Metal, etc. By defining an object in VW to use a Material it is a relatively easy way to have uniform bulk properties that can be used for things like energy calculations. Materials can also have textures assigned to them so you have a uniform graphical appearance of items that use that material. Texture are a purely graphical feature that allows you to put a "sophisticated" image onto an object that in addition to having a color can have an image, transparency, bump map, etc. to more accurately reflect what the object would look like in a real world setting. If you extrude a rectangle and set it to have a Texture of concrete, you will get an object that looks like concrete. But if you assign a concrete material to the object you can also calculate the mass, thermal impact, sound isolation, etc. As of VW2024, most of the VW PIOs (doors, windows, etc.) do not use Materials, but rather have their engineering properties defined for the complete object rather than trying to calculated them from all the various Jams, sashes, leaves, frames, etc. that make up a door or window. In commercially available doors/windows, that energy/mass/sound/insulation properties is pretty readily available from the manufacturer.

Jeff, Thank you for putting something that I have been thinking but unable to properly articulate into such a concise statement!

I don't know what the name of the "language" is. It is not really a language, but more of a tag system. You can do a little bit of math and have access to an IF/Then (actually that is called a trinity operator). You then have "full" access to Python and Vectorscript through the Worksheet #WS_RunScript command. But then, as I have been told,

Thank you Hughes. You are correct the the number of digits vs the number of decimals was what I was not understanding. @ashot It looks like you are stuck with 11 decimal places if your integer part is 2 digits or 10 decimals if the integer part is 3 digits.

My standard answer: No and Yes. No. I don't think there is a way in data tag notation to dynamically do the math to determine a cell value like you are trying to do. There does not seem to be a way to force a calculated string to be treated like a function. If you only have a few Beams, it might be reasonable to do a series of nested IF statements, but more than 5 or 10 and your string would probably exceed the maximum formula length. Yes, Maybe you could write a worksheet script that would be able to do what you want. But that script would have to live in every file or be stored in your user or workgroup folder and moved/upgraded every time you upgrade VW.

The Drawing Label does not allow you to access the Viewport Name. But you can get it in a Data Tag using the #N# definition. If you name your viewports as you create them, the Viewport Name is stored in the Drawing Number field. This can be accessed using the #Drawing Label2#.#Drawing# definition. If you rename the viewports later the name is not automatically transferred so you would have to edit it in both places or copy/paste between the two.

Highlight a part or all of the text of a post and you will get the Quote Selection prompt which is close to what you want about replying to individual answers.

The ones where Select Object are greyed out are likely to be lines where you have multiple objects SUMmarized together. Select Object only works if you have a single object in the database subrow.

I think the other thread has a worksheet script that returns all the popup values.

Thanks Vlado. But I think TXT has a limitation also. =TXT((B7+0.0000000000001), 'Decimal', '0.0000000000000000000000', 'No Units', 'Trailing Zero') Where B7 has a number with an accuracy of 11 decimal points. Adding the 1 in the 13th decimal place still displays only 11 decimal points even though I have the TXT set to specify 20. It also seems to ignore the Trailing Zero parameter. If you set TXT to use scientific notation 'Sci", then you get more decimals, but they are wrong. B7 is the number in B2. B8 is the number in B2 set to display as Text. B9 is the TXT with Decimal output. B10 is TXT with the output set to Sci.

Simple answer is no. There are no worksheet functions to display the multiple pop-up choices. More detail about what you are trying to do and it MAY be possible with a worksheet script. Here is one that takes the Record and Field names as parameters and returns the popup values. Procedure PopupDefaults; {©2024 Pat Stanford - pat@coviana.com} {licensed under the Boost Software License 1.0} {https://github.com/boostorg/boost/blob/master/LICENSE_1_0.txt} {TL/DR Use as you want, attribution for source, No warranty} {Worksheet script to provide all popup values of a Record.Field. Maximum of 50 PopupSetChoices} {Run in worksheet using =RunScript('PopupDefaults','Record Name', 'Field Name2Index} {Set to separate values with a colon as with defatul row height only the first value shows} {Change the middle of the For N2:= line from ' : ' to CH R(10) (without the space) to put on separate lines} VAR Rec, Fld, S3:String; N1,N2:Integer; A1: Array[1..50] of string; BEGIN Rec:=WSScript_GetPrmStr(0); Fld:=WSScript_GetPrmStr(1); PopupGetChoices(Rec, Fld, N1, A1); S3:=A1[1]; For N2:=2 to N1 DO S3:=Concat(S3, ' : ', A1[N2]); WSScript_SetResStr(S3); End; Run(PopupDefaults); @Jeff Prince are you a magician? I was 30 seconds from posting when your post came through. But then the Forum bug that won't let you use certain (CH R) text strings in a post caught me. 😉

Do you want the value of the field for a specific object? Or do you want the default value of the field for that record? If you were working in Database cells, then the object would be already defined and all you need to do is display the value from the attached record. But since you are in a Speadsheet cell you will also need to define which object to use the record from.

What is wrong with the image on the right? It seems to be providing the value? Or it providing the value for only one of the spaces? Do you have the Sum Values box checked in the database header for that column?

IF you typically wait 8 years to replace your laptop, spend the money and get the higher RAM. While you might be able to get by with 18, I don't think you will enjoy it especially with lots of VW/Chrome tabs and PS open. And even if it works today, in 4 years the memory demand of programs will probably be greater and you will be even less happy. Get the higher RAM.

It appears that a VW Worksheet only supports 11 digits after the decimal point. @Vlado Can you comment on this? If you format a cell as Decimal you can specify additional digits for display, but I was not able to find a way to enter those digits. Apparently 8 digits in Lat/Long is adequate to get millimeter accuracy. Do you really need more than that? As for your other question about Why E2 + F2 was returning a number. Formatting a cell as text does not change what is actually stored in the cell which in this was was a number. So you can use the + sign to add the values. =CONCAT(B9, ', ', C9) Will take a number with up to 9 decimal places in the cells, or text in the cells and return them in a single cell separated by a comma. If you format a cell as a Decimal Number with a certain number of decimal places and then convert the display of the cell to Text, the text will use that number of decimal places (up to 11). HTH

And a note on the above. If the cells you are trying to reference are in database subrows, the above will not work as you can't directly access a subrow because they are "dynamic" and the sort order (and the cell reference) could change based on adding or removing objects from the drawing. If you have to use a database, it might be possible to use a Worksheet Script to locate and access the data, but the script would have to live in every file you want to have the funcationality in or be stored in your user / workgroup folder and updated every time you upgrade VW.

If you are using Worksheet Cells then you can use a #WS_ function to return a cell value into a data tag. #WS_Concat('Worksheet-1':A1)# I used Concat because it will grab the text from the cell and display it as text even though it is only a single value. If your output is numbers and you need to have specific formatting, you might be better off using the TXT function instead as it provides options for setting unit and data formatting. Enclose the worksheet name in single quotes and then follow that with a colon and the Cell Reference not in quotes. Worksheet function reference here: https://developer.vectorworks.net/index.php?title=Worksheet_Functions#General

I have not used a Windows machine in more than passing in over a decade, so I don't know HOW to do it. I only know that there have been several people complain about poor VW performance who it was determined that VW was using the "wrong" video card.

Do you have Snaps as one of the options in the Smart Options display? If so perhaps that is how/why snaps are "randomly" getting turned on/off by accidentally clicking on the SOD?

I think the Edit Title Block Layout is greyed beause it is set by the Style. Click and hold on the Style popdown and one of the options should be to Edit Style. From there you should be able to Edit TB Layout and check that the placeholder text is linked to the TB Project fields.

Check and make sure that VW is set to use the NVIDIA card and has not gotten switched to the low power built in graphics. Not certain how you do this on Windows.

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.