Hidden Excel Values in TM1Web

[erik664]

I've created some input sheets that have columns with values that are hidden from view in Excel. They are formatted with the custom type ';;;'. However, when I publish the file to TM1 Web and open it up I can see these hidden values. Is there something I'm missing? I'm not that experienced with TM1Web and maybe someone can tell me if I'm doing something wrong, or maybe it's just not possible? The file works perfectly fine otherwise in Excel.

By the way I'm using TM1 v10.1.1.

[Wim Gielis]

Hi

Never used that before with TM1Web, only in Excel, but you must know that not all Excel functionality can be leveraged from TM1 Web.
Meaning that not every Excel file will look exactly the same with the same functionality in TM1Web.

[erik664]

Thanks, I just wanted to post here to make sure there was nothing else I could do to make it work.

[qml]

How about hiding a whole column/row? That works as expected in TM1 Web.

[erik664]

Hiding the entire column works! Thank you