10.2.2 Active Form websheet - conditional formatting

Post Reply
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

10.2.2 Active Form websheet - conditional formatting

Post by mvaspal »

Hi
Can anyone please confirm that conditional formatting should work correctly in an active form-based websheet in 10.2.2?

I have implemented a simple "if cell value = 0 then red background" rule to one of the columns but all cells in the column display now with red independently from the value.

It works fine in Perspectives and it works fine with a slice on the web.

Thanks
Matyas
pandinus
Posts: 78
Joined: Tue Mar 18, 2014 8:02 am
OLAP Product: TM1, Cognos Express
Version: 10.2.2
Excel Version: 2013

Re: 10.2.2 Active Form websheet - conditional formatting

Post by pandinus »

I have ran into some crazy conditional-formatting issues on TM1Web 10.2.2 as well. Nothing we tried has solved or even minimized the issues.

Now we're just learning to live with it, at least until IBM releases a new FP, which should be out somewhere between now and next year:
http://www-01.ibm.com/software/analytic ... packs.html
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: 10.2.2 Active Form websheet - conditional formatting

Post by mvaspal »

I tried it the way around: the basic default formatting is with red background, and the condition is that if it is <>0 then black font and white background; it works...right now no idea why
Post Reply