When a grid has writeback enabled, you can format the sheet
You can highlight writeable data cells by:
- Select the Highlight Data checkbox in the Grid Properties window.
- Define a format for the changed cells, Written Cell, impacted ones, and Summary written cell, on the XLCubedFormat sheet.
You can also show the user what happened during the data entry process by showing the cells that were changed and the ones that were affected.
- Select Show Updates under refresh type after writeback.
- Define a format for the changed cells, Written Cell, and the impacted ones, Summary written cell on the XLCubedFormat sheet.
