Loading...
 
Skip to main content

Inputs

Spreadsheets help Inputs from jquery.sheet interface
Add row after selection or to the end if no selectionAdd row before selection or to end if no selectionAdd multiple rows after selection or to the end if no selectionDelete selected rowAdd column after selection or to the end if no selectionAdd column before selection or to the end if no selectionAdd multiple columns after selection or to the end if no selectionDelete selected columnGet Cell Range
ABCDEFGH
1Inputs are for capturing fixed data, such as a drop down list (INPUT.SELECT), or a checkbox (INPUT.CHECKBOX)
2Input Type Example Data Number Data String
3Select List "=INPUT.SELECT(D3:D10)" 34 Lorem
4Radio List "=INPUT.RADIO(E3:E10)" Lorem
Proin
Aliquam
Quisque
Aliquam
Vivamus
Etiam
Donec
-20 Proin
5Checkbox "=INPUT.CHECKBOX(E3)" Lorem 123 Aliquam
6Get Select List Value "=INPUT.SELECTVAL(C3)" 4 123 Quisque
7Get Radio List Value "=INPUT.RADIOVAL(C4)" Donec 4 Aliquam
8Get Checkbox Value "=INPUT.CHECKBOXVAL(C5)" Lorem 534456 Vivamus
9Detect if Checkbox is Checked "=INPUT.ISCHECKED(C5)" FALSE 3 Etiam
10 1 Donec
Inputs