TM1 Forum

TM1 perspectives Conditional formatting is lost after saving or uploading into applications.
There are other applications with Conditional formatting that have no issues. I have not created them, by my predecessors did.
After conditionally setting the color, it works fine for the forst time. After I save it locally and refresh, the condition is missing at times and other times, the conditional format is after current result set is displayed. Am I missing any condition?
I tried to upload the spreadsheet server. Same thing formatting is lost. Please let me know your answers.

LR

LutherPaul wrote:TM1 perspectives Conditional formatting is lost after saving or uploading into applications.
There are other applications with Conditional formatting that have no issues. I have not created them, by my predecessors did.
After conditionally setting the color, it works fine for the forst time. After I save it locally and refresh, the condition is missing at times and other times, the conditional format is after current result set is displayed. Am I missing any condition?
I tried to upload the spreadsheet server. Same thing formatting is lost. Please let me know your answers.

Are these standard slice-based workbooks, or Active Forms?

Active Forms.

LutherPaul wrote:Active Forms.

And was the conditional formatting placed within the formatting range (rows 1 - 10ish) or was it in the actual data rows?
When the active form is rebuilt, any formatting placed in the data rows will be overwritten with what is in the formatting range.

It is also worth noting that if you view the sheets through TM1 Web there is a limit of 3 conditions for conditional formatting per cell, so if you have (in order):
1/ If Cell = 1 then Green
2/ If Cell = 2 then Blue
3/ If Cell = 3 then Red
4/ If Cell = 4 then Purple

and the cell in question did equal 4, the conditional formatting would be ignored and it would just take the generic cell format - if however it equaled 1, 2 or 3 then it would adopt the conditional format.

The 3 max could perhaps just be when you are saving the workbooks as 2003 format though (which I do for a number of other TM1 Web oddity reasons.)

Thanks for the reply Declan.

I am trying to apply formatting to the data region. Ho do we set "formatting range" to be dynamic? formatting works first time when rule is set, after reloading, the formatting is lost.

Thanks,
LP.

LutherPaul wrote:Thanks for the reply Declan.

I am trying to apply formatting to the data region. Ho do we set "formatting range" to be dynamic? formatting works first time when rule is set, after reloading, the formatting is lost.

Thanks,
LP.

Read the TM1 User Guide, Chapter 8 - Active Forms.

Chapter 8 worked. Thank you.