Table Style Capitalization

Table Style Capitalization

Anthony.Mauric
Enthusiast Enthusiast
2,570 Views
2 Replies
Message 1 of 3

Table Style Capitalization

Anthony.Mauric
Enthusiast
Enthusiast

I'd like to know how I can set up a table style so it sanitizes my reports, like catalog info coming into BOM reports of all lowercase.

 

I tried changing the Table Cell Format to Uppercase for all Cell Styles, but it doesn't seem to affect anything.

0 Likes
2,571 Views
2 Replies
Replies (2)
Message 2 of 3

JeffatPrimex
Collaborator
Collaborator

Not sure if this helps but after the table is inserted it's just a couple clicks to upper case everything just select the table right click select data format pick upper case then okay.

JeffatPrimex_0-1595717666375.png

A user post would be better maybe someone here has one.

 

Best regards,

Jeff

 

0 Likes
Message 3 of 3

Anthony.Mauric
Enthusiast
Enthusiast

Yes, I'm aware you can do it after the fact, but given that these reports can take up dozens of sheets and may be updated several times during work on design, revisions, and updates, it would be very time consuming, especially when multiplied out to an entire organization.

 

I might cross-post on the customization forum to see about a LISP or script to run in post before publishing.

 

I still think a table style would be best if it could actually work, but I'm not thinking it's possible because any imported text seems to overwrite the text style.

 

The best solution might be to work with our IT and see if there's a way to convert our entire SQL server to uppercase and run a daily script to update new entries, or keep new entries uppercase.