Formatting of dynamic slices / active forms in TM1 Web or PAW versus Excel
Posted: Thu Mar 31, 2022 8:28 am
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,
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,