TM1 Forum

when I format the row (tm1rptrow function) by "cell merging" , cells are not merging in all the rows of active form.. only formulas and colour formating are copied to all cells in TM1web.. anybody knows solution to copy cell merging as well to all cells.. because to present well in TM1web.. Thanks in advance. Have a great day.

Note: in TM1 perspective its working fine. This problem is there only in TM1Web.

Hi , Anybody faced this problem and got any solution to resolve this? Appreciate your help. Thanks in advance.

I'm having trouble imagining why you would need or want to merge cells within the data table range of an active form. Although it works in Excel presumably the developers never considered that supporting merged cells in web active forms was a feature requirement.

Why don't you post a screenshot of the report so that people could suggest some design alternatives?

lotsaram wrote:I'm having trouble imagining why you would need or want to merge cells within the data table range of an active form. Although it works in Excel ...

I think that, even in Excel they are horrible and cause problems when copying inserting etc. I normally come across them in 2 situations
- centering a title across several columns, in which case you can use align across selection instead
- for running multi line text comments across several columns. More difficult to do but maybe Excel text box is the answer.

I really cant see why you would need merged cells in active forms.

lotsaram wrote: maybe Excel text box is the answer

Can you use an Excel text box in the web client

I've done a lot of work with Active Forms over the last several years and I can honestly say it has never crossed my mind to try and merge certain cells inside an active form range. The only reason I can think of that would make you want to do that would be to not show data (by merging columns) whenever a certain criteria was met, like level in the hierarchy, or element attribute, or whatever. Whenever I have come across those situations I just hide the data by making the font color the same as the background so the number is still there, you just don't see it.

AmbPin wrote:

lotsaram wrote: maybe Excel text box is the answer

Can you use an Excel text box in the web client

Twas me who suggested that and yes you can. Never tried it within an active form though, again, I am scratching my head as to why you would want to.

Kumaresan, an you give us some examples of what you are trying to do?

stephen waters wrote:I am scratching my head as to why you would want to.

I've considered merging cells in active forms but abandoned it when I ran into the same issue as the OP. One example: I have a worksheet with five separate active form regions (one active form region each for employees started in the period, committed hires yet to start, open reqs w/o a committed hire, completed terminations in the period, and employees planned to terminate). Each active form region has a bunch of the same columns, but there are some that are only applicable for a few regions, leading to empty columns in some regions. If I could merge columns, I could give the extra space to longer fields (e.g. comment) which coincidentally correspond to the regions with fewer columns.

Matt