I have several column names in a view that can be as long as 57 characters. However, it is a numeric element with a format mask of b:0.000;(0.000) F|3|Y with an input value restricted to < 1 and > 0. Currently the column header takes a single line. This causes each column to display very wide for such a small number, thus causing a lot of horizontal scrolling.
Is there a way to force the column header to wrap at a certain number of characters?
TM1 Contributor View Column Header Width
-
- Posts: 25
- Joined: Sat Nov 07, 2009 5:37 am
- OLAP Product: TM1, CX
- Version: 9.5.2
- Excel Version: 2007
Re: TM1 Contributor View Column Header Width
There is if you're on 9.5.2...add or modify this line in your Web.Config file:
<add key="CubeviewerStringWrap" value="Enabled=true;MinCharactersToWrap=20;MaxDisplayCharacters=200;WidthOfWrapCell=50" />
<add key="CubeviewerStringWrap" value="Enabled=true;MinCharactersToWrap=20;MaxDisplayCharacters=200;WidthOfWrapCell=50" />
- cdredmond
- Posts: 23
- Joined: Tue Sep 08, 2009 2:46 pm
- OLAP Product: TM1
- Version: SpreadsheetConnector4.0-10.2.2
- Excel Version: v3 - 2013
- Location: Tigard, OR (Portland, Oregon Metro area)
- Contact:
Re: TM1 Contributor View Column Header Width
Yes, I am using 9.5.2. I too saw this parameter. At your suggestion, I have since played with this and discovered that it only applies to string elements, not numeric.standtrue wrote:There is if you're on 9.5.2...add or modify this line in your Web.Config file:
<add key="CubeviewerStringWrap" value="Enabled=true;MinCharactersToWrap=20;MaxDisplayCharacters=200;WidthOfWrapCell=50" />
The other behavior to note is that this parameter applies to all strings cells. I have not found a way to apply this type of formatting rule to an individual cell/column.
Thank you for your suggestion and keep them comming!
Christopher Redmond
Senior TM1 Consultant
BPM Northwest