2.2.4.6.16 DataObject::SetKeepTextOnExecuteFormula

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

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);
}