#SAVEZERO
Feature available from Bizview version - Bizview 5.2
By default, no 0 values are saved in the database when updating values from a form. The only time a 0 is saved in data cells is when the cell either contains a cell comment or a row comment. Otherwise, the 0 is NOT saved.
From Bizview 5.2, there is a possibility to define in form specific cells if 0 and NULL values should be saved in the database. Define cell command #SAVEZERO in those cells in the template where this rule should apply. All cells containing this comment, will return a 0 when generating the template (if no other value exists in the cell).
Note: #SAVEZERO is only valid in data cells that are saved in the database. In other words, cells that have CVAL in row 1 and DATA in column A. It is not possible to add this command to any other cell in the template.
In the template worksheet, insert #SAVEZERO in all data cells for which 0/NULL should be saved in the database when the form is updated.
Either use the ribbon to insert command or manually insert a cell comment and enter #SAVEZERO in the cell.
