Column::SetLowerBound

SetLowerBound

1 Description
2 Syntax
3 Parameters
4 Return
5 Examples
6 Remark
7 See Also
8 header to Include

Description

Set the begining row display index.

Syntax

BOOL SetLowerBound( int iR1, BOOL bUndo = FALSE )

Parameters

iR1: [input] Beginning row index (0 based)
bUndo: [input] if bUndo is true, you can use Ctrl + Z to undo.

Return

Returns TRUE on success and FALSE on failure.

Examples

EX1

// Create a worksheet with data, then hide some of the data
void    Column_SetLowerBound_Ex1()
{
    Worksheet wks;
    wks.Create("Origin",CREATE_VISIBLE);
    DataRange dr;
    vector v1;
    v1.Data(1,100); // Fill column 1 with data
    dr.Add("X", wks, 0, 0, -1, 0);
    dr.Add("Y", wks, 0, 1, -1, 1);
    vector v2;
    v2.Normal(100);
    dr.SetData(&v2, &v1);
    Column colObj(wks, 0);
    int nR2 = 26;
    colObj.SetLowerBound(nR2); // Limit display to rows 26 to 100
    colObj.Attach(wks, 1); // Re-use Column object for second column
    colObj.SetLowerBound(nR2); // Limit display to rows 26 to 100
}