PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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
..PrintedSheet is used find out and modify the sheet to print for a Spreadsheet control found in a report.
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> = <Control Name>..PrintedSheet
<Result>: Integer or character string
  • Number of the sheet to print.
  • Name of the sheet to print.
<Control Name>: Character string (with or without quotes)
Name of the Spreadsheet control to use in the report.

Modifying the sheet to print Hide the details

<Control Name>..PrintedSheet = <Sheet to Print>
<Control Name>: Character string (with or without quotes)
Name of the Spreadsheet control to use in the report.
<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.
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment