2.2.4.46.85 Worksheet::SetUpperBound

Description

Set the ending row display index for the specified columns in this Worksheet. Index values are 0 based offset.

Syntax

BOOL SetUpperBound( int iR2, int iC1 = 0, int iC2 = -1 )

Parameters

iR2
[input] Input ending row index (0 based)
iC1
[input] Input begining column index (0 based offset, default 0 is first column)
iC2
[input] Input ending column index (0 based offset, default -1 is last column)

Return

Returns TRUE on success and FALSE on failure.

Examples

EX1

// Set row limit for all columns in worksheet to 26
// Worksheet should be active
void Worksheet_SetUpperBound_Ex1()
{
    Worksheet wks = Project.ActiveLayer();
    int nR2 = 25;    // This will be row 26 in the worksheet
    if( wks.SetUpperBound(nR2) )
        printf("Success to set upper bound of specified column!");
    else
        printf("Fail to set upper bound of specified column!");
}

Remark

See Also

Worksheet::SetLowerBound, Worksheet::SetBounds, Worksheet::GetBounds

Header to Include

origin.h