Formatting of dynamic slices / active forms in TM1 Web or PAW versus Excel

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Formatting of dynamic slices / active forms in TM1 Web or PAW versus Excel

Post by Steve Rowe »

Hi,
Just hit this issue that had me scratching my head, pretty sure I've had it before so just writing it down here so if I search for it I can find the answer...

If the formating of a Dynamic Report is working correctly in Excel but not in TM1 Web / PAW check the the named range TM1RPTFMTRNG"Numbers"

Excel does not seem to care about this range being correct and will just copy the formats on the row down as required.

TM1Web requires the range to be correct, if it isn't the formats won't render correctly. This seems to impact some types of formats more than others, conditional formatting especially will fail completely.

(Pafe 2.0.69 and PAW and PASS 2.0.74)

Cheers,
Technical Director
www.infocat.co.uk
Post Reply