2.2.4.6.10 DataObject::IsKeepTextOnExecuteFormula


Description

Check whether to keep text on execute formula instead of becoming missing values.

Syntax

BOOL IsKeepTextOnExecuteFormula( )

Parameters

Return

TRUE if keep else FALSE.

Examples

EX1

void    DataObject_IsKeepTextOnExecuteFormula_Ex1(BOOL bKeep = TRUE)
{
    Worksheet wks;
    wks.Create("origin", CREATE_VISIBLE);    
 
    Dataset dsA(wks, 0);
    dsA.Data(1, 100, 1); 
    dsA.SetText(3, "textA");
    
    Dataset dsB(wks, 1);
    dsB.Data(1, 100, 1);
    dsB.SetText(3, "textB");
 
    Column col(wks, 1);
    
    BOOL bSuccess = col.SetKeepTextOnExecuteFormula(bKeep);

    col.SetFormula("col(A) * 2", AU_AUTO);
    col.ExecuteFormula();// this step is needed to initiate Recaulation
 
    BOOL bIsKeep = col.IsKeepTextOnExecuteFormula();
    out_int("IsKeepTextOnExecuteFormula: ", bIsKeep);
}

Remark

See Also

DataObject::SetKeepTextOnExecuteFormula

Header to Included

origin.h