PC SOFT

WINDEV, WEBDEV 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
..PrintArea is used find out and modify the area to print for a Spreadsheet control found in a report.
Example
// Print the cells B2 to F10
PSHEET_Spreadsheet..PrintArea = "B2:F10"
Syntax

Finding out the area to print in a Spreadsheet control Hide the details

<Result> = <Control Name>..PrintArea
<Result>: Character string
Area to print expressed in the following format: <Cell Start Area>:<Cell End Area>. For example: "B2:F10".
<Control Name>: Character string (with or without quotes)
Name of the Spreadsheet control to use in the report.

Modifying the area to print in a Spreadsheet control Hide the details

<Control Name>..PrintArea = <Area to Print>
<Control Name>: Character string (with or without quotes)
Name of the Spreadsheet control to use in the report.
<Area to Print>: Character string with quotes
Area to print expressed in the following format: <Cell Start Area>:<Cell End Area>. For example: "B2:F10".
See also
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment