Difference between revisions of "Writeback Formatting, Cell Locking and Data Validation"
| Line 24: | Line 24: | ||
[[File:05 WBFformattingLocking.png|800px|center]] | [[File:05 WBFformattingLocking.png|800px|center]] | ||
| + | You can also provide visual feedback for the user during the data entry process by highlighting the cells that were changed and the ones that were impacted: | ||
| + | # Select ‘Show Updates’ under refresh type after writeback | ||
| + | # Define a format for the cells changed by the user (‘Written Cell’) and the impacted ones (‘Summary written cell’) | ||
Revision as of 11:48, 6 February 2023
Once writeback has been enabled for a grid, it is possible to use the Formatting_Grids#Format_sheet as well as additional Custom Format Areas to format and lock the grid cells.
Enabling writeback for a grid
Data entry mode in an XLCubed grid is turned on by ticking the ‘Enable Writeback’ box in the Grid Properties window.
If you’re using FluenceXL, you also need to enable data entry mode at the workbook level from the FluenceXL\Options\Workbook Options menu item.
Please refer to the writeback page for further details.
Basic data entry formatting
Highlighting cells
You can highlight writeable data cells by:
- Ticking ‘Highlight Data’ box in the Grid Properties window
- Defining a format for the ‘Writeable Member’ data cell in the XLCubedFormats sheet
You can also provide visual feedback for the user during the data entry process by highlighting the cells that were changed and the ones that were impacted:
- Select ‘Show Updates’ under refresh type after writeback
- Define a format for the cells changed by the user (‘Written Cell’) and the impacted ones (‘Summary written cell’)
