Page 1 of 1
Hidden Excel Values in TM1Web
Posted: Tue Oct 15, 2013 2:01 pm
by 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.
Re: Hidden Excel Values in TM1Web
Posted: Tue Oct 15, 2013 2:06 pm
by 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.
Re: Hidden Excel Values in TM1Web
Posted: Tue Oct 15, 2013 2:34 pm
by erik664
Thanks, I just wanted to post here to make sure there was nothing else I could do to make it work.
Re: Hidden Excel Values in TM1Web
Posted: Tue Oct 15, 2013 4:08 pm
by qml
How about hiding a whole column/row? That works as expected in TM1 Web.
Re: Hidden Excel Values in TM1Web
Posted: Tue Oct 15, 2013 6:33 pm
by erik664
Hiding the entire column works! Thank you