Worksheet-Function or Script to retrieve the Name of the actual Worksheet?

[matteoluigi]

Just an idea,

does there exist a Worksheet-Function or is it possible with a Script to retrieve the Name of the actual Worksheet?

 

Guess, it's not possible but, could be a good and easy hack 🙂

[HebHeb]

vielleicht hier ein paar Infos die weiter helfen?

Marionette - get values/strings or formulas from a existing worksheet

[matteoluigi]

sure? I want a worksheet cell to get the name of the worksheet, that cell is in.

[Pat Stanford]

No there is not. I have added an Enhancement Request to have such a function added.

[HebHeb]

Apparently, my memory was incorrect, and the thread doesn't contain the information you were looking for. To get the name as a handle, you need the name... ;D
Sorry!

[matteoluigi]

51 minutes ago, Pat Stanford said:

added an Enhancement Request to have such a function added

I already was afraid, you would say sth like that

[JBenghiat]

Via script, you can get a handle to the active worksheet:

https://developer.vectorworks.net/index.php?title=VS:GetTopVisibleWS
 

and them get the name. But you have to make sure you’re only refreshing the worksheet from its own menu (not all, or on export to PDF, etc)

[Pat Stanford]

Joshua is correct. And that was discussed when we fought this the last time. 

 

In my opinion, that is too fragile to even use because it will return the name of the frontmost worksheet regardless of where the worksheet is in the stacking order or even if it is open if you Recalculate All.

 

Far safer to manually enter the name into a cell so you don't accidentally get the wrong information.

[matteoluigi]

3 hours ago, Pat Stanford said:

n my opinion, that is too fragile

So i prefer doing it manually 🙃 Pitt, Cruz otherwise i could control criteria lines/db-lines just by renaming a worksheet, could be really cool 

[Pat Stanford]

Many cool thing you could do if you new the WS name inside the worksheet. Especially when you start using WS Scripts.  

 

Hoping it makes it in soon.

 

Along with condition formatting, alternating colored lines, zoomable formula bar, etc. etc. etc.

[matteoluigi]

@Pat Stanford

btw, what do you think of a shell pallette inside vectorworks, so if you really want you can directly enter python or vectorscript-code without having to write a script?

(I'm not even sure if sth like that makes sense, but it sounds interesting)

Edited December 3, 2024 by matteoluigi

[Pat Stanford]

It could be interesting, but likely not really useful. Considering how many times I typically have to edit a script to get it to run properly, have a palette to type into instead wouldn't really save much time. 

 

There are not very many things you can do in VW in just a single line or 2. Most useful things either need a loop of some kind or at least 5-10 lines of code. For that much work probably better to save as a script than to just enter one off.

 

$0.02

[MullinRJ]

12 hours ago, matteoluigi said:

btw, what do you think of a shell pallette inside vectorworks, so if you really want you can directly enter python or vectorscript-code without having to write a script?

 

@matteoluigi,

   In each of my template files I have placed and saved a blank script file. See pic. Over the years this has saved me hours by not having to create a palette, a script, and enter the basic opening and closing lines. Once your templates have an embedded empty script, all you have to do is open a new file and your script awaits your every command.

 

 

Raymond