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

Limitations

Below is a list of limitations for supported formulas:

  • Zero sums are left unchanged.

  • Locked cells - only the cells that are referenced by the cell that the user edits will be evaluated and kept unchanged. If a locked SUM cell is not referenced back to the sum cell that is modified, then the value will be changed even though it is locked.

  • Dividing by zero will return an error when re-allocating a sum value.

  • The use of SPVAL and SPKEY will override any locked cell value. In other words, if a cell is locked in one row and the user changes the spread value and selects a spread key for that row, then Bizview will allocate new values to all cells in the row based on the spread key, even though some might be locked. If the lock cell functionality is to be used, then it might be better to use a SUM column (and tag that as EDITSUM), instead of SPVAL/SPKEY to summarize CVAL cells. By using a SUM column, locking cells will work when changing the SUM value.

  • A locked SPKEY cell will not be formatted according to the LOCKCELLS parameter (read more about that below). The SPKEY cell contains a drop-down and is therefore not possible to format.
Published:

Limitations

Below is a list of limitations for supported formulas:

  • Zero sums are left unchanged.

  • Locked cells - only the cells that are referenced by the cell that the user edits will be evaluated and kept unchanged. If a locked SUM cell is not referenced back to the sum cell that is modified, then the value will be changed even though it is locked.

  • Dividing by zero will return an error when re-allocating a sum value.

  • The use of SPVAL and SPKEY will override any locked cell value. In other words, if a cell is locked in one row and the user changes the spread value and selects a spread key for that row, then Bizview will allocate new values to all cells in the row based on the spread key, even though some might be locked. If the lock cell functionality is to be used, then it might be better to use a SUM column (and tag that as EDITSUM), instead of SPVAL/SPKEY to summarize CVAL cells. By using a SUM column, locking cells will work when changing the SUM value.

  • A locked SPKEY cell will not be formatted according to the LOCKCELLS parameter (read more about that below). The SPKEY cell contains a drop-down and is therefore not possible to format.
For an optimal Community experience, Please view on Desktop
Powered by Zendesk