Retaining TM1 cell formats while slicing data to excel

[suhamore]

Is it possible to retain TM1 cell formats while creating a slice/active form from TM1 cube viewer?...So, if some value is displayed as % in cube viewer, it should be displayed as % only when we slice that view into excel? currently, it is displayed in decimal format. TM1 version is 9..4.1 FP3

[ajain86]

have you tried starting with in-spreadsheet browser instead of cube viewer.
I believe that retains formats when it is sliced.

[suhamore]

have you tried starting with in-spreadsheet browser instead of cube viewer.
I believe that retains formats when it is sliced.

Thanks Ankur. Yes, in-spreadsheet browser will retain the formats.
But I am looking for options, if any, to retain the formats after we create slice or active form in excel from cube viewer. It would be very difficult to ask our business users to switch to in-spreadsheet browser from cube viewer.

[Martin Ryan]

An active form should retain the formatting. Mine does anyway - 9.5.1.

Martin

[suhamore]

More tests and this is what I have found.
If you have the formatting applied to an element that is in the columns of the cube view it will slice/carry over to excel. If you have formatting applied to elements in a row or title it will not carry over. (9.4.1 FP3)