Hi All
I'm constructing an forecasting application in TM1 10.1
However I've stumbled upon an formatting issue.
Every cell which retrieves its value through a rulestatement, that cell gets a grey background color instead of the expected formatting style as defined in the formatting area of the active form. As far as I can see it's only the background color which is incorrect. The font type, size, border, ... are all correct.
This issue pops up only when the websheet is part of an Application created with Performance Modeler.
In Perspectives and TM1Web the active form for those cells show the correct style.
(I've uploaded a screenshot to show the differences between perspectives and application view.)
My question is, is there a way to avoid this grey background? some property or setting? Or is this normal behavior?
Application - Websheet formatting issue
-
- Posts: 15
- Joined: Tue Mar 02, 2010 9:21 am
- OLAP Product: TM1
- Version: Since 9.5
- Excel Version: All
Application - Websheet formatting issue
- Attachments
-
- Formatting Issue.png (40.51 KiB) Viewed 2757 times
-
- 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: Application - Websheet formatting issue
I haven't used PM much but that is standard behavior in cube views and contributor views. This is because a rule-based cell will not accept input, thus it is greyed out for users.
-
- Posts: 15
- Joined: Tue Mar 02, 2010 9:21 am
- OLAP Product: TM1
- Version: Since 9.5
- Excel Version: All
Re: Application - Websheet formatting issue
That is what I feared, I was hoping there was some workaround to disable this behavior and show the excel formatting instead for rule-based cells.tomok wrote:I haven't used PM much but that is standard behavior in cube views and contributor views. This is because a rule-based cell will not accept input, thus it is greyed out for users.
Thanks