Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Lock Cells

If the end-user has the ability to lock cells within the allocation range, these need to be stated within a specific named range. All cells within named ranges starting with _ALLOC_ have the option to lock.

SumAlloc_Lock_Cells

Note: If cells within EXPAND rows should be able to lock, then the row above the EXPAND row in the template needs to be included in the _ALLOC_ named ranges. Otherwise, the range will not work when Bizview expands rows in the opened form.

After opening a form, end-users can lock a cell by right-clicking on the cell and selecting Lock:

SumAlloc_Lock_Cells_Lock

To depict that the cell is locked, the template designer can define another background and/or font color for a locked cell.

In the template, add a new parameter in the PARAM sheet - LOCKCELLS. In column C, define the background color for the locked cell.

It is also possible to define a font color in this cell.

Note: Only background and font color can be stated in this parameter; not bold, italic, font size, and so on.

SumAlloc_Lock_Cells_Param

In the opened form, the cells that the user locked will change format, according to the LOCKCELLS parameter:

SumAlloc_Lock_Cells_Lock_2

Note: If a user locks an EDITSUM cell, not an actual input cell, then all referenced cells will be locked. Otherwise, you can lock a sum cell, however, you can still change the actual values adding up to that sum.

SumAlloc_Lock_Cells_Lock_3

Published:

Lock Cells

If the end-user has the ability to lock cells within the allocation range, these need to be stated within a specific named range. All cells within named ranges starting with _ALLOC_ have the option to lock.

SumAlloc_Lock_Cells

Note: If cells within EXPAND rows should be able to lock, then the row above the EXPAND row in the template needs to be included in the _ALLOC_ named ranges. Otherwise, the range will not work when Bizview expands rows in the opened form.

After opening a form, end-users can lock a cell by right-clicking on the cell and selecting Lock:

SumAlloc_Lock_Cells_Lock

To depict that the cell is locked, the template designer can define another background and/or font color for a locked cell.

In the template, add a new parameter in the PARAM sheet - LOCKCELLS. In column C, define the background color for the locked cell.

It is also possible to define a font color in this cell.

Note: Only background and font color can be stated in this parameter; not bold, italic, font size, and so on.

SumAlloc_Lock_Cells_Param

In the opened form, the cells that the user locked will change format, according to the LOCKCELLS parameter:

SumAlloc_Lock_Cells_Lock_2

Note: If a user locks an EDITSUM cell, not an actual input cell, then all referenced cells will be locked. Otherwise, you can lock a sum cell, however, you can still change the actual values adding up to that sum.

SumAlloc_Lock_Cells_Lock_3

For an optimal Community experience, Please view on Desktop
Powered by Zendesk