ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / Properties associated with reports and controls
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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
Adjustment mode of 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.
<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.
Minimum version required
  • Version 21
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/30/2024

Send a report | Local help