ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
The InputFormula property is used to:
  • find out whether the end user can enter or change formulas in a Spreadsheet control.
  • allow or prevent the end user from entering or changing formulas in a Spreadsheet control.
This property prevents the end user from executing code..
Remark: This property corresponds to the "Allow the input of formulas" option in the "Details" tab of the Spreadsheet control description window.
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>: Control name
Name of the Spreadsheet control to be used.

Allowing the user to modify or add formulas Hide the details

<Spreadsheet control>.InputFormula = <Authorization>
<Spreadsheet control>: Control name
Name of the Spreadsheet control to be used.
<Authorization>: Boolean
  • True to allow the user to change/add formulas or load an XLSX file.
  • False to prevent the user from changing/adding formulas or loading an XLSX file.
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:
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

Last update: 06/22/2023

Send a report | Local help