ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / Properties associated with reports and controls
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
The AdjustmentMode property determines and changes how a Spreadsheet control is adjusted in a report.
Example
// -- Initialization process of the PSHEET_Statistics control
PSHEET_Statistics = "FashionShow.xlsx"
PSHEET_Statistics.AdjustmentMode = adjustementModeRowsAndColumns
Syntax

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

<Result> = <Spreadsheet control>.AdjustmentMode
<Result>: Integer constant
Spreadsheet control adjustment mode:
adjustementModeColumnsAll the columns are adjusted to the control width.
adjustementModeRowsAll the rows are adjusted to the control height.
adjustmentModeNoneNo scaling is performed.
adjustmentModeRowsAndColumnsThe worksheet is adjusted to the dimensions of the 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:
adjustementModeColumnsAll the columns are adjusted to the control width.
adjustementModeRowsAll the rows are adjusted to the control height.
adjustmentModeNoneNo scaling is performed.
adjustmentModeRowsAndColumnsThe worksheet is adjusted to the dimensions of the Spreadsheet control.
Remarks
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/04/2024

Send a report | Local help