TM1 Forum

hi Everyone,

Does anyone know if the web sheet can be made to select only unprotected cells, like you can in excel?



Thanks

Hi,

What do you mean by select? Do you mean that users can only input into designated cells?

If the user ends up changing other parts of the Web sheet it doesn't really matter as they won't be recorded, and each time it is opened it will be as you originally uploaded it.

You can use validations for the data input if you want to be strict on what goes in.

If you are concerned about users slicing the Web sheet to Excel and opening it up there, then security should prevent them seeing anything they shouldn't.

trying to fix the cell pointer to move only within unprotected cells (ie: coloured blocks in yellow, not white or purple)

Hi,

I don't think what you are trying to achieve is possible.

To limit the Web page as much as possible, experiment with different text sizes and resolutions to find one which makes the best use of space. Also, delete columns and rows in the workbook that aren't required to prevent Web trying to render them. I think using Print Areas might help but am not 100% sure on that one.

I see, maybe I'll try a custom page - the activecell moving to titles and heading doesn't look very good.
Having a look at .net api at the moment - so far, been able to make a connection and thats about it ..