|
|
|
|
|
|
|
|
InputValue (Property) In french: SaisieValeur
The InputValue property is used to: - find out whether the end user can enter or change values in a Spreadsheet control.
- allow or prevent the end user from entering or changing values in a Spreadsheet control.
Remark: This property corresponds to the "Allow the input of values" option in the "Details" tab of the Spreadsheet control description window. IF CBOX_ReadOnly THEN
PSHEET_Spreadsheet.InputValue = True
ELSE
PSHEET_Spreadsheet.InputValue = False
END
Syntax
Finding out whether the user can change or add values Hide the details
<Result> = <Spreadsheet control>.InputValue
<Result>: Boolean - True if the user can:
- add, modify values and load an XLXS file,
- insert or delete columns or rows.
- False if the user cannot:
- add, modify values and load an XLXS file.
- insert or delete columns or rows.
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used.
Allowing the user to modify or add values Hide the details
<Spreadsheet control>.InputValue = <Authorization>
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Authorization>: Boolean - True to allow the user to:
- add, modify values and load an XLXS file.
- insert or delete columns or rows.
- False if you don't want the user to:
- add, modify values and load an XLXS file.
- insert or delete columns or rows.
Remarks If the InputFormula property is set to False and the InputValue property is set to True, the end user will be able to enter and change values in the Spreadsheet control.
Related Examples:
|
Unit examples (WINDEV): The Spreadsheet control
[ + ] Using the Spreadsheet control. This example explains how to: - load an xlsx file in a spreadsheet control, - save the spreadsheet in a file, - fill the control with data coming from the database, - insert rows, columns, - access the cells and handle them (modify their value, their style, ...), - enter formulas, - ...
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|