matteoluigi Posted December 2, 2024 Share Posted December 2, 2024 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 🙂 Quote Link to comment
HebHeb Posted December 2, 2024 Share Posted December 2, 2024 vielleicht hier ein paar Infos die weiter helfen? Marionette - get values/strings or formulas from a existing worksheet Quote Link to comment
matteoluigi Posted December 2, 2024 Author Share Posted December 2, 2024 sure? I want a worksheet cell to get the name of the worksheet, that cell is in. Quote Link to comment
Pat Stanford Posted December 2, 2024 Share Posted December 2, 2024 No there is not. I have added an Enhancement Request to have such a function added. 1 Quote Link to comment
HebHeb Posted December 2, 2024 Share Posted December 2, 2024 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! Quote Link to comment
matteoluigi Posted December 2, 2024 Author Share Posted December 2, 2024 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 Quote Link to comment
JBenghiat Posted December 2, 2024 Share Posted December 2, 2024 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) Quote Link to comment
Pat Stanford Posted December 2, 2024 Share Posted December 2, 2024 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. Quote Link to comment
matteoluigi Posted December 3, 2024 Author Share Posted December 3, 2024 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 Quote Link to comment
Pat Stanford Posted December 3, 2024 Share Posted December 3, 2024 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. 2 Quote Link to comment
matteoluigi Posted December 3, 2024 Author Share Posted December 3, 2024 (edited) @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 Quote Link to comment
Pat Stanford Posted December 3, 2024 Share Posted December 3, 2024 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 Quote Link to comment
MullinRJ Posted December 4, 2024 Share Posted December 4, 2024 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  4 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.