PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
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
..AdjustmentMode is used to find out and modify the adjustment mode of a Spreadsheet control in a report.
Example
// -- Initialization process of PSHEET_Satistics control
PSHEET_Satistics = "FashionShow.xlsx"
PSHEET_Satistics..AdjustmentMode = modeAdjustmentRowsAndColumns
Syntax

Finding out the adjustment mode of a Spreadsheet control in a report Hide the details

<Result> = <Control Name>..AdjustmentMode
<Result>: Integer constant
Adjustment mode of the Spreadsheet control:
modeAdjustmentNoneNo scaling is performed.
modeAdjustmentColumnsAll the columns are adjusted to the control width.
modeAdjustmentRowsAll the rows are adjusted to the control height.
modeAdjustmentRowsAndColumnsThe worksheet is adjusted to the dimensions of the Spreadsheet control.
<Control Name>: Character string (with or without quotes)
Name of the Spreadsheet control to use in the report.

Modifying the adjustment mode of a Spreadsheet control in a report Hide the details

<Control Name>..AdjustmentMode = <New Adjustment>
<Control Name>: Character string (with or without quotes)
Name of the Spreadsheet control to use in the report.
<New Adjustment>: Integer constant
New adjustment mode for the Spreadsheet control:
modeAdjustmentNoneNo scaling is performed.
modeAdjustmentColumnsAll the columns are adjusted to the control width.
modeAdjustmentRowsAll the rows are adjusted to the control height.
modeAdjustmentRowsAndColumnsThe worksheet is adjusted to the dimensions of the Spreadsheet control.
Minimum required version
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment