PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

X
Y
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
..InputFormula is used to:
  • find out whether the end user can enter or modify formulas in a Spreadsheet control.
  • allow (or not) the end user to enter or modify formulas in a Spreadsheet control.
This property allows you to avoid giving the end user the ability to run code.
Note: This property corresponds to the "Allow the input of formulas" option found in the "Details" tab of the description window of Spreadsheet control.
Example
IF CBOX_ReadOnly THEN
PSHEET_Spreadsheet..InputFormula = True
ELSE
PSHEET_Spreadsheet..InputFormula = False
END
Syntax

Finding out whether the user can modify or add formulas Hide the details

<Result> = <Spreadsheet Control>..InputFormula
<Result>: Boolean
  • True if the user can modify/add formulas or load an XLSX file,
  • False if the user cannot modify/add formulas or load an XLSX file.
<Spreadsheet Control>: Character string (with or without quotes)
Name of Spreadsheet control to use.

Allowing the user to modify or add formulas Hide the details

<Spreadsheet Control>..InputFormula = <Authorization>
<Spreadsheet Control>: Character string (with or without quotes)
Name of Spreadsheet control to use.
<Authorization>: Boolean
  • True in order for the user to be able to modify/add formulas or load an XLSX file.
  • False in order for the user not to be able to modify/add formulas or load an XLSX file.
Remarks
If ..InputFormula is set to False and if ..InputValue is set to 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 required version
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment