Hi All,
Cognos Express 9.0
Mozilla Firefox 3.6.9
Is there any way you can align the values, to the left or right, in the cells when using a view in Web. We have a problem that if you have a string measure with a long typed value in, it alway aligns to the right of the cell.
Is there a way to change that alignment?
Thank you.
Alignment of Values in Tm1Web
-
- Posts: 32
- Joined: Wed May 28, 2008 11:41 am
- OLAP Product: TM1
- Version: 6 and 2.5 to 10.2.2
- Excel Version: 2007 2010
- Location: Northern England
- Contact:
Re: Alignment of Values in Tm1Web
Hi,
The alignment used by Web is determined by the alignment set in Excel (either from the Home Ribbon or formatting toolbar or cell Properties), it is possible to align both text and numeric value left, right or centre and also top bottom too.
However, there is a known issue with column widths and the web. If the values in the column exceed the width they have on the web then this throws out any alignment that you have set. Althogh there is a hotfix for this (see notes on versions and patches above). Also be aware that the web will display column widths slightly differently to Excel.
Good Luck
Neil
The alignment used by Web is determined by the alignment set in Excel (either from the Home Ribbon or formatting toolbar or cell Properties), it is possible to align both text and numeric value left, right or centre and also top bottom too.
However, there is a known issue with column widths and the web. If the values in the column exceed the width they have on the web then this throws out any alignment that you have set. Althogh there is a hotfix for this (see notes on versions and patches above). Also be aware that the web will display column widths slightly differently to Excel.
Good Luck
Neil
Re: Alignment of Values in Tm1Web
Thank you Niel,
The problem however is not with Excel Reports but rather with Cube Views. Any idea on how to change those?
The problem however is not with Excel Reports but rather with Cube Views. Any idea on how to change those?
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Alignment of Values in Tm1Web
The only formatting you can do with Views is to change the numeric display.par3 wrote:Thank you Niel,
The problem however is not with Excel Reports but rather with Cube Views. Any idea on how to change those?