repeat TM1RPTROW?

[image2x]

In a nested Activeform, is it possible to have a TM1RPTROW value repeated down the column?

Example:

Code: Select all

Value   Sales   Loc001  $45 $50 $55
Value   Sales   Loc002  $50 $55 $60

instead of simply:

Code: Select all

Value   Sales   Loc001  $45 $50 $55
                Loc002  $50 $55 $60

Thanks.

-- John

[lotsaram]

The values are there but hidden. Can't you just change the default conditional formatting?

[image2x]

Actually, it looks like the value is already repeated vertically but the font color is set match the background color so you cannot see it.

It doesn't seem to respect the format area setting for the font - it always changes the font to match the background color to mask the text.

Am I missing a simple flag to set somewhere to stop this behavior?

[lotsaram]

To override this default behaviour all you need to do is create conditional formatting with a rule in the format area.
eg. "=b7=b6"
and set the font colour for this condition to be whatever it is that you want. Then everything should display as you want it to.

[image2x]

Thanks lotsa... I will try this.

[vaneagle]

In conditional formating Excel 02 / XP

the formula would be:

=if(b6=b7,1,0)

1 being the trigger for the conditional format to work.. ie font colour black

I use this approach most of the time now...

I have aslo learnt that active forms don't like auto filters with the data filtered! (took me an 20 minutes to work that one out! I thought my vba was rubbish! )

[image2x]

So I still cannot get the values repeated when viewed as a websheet.

Every couple of days since my last post I've tried a new variation of the formula (b6=b7, if(1=1,1,0), NotBlank, etc) per the conditional format trick. I play around for a while and then give up out of necessity until the next time it would be really useful and then I try again but Lucy keeps yanking the ball away...

The conditional format trick does work when viewed in Excel but yields no results when viewed as a websheet. I'm running Excel 2007 with Excel 2007 server side (with IIS MS TrueType installed as recommended by Cognos for better rendering of websheets). It doesn't matter if I upload as an .xlsx or .xls.

Ideas? Thanks.

-- John

[image2x]

I noticed this in the 9.4 release notes:

TM1 Web
• .xlsx files can be opened in TM1 Web if Excel 2007 is installed on the web server used to
deliver TM1 Web.
• New features introduced in Excel 2007, such as enhanced conditional formatting, are not
supported in TM1 Websheets.

Am I perhaps inadvertantly trying to use "enhanced" conditional formatting?

Can I somehow configure with old-school conditional formatting in 2007?

[Michel Zijlema]

Can I somehow configure with old-school conditional formatting in 2007?

I don't know whether there is a setting for that. But alternatively you could save the sheet as an Excel 2003 file and then re-open and re-save the file as an .xlsx file. This should remove all non-Excel 2003 compatible formatting.

Michel