set_cols_in_range_to_same_datatype

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

Description

Set all columns in selected data range to the same data type if columns have different data type.

Syntax

int set_cols_in_range_to_same_datatype( DataRange & dr, int * pType = NULL )

Parameters

dr: [input] The data range selected.
pType: [input] pointer to columns' type.; If not NULL, all columns' type will set to pType. Otherwise, if one column's type is double, real, Complex or mixed(numeric &text, which is column's default setting), all columns' type will be set to double. Default is NULL.

Return

if succeed return the type value, otherwise return -1.

Examples

EX1

void set_cols_in_range_to_same_datatype_Ex1()
{
        
        Worksheet wks;
        wks.Create("Origin");
        if( wks )
        {
                DataRange dr;
        
                dr.Add(wks, 0, "X");
                dr.Add(wks, 1, "Y");
        
                // set two columns to different data type
                wks.Columns(0).SetFormat(OKCOLTYPE_NUMERIC);    
                wks.Columns(1).SetFormat(OKCOLTYPE_NUMERIC);    
                wks.Columns(0).SetInternalDataType(FSI_LONG);       
                wks.Columns(1).SetInternalDataType(FSI_DOUBLE);
                int nRet = set_cols_in_range_to_same_datatype(dr);
                if(nRet < 0)
                        printf("failed to set");
                else
                        printf("columns in selected data range are all set to same type \n" );
        
        }   

}