Definition
Spreadsheet Form Element allow users to perform many actions in an excel-like environment, depending on the use cases. A few examples of uses of spreadsheets are:
- Database editing
- Configuration controlling
- Data merging
- Workforce planning
- Sales reporting
- Financial analysis
Figure 1 : Sample Spreadsheet Form Element in the userview
Figure 2 : Spreadsheet Form Element Properties
| Name | Description |
|---|---|
| Spreadsheet | |
| Label | |
| Columns |
Figure 3 : Spreadsheet Form Element Properties - UI
| Name | Description |
|---|---|
| Enable Header Sorting? | |
| Data Order Field ID | |
| Readonly | |
| Disable Add Feature | |
| Disable Delete Feature | |
| Show Row Numbering? | |
| Number of columns to fixed on left | |
| Number of spare rows | |
| Custom Settings (JSON) |
Figure 4 : Spreadsheet Form Element Properties - Validation & Data Binder
| Name | Description |
|---|---|
| Validator | |
| Min Number of Row Validation (Integer) | |
| Max Number of Row Validation (Integer) | |
| Error Message | |
| Load Binder | |
| Store Binder |