Versions Compared

Old Version 37

changes.mady.by.user Chris Angel

Saved on

compared with

New Version 38

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 Refer to plugins and APIs from https://handsontable.com/docs/6.2.2/tutorial-introduction.html for more customizations.

Example:

Code Block
languagetext
{
	selectionMode: 'single'
}

 

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

...