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
..ToolbarVisible is used to :
  • in a Spreadsheet control:
    • Find out whether the toolbar is displayed.
    • Display (or not) the toolbar.
  • Versions 22 and later
    in a Word Processing control:
    • Find out whether the ribbon is displayed.
    • Display (or not) a ribbon.
    New in version 22
    in a Word Processing control:
    • Find out whether the ribbon is displayed.
    • Display (or not) a ribbon.
    in a Word Processing control:
    • Find out whether the ribbon is displayed.
    • Display (or not) a ribbon.
Toolbar in the Spreadsheet control
Toolbar in the Spreadsheet control
Reminders:
  • In a Spreadsheet control, the toolbar is used to format the cells: font size, bold, italic, underlined, colors, borders, merge, mask, alignments, ...
  • This property corresponds to the option:
    • "With toolbar" found in the "Details" tab of the description window of Spreadsheet control.
    • Versions 22 and later
      "With ribbon" found in the "General" tab of the description window of Word Processing control.
      New in version 22
      "With ribbon" found in the "General" tab of the description window of Word Processing control.
      "With ribbon" found in the "General" tab of the description window of Word Processing control.
..ToolbarVisible is used to :
  • in a Spreadsheet control:
    • Find out whether the toolbar or the ribbon is displayed.
    • Display (or not) the toolbar or the ribbon.
  • in a Word Processing, Image Editor or PDF Reader control:
    • Find out whether the ribbon is displayed.
    • Display (or not) a ribbon.
Reminder: This property corresponds to the option:
  • "Toolbar" found in the "Details" tab of the description window of Spreadsheet control. You have the ability to display a toolbar or a ribbon. This property is used to display or hide the element chosen in the description window. If the "No bar" option is selected, ..ToolbarVisible will be used to display or hide the toolbar.
  • "With ribbon" found in the "General" tab of the description window of Word Processing, Image Editor or PDF Reader controls.
Example
IF CBOX_Toolbar THEN
PSHEET_Spreadsheet..ToolbarVisible = True
ELSE
PSHEET_Spreadsheet..ToolbarVisible = False
END
Syntax

Finding out whether a toolbar (or the ribbon) is displayed in the control Hide the details

<Result> = <Control Name>..ToolbarVisible
<Result>: Boolean
  • True if the toolbar (or the ribbon) is visible,
  • False otherwise.
<Control Name>: Character string (with or without quotes)
Name of control to use:
  • Spreadsheet control.
  • Versions 22 and later
    Word Processing control.
    New in version 22
    Word Processing control.
    Word Processing control.
  • Versions 23 and later
    Image Editor control.
    New in version 23
    Image Editor control.
    Image Editor control.
  • Versions 23 and later
    PDF Reader control.
    New in version 23
    PDF Reader control.
    PDF Reader control.

Displaying (or not) a toolbar (or a ribbon) in a control Hide the details

<Spreadsheet control>..ToolbarVisible = <Display>
<Spreadsheet control>: Character string (with or without quotes)
Name of control to use:
  • Spreadsheet control.
  • Versions 22 and later
    Word Processing control.
    New in version 22
    Word Processing control.
    Word Processing control.
  • Versions 23 and later
    Image Editor control.
    New in version 23
    Image Editor control.
    Image Editor control.
  • Versions 23 and later
    PDF Reader control.
    New in version 23
    PDF Reader control.
    PDF Reader control.
<Display>: Boolean
  • True to make the toolbar (or the ribbon) visible,
  • False otherwise.
Remarks
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