PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
The Property Value Entry allows you to:
  • find out whether the end user can enter or modify values in a Spreadsheet control.
  • allow or not the end user to enter or modify 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.
Example
IF CBOX_ReadOnly THEN
TBLR_Value Entry Table = True
ELSE
TBLR_Value Entry Table = False
END
Syntax

Finding out whether the user can modify 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 Spreadsheet control to use.

Allowing the user to modify or add values Hide the details

<Spreadsheet control>.InputValue = <Authorization>
<Spreadsheet control>: Control name
Name of Spreadsheet control to use.
<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 Property InputFormula is False and Property InputValue is True, the end user will be able to enter and modify the values in the Spreadsheet control.
Related Examples:
The Spreadsheet control 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,
- ...
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment