AdjustmentMode (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

AdjustmentMode (Property)

In french: ModeAjustement

..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 Spreadsheet control:
modeAdjustmentNone No scaling is performed.
modeAdjustmentColumns All the columns are adjusted to the control width.
modeAdjustmentRows All the rows are adjusted to the control height.
modeAdjustmentRowsAndColumns The worksheet is adjusted to the dimensions of Spreadsheet control.

<Control name>: Character string (with or without quotes)

Name of the Spreadsheet control to use.

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.

<New Adjustment>: Integer constant

New adjustment mode for the Spreadsheet control:
modeAdjustmentNone No scaling is performed.
modeAdjustmentColumns All the columns are adjusted to the control width.
modeAdjustmentRows All the rows are adjusted to the control height.
modeAdjustmentRowsAndColumns The worksheet is adjusted to the dimensions of Spreadsheet control.