websheet function equivalent to cellisupdatable

Post Reply
mnasra
Posts: 93
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

websheet function equivalent to cellisupdatable

Post by mnasra » Thu Aug 08, 2019 5:13 pm

Hi Expert,

I need to color differently the cells in a websheet depending if the cell is updatable or not.
I wish I can write a websheet command to find the STATUS of the cell (same logic as write clicking on it- Edit Status, which gives me cell is editable or not).

Thank you
micheline
Thanks
Micheline

User avatar
jim wood
Site Admin
Posts: 3749
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: websheet function equivalent to cellisupdatable

Post by jim wood » Thu Aug 08, 2019 6:18 pm

If it's done by rule then your stuffed, unless it is controlled by some kind of flag. If it's security based you can always pull in the control cube values and format the cells based on those values and then hides those rows / sheets,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

mnasra
Posts: 93
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: websheet function equivalent to cellisupdatable

Post by mnasra » Thu Aug 08, 2019 6:23 pm

Thanks Jim.
Yes, some fields are by rules, some are by security in the control cube, and
Some are by security at the dimension level (like Actuals are read only)

I tried to put a flag, but I have many user types. way too many flags!
Thanks for trying. I hoped the problem was already solved!
Thanks
Micheline

Post Reply