Versions Compared

Old Version 35

changes.mady.by.user Chris Angel

Saved on

compared with

New Version 36

changes.mady.by.user Chris Angel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

NameDescription
Enable Header Sorting?Determines if users can sort spreadsheet data by column in ascending or descending order.
Data Order Field IDField to keep the ordering sequence. Must correspond with a field id in the target form.
ReadonlyDefines if the entire spreadsheet is editable.
Disable Add FeatureDetermines if a new row can be added.
Disable Delete FeatureDetermines if a row can be removed.
Show Row Numbering?

Show additional column on the leftmost to denote numbering.

Info
titleSample

Row numbering checked.

Number of columns to fixed on left

Allows to specify the number of fixed (or frozen) columns on the left of the table.

Default Value: 0

Number of spare rows

Number of spare row to be added automatically after lines with values.

Info
titleSample

1 spare row

 

 

Custom Settings (JSON)

Example:

Code Block
languagetext
{
	selectionMode: 'single',
	customBorders: [
      {
        range: {
          from: {
            row: 0,
            col: 0
          },
          to: {
            row: 1,
            col: 4
          }
        },
        top: {
          width: 2,
          color: 'green'
        },
        left: {
          width: 2,
          color: 'orange'
        },
        bottom: {
          width: 2,
          color: 'red'
        },
        right: {
          width: 2,
          color: 'magenta'
        }
      }]
}

Refer to https://handsontable.com/docs/6.2.2/tutorial-introduction.html for more customizations.

 

Figure 4 : Spreadsheet Form Element Properties - Validation & Data Binder

...