Previous - xlsSetFontStyle Section Home - Microsoft Excel Next - xlsSetNumberFormat


xlsSetAlignment ( )

Sets the text alignment for the range of selected cells

Usage:

xlsSetAlignment (object me, integer alignmentType )

Parameters:

alignmentType (integer) - The possible values are:

1: left alignment
2: center alignment
3: right alignment
4: justify alignment

Returns:

(integer) - The success code

Example:

xtRose = xtra("Rosetta").new( )
xtRose.xlsLaunch( )
xtRose.xlsNewBlank( )
xtRose.xlsSetRange( 1, 1, 5, 3 )
xtRose.xlsInsertTxt( [ ["a","b","c","d","e"], [1,2,3,4,5], [1.1, 2.2, 3.3, 4.4, 5.5] ] )
xtRose.xlsSetRange( 1, 1, 5, 1 ) -- selects the first row for editing alignment
xtRose.xlsSetAlignment( 2 )

Notes:


Previous - xlsSetFontStyle Section Home - Microsoft Excel Next - xlsSetNumberFormat