PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | French EN
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> = <Spreadsheet control>..AdjustmentMode
<Result>: Integer constant
Adjustment mode of 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 Spreadsheet control.
<Spreadsheet control>: Control name
Name of the Spreadsheet control to use.

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

<Spreadsheet control>..AdjustmentMode = <New Adjustment>
<Spreadsheet control>: Control name
Name of the Spreadsheet control to use.
<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 Spreadsheet control.
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment