Previous - xlsSetFontColor Section Home - Microsoft Excel Next - xlsSetAlignment


xlsSetFontStyle ( )

Sets the font style used for the range of selected cells

Usage:

xlsSetFontStyle (object me, integer isBold, integer isItalic, integer isUnderLine )

Parameters:

isBold (integer) - 1 for setting the style bold, -1 to leave setting unchanged, all other integer sets font to be un-bold

isItalics (integer) - 1 for setting the style italic, -1 to leave setting unchanged, all other integer clears existing italics property

isUnderLine (integer) - 1 for setting underline, -1 to leave setting unchanged, all other integer clears existing underline property

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( 2, 1, 2, 3 ) -- selects  the second column for editing font styles
xtRose.pptSetFontColor( -1, 1, 0 )

Notes:


Previous - xlsSetFontColor Section Home - Microsoft Excel Next - xlsSetAlignment