PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
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
The Property PrintedSheet allows to know and modify the sheet to be printed in an Spreadsheet control present in an report.
Example
// Prints the sheet #3
TBLR_FieldSheetPrinted Sheet = 3
// Prints the "Yearly sales" sheet
TBLR_FieldSheetPrinted Sheet = "Sales of the Year"
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.
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment