Skip to main content
J
JamesKirkby
Newcomer
November 11, 2021
Solved

Hyphen in Excel Report Book Items

  • November 11, 2021
  • 2 replies
  • 0 views

I have a report book I've built that loops thru a dimension and creates a tab for every member in a ud hierarchy. I've set book to label the tabs using the CVUD2 and CVUD2Description.  It works quite well except there are some descriptions that have hyphens in them which don't print out. Is there any way to print the hyphen included in some descriptions?

Best answer by StephD

Hyphens and other "restricted characters" in the tab names in Excel limit some quick view functions - particularly "Create Copy of Selected Quick View".  I'd guess OS is limiting the use of the restricted characters in your tab names.  

2 replies

S
StephDAnswer
Newcomer
November 15, 2021

Hyphens and other "restricted characters" in the tab names in Excel limit some quick view functions - particularly "Create Copy of Selected Quick View".  I'd guess OS is limiting the use of the restricted characters in your tab names.  

    J
    JamesKirkbyAuthor
    Newcomer
    November 15, 2021

    Thanks. I heard the same thing from OneStream. I've submitted an enhancement request as member descriptions do include hyphens sometimes. Would be nice to have this print out on a tab.

      Terms & ConditionsAccessibility statement