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> = <Spreadsheet control>..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.

<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:
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.