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
websheet function equivalent to cellisupdatable
-
- Posts: 136
- Joined: Tue Aug 10, 2010 5:40 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: EXCEL 2013
websheet function equivalent to cellisupdatable
Thanks
Micheline
Micheline
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: websheet function equivalent to cellisupdatable
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.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 136
- 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
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!
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
Micheline