PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE
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
Within a report, the PrintedSheet property is used to get and change the sheet of a Spreadsheet control to be printed.
Example
// Prints the sheet #3
PSHEET_Spreadsheet.PrintedSheet = 3
// Prints the "Yearly sales" sheet
PSHEET_Spreadsheet.PrintedSheet = "Yearly sales"
Syntax

Finding out the sheet to print Hide the details

<Result> = <Spreadsheet control>.PrintedSheet
<Result>: Integer or character string
  • Number of the sheet to print.
  • Name of the sheet to print.
<Spreadsheet control>: Control name
Name of the Spreadsheet control to use.

Modifying the sheet to print Hide the details

<Spreadsheet control>.PrintedSheet = <Sheet to print>
<Spreadsheet control>: Control name
Name of the Spreadsheet control to use.
<Sheet to print>: Integer or character string
Sheet to print identified:
  • by its number.
  • by its name.
Remarks
  • The current sheet is printed by default.
  • If the specified sheet does not exist, the current sheet is printed.
See also
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment