Highlighted uneditable cells in Excel
Posted: Fri Sep 27, 2013 1:43 pm
Hello,
When a cell is uneditable, e.g. when is consolidated, is highlighted on gray (view of cube in the tm1 perspective, see below)
[img=http://s15.postimg.org/hq49jezk7/tm1_view.jpg]
when I export this view to excel I get this:
[img=http://s14.postimg.org/a3hxmie7h/excel.jpg]
Is it possible to get the same result of highlighting in excel? I'd like to get this result:
[img=http://s23.postimg.org/9s0sio22f/excel_goal.jpg]
The main point is to receive (from a worksheet level) the information if a user have a write access to the cell.
Regards,
Mike
When a cell is uneditable, e.g. when is consolidated, is highlighted on gray (view of cube in the tm1 perspective, see below)
[img=http://s15.postimg.org/hq49jezk7/tm1_view.jpg]
when I export this view to excel I get this:
[img=http://s14.postimg.org/a3hxmie7h/excel.jpg]
Is it possible to get the same result of highlighting in excel? I'd like to get this result:
[img=http://s23.postimg.org/9s0sio22f/excel_goal.jpg]
The main point is to receive (from a worksheet level) the information if a user have a write access to the cell.
Regards,
Mike