TM1 Active Form row drill event ?

[boriscb]

Hello,

I have an active form where one of the columns is a comment. I need to ensure that the cell wraps to show the entire comment. When the comment is at a level that needs to be reached through drilling, the excel auto-wrap does not get activated. Is there a way I can trap the TM1 "drill" event and force the auto-wrap in VBS maybe ?...

Thank you for your suggestions.

Boris.

[rmackenzie]

I need to ensure that the cell wraps to show the entire comment.

In the hidden range (TM1RPTFMTRNG) at the top of the active format, you need to set the cells to wrap in that range.

When the comment is at a level that needs to be reached through drilling, the excel auto-wrap does not get activated.

This doesn't happen for me, my drilled down cells still wrap nicely. You need to check the type of the row and see if the corresponding row in TM1RPTFMTRNG has the wrap property set for that particular row-type. Check the formulas hidden in column A that use TM1RPTELISCONSOLIDATED etc to find out the row-type. The default active form set-up has 0, 1, 2, 3, D and N. Maybe your 'N' row doesn't have wrap on?

Is there a way I can trap the TM1 "drill" event and force the auto-wrap in VBS maybe ?...

AFAIK there's no custom event for this, or any TM1 custom events at all. If you've some experience with VBA, then perhaps you could try trapping Worksheet_BeforeDoubleClick and investigating the formula of the cell clicked on. However, I'd investigate the format set-up first as it sounds like the likely source of the issue.