Jump to content

Recommended Posts

Is there the ability to make a VW 2019 file ALL CAPS? Including databases and text styles.

So far my workaround has been to manually type in CAPS, but the database header has got me stumped.

 

I must be missing something. Any help is appreciated.

Thank you

Database CAPS.png

Share this post


Link to post

@John Meunier

 

Not that I am aware of...but this is something, along with general Text handling, that VW desperately needs. ALL CAPS is industry standard for construction documents and has been forever. Needs to be implemented ASAP!

  • Like 1

Share this post


Link to post
19 hours ago, ericjhberg said:

@John Meunier

 

Not that I am aware of...but this is something, along with general Text handling, that VW desperately needs. ALL CAPS is industry standard for construction documents and has been forever. Needs to be implemented ASAP!

@ericjhberg Really. Just because that's the way it has been doesn't mean that it should always be! ;-)!

Share this post


Link to post

Fair enough. I don't disagree. However, you fail to convince me that it, at the very least, shouldn't be an option. 

  • Laugh 1

Share this post


Link to post
Posted (edited)
23 hours ago, John Meunier said:

Is there the ability to make a VW 2019 file ALL CAPS? Including databases and text styles.

So far my workaround has been to manually type in CAPS, but the database header has got me stumped.

 

I must be missing something. Any help is appreciated.

Thank you

Database CAPS.png

 

There is no native way to do it. But you could with a script.

 

1. Create a script in your file name it 'WS_ALL_CAPS' . (When it asks you to create a palette, just name the palette whatever you want, something like 'WS Scripts' will suffice.

2. When the script dialog box pops up, change the language to Python.

3. Use the code below in your script:

orignal_str = vs.WSScript_GetPrmStr(0)
vs.WSScript_SetResStr(orignal_str.upper())

image.thumb.png.e80db4a592ff93297c36df339f3e814e.png

 

 

4. Now back in your worksheet, select the cell you want capitalized. Enter this into the formula bar:

=RUNSCRIPT('WS_ALL_CAPS', 'Existing Tree'.'ActionComment')

5. Recalculate Active Worksheet

 

 

 

Edited by twk
  • Like 1

Share this post


Link to post

@twkVery interesting solution.

Thank-you for taking the time to respond with such depth and detail.

 

Unfortunately I am unable to get it to work. I have attached a file, perhaps I missed something?

ALLCAPSPython.vwx

Share this post


Link to post

Hi @John Meunier,

 

Looks like a glitch in the matrix..

 

- Any other formula added to that glitching cell doesn't work.

- If I copy the formula out, then replace it with the cell's formula next to it. The worksheet starts to function again.

- Now I can copy back in the first formula I had (or you wrote), and it recalculates fine.

 

  • Like 1

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×