Writeback Formatting, Cell Locking and Data Validation

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.