You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Definition

This tutorial cater for use cases that requires a highly customized spreadsheet.

The Spreadsheet form element uses the Handsontable library, specifically version 6.2.2 for Joget Workflow V6.

There are a wealth of plugins and APIs in the library documentation to change the cell appearance, cell selection, dynamic data, dynamic validation, and much more.

Figure 1 : Spreadsheet Form Element Properties - UI - Custom Settings

In Figure 1, we can add in more spreadsheet properties available in the library documentation.

The configuration here is formatted as JSON.

Usually for simple configurations, a single object and value in Custom Settings would suffice. But for more complex ones, this configuration can be used in combination with a Custom HTML form element to complete a functionality.

Do scroll down below for a few examples referenced from the documentation.


Example 1 - Limit Cell Selection

 

 

https://handsontable.com/docs/6.2.2/Options.html#selectionMode
Use case: To limit the cell(s) that can be selected.

 

 

 

  • No labels