AdjustmentMode (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

AdjustmentMode (Property)

In french: ModeAjustement

The Property ModeAdjustment makes it possible to know and modify the adjustment mode of an Spreadsheet control in an report.

Example

// -- Initialization process of PSHEET_Satistics control
PSHEET_Satistics = "FashionShow.xlsx"
TBLR_Satistics.ModeAdjustment = 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.