Filling Empty and Zero Cells

NOTE. Replacement of zero and empty cells depends on access permissions to data contained in cells. Access permissions are determined using the TabAccessRights enumeration. Full access to data is used by default. If the ITabCellStyle.AccessRights property is set to TabAccessRights.NoAccess or TabAccessRights.Write, filling of empty and zero cells will be unavailable.

Select table, dimension, level, or totals element in the table.
Go to the Table group of tabs on the side panel and select the Formatting or Data Formatting tab.

NOTE. If a table element is selected, the group of tabs on the Table side panel is renamed according to the selected element:
    • Title. When sidehead or heading is selected.
    • Corner. When corner is selected.
    • Table. When data cell or whole table is selected.
    • Data. When all data cells are selected.
    • Format. When whole column or row is selected.
    • Level. When dimension level element names are selected.
    • Dimension. When dimension element names are selected.
    • Totals. When totals cells, columns or rows are selected.

NOTE. The checkbox is not available if sidehead or heading are selected in the table.

Values used to fill empty cells, as well as, number values, are not saved in the source. Empty cells are not considered on executing data analysis or calculating totals. Values of zero cells with replaced contents are considered as 0: