2.2.4.6.16 DataObject::SetKeepTextOnExecuteFormula

Description

Set keep text on execute formula instead of becoming missing values.

Syntax

BOOL SetKeepTextOnExecuteFormula( BOOL bOn = TRUE )

Parameters

bOn

[input] is keep on

Return

TRUE if successful else FALSE.

Examples

EX1

void    DataObject_SetKeepTextOnExecuteFormula_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
 
    out_int("SetKeepTextOnExecuteFormula: ", bSuccess);
}

Remark

See Also

DataObject::IsKeepTextOnExecuteFormula

Header to Included

origin.h