|
|
|
|
|
|
|
|
|
|
FormulaBarVisible (Property) In french: BarreDeFormuleVisible
The FormulaBarVisible property is used to: - Find out whether a formula bar is displayed in a Spreadsheet control.
- Display (or not) a formula bar in a Spreadsheet control.
Reminder: - In a Spreadsheet control, the formula bar is used to type formulas and names.
- This property corresponds to the "With formula input bar" option in the "Details" tab of the Spreadsheet control description window.
IF CBOX_FormulaBar THEN
PSHEET_Spreadsheet.FormulaBarVisible = True
ELSE
PSHEET_Spreadsheet.FormulaBarVisible = False
END
Syntax
Find out whether a formula bar is displayed in a Spreadsheet control Hide the details
<Result> = <Spreadsheet control>.FormulaBarVisible
<Result>: Boolean - True if the formula bar is visible,
- False otherwise.
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used.
Display (or not) a formula bar in a Spreadsheet control Hide the details
<Spreadsheet control>.FormulaBarVisible = <Display>
<Spreadsheet control>: Control name Name of the Spreadsheet control to be used. <Display>: Boolean - True to make the formula bar visible,
- False to make the formula bar invisible.
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, - ...
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|