CXlOper::SetLongFormula() Example
CopyC++
IMPLEMENT_XLLFN3(SetLongFormula, SetLongFormula_4, SetLongFormula_12, "A", "A",
L"SetLongFormula", 0, L"", 0, L"14", 0, L"Paste a long formula to the curr"
L"ent cell", 0, L"", 0, 0, L"{SetLongFormula,,,Paste a long formula to the"
L" current cell,14,2,132,A,{},{},3,,0,0}", 2)
BOOL SetLongFormula_Impl();
extern "C" __declspec(dllexport)
BOOL SetLongFormula_12()
{
XLL_FIX_STATE;
return SetLongFormula_Impl();
}
extern "C" __declspec(dllexport)
BOOL SetLongFormula_4()
{
XLL_FIX_STATE;
return SetLongFormula_Impl();
}
BOOL SetLongFormula_Impl()
{
int nChars = 200;
int nRepeats = 4;
char achVal1[1024];
int i;
for (i = 0; i < nChars; i++)
achVal1[i] = 'A' + (i % 26);
achVal1[i] = 0;
CString strVal2 = "";
for (i = 0; i < nRepeats; i++)
strVal2 += ((i > 0) ? "&" : "") + CString("\"") + achVal1 + "\"";
CString strFormula = "=" + strVal2;
CString strMsg;
strMsg.Format("Formula Length = %d", strFormula.GetLength());
CXllApp::XlMessageBox(strMsg, XlMessageBoxTypeInformation);
CXlOper xloActive;
if (xloActive.GetActiveCell()
&& xloActive.SetLongFormula(strFormula))
{
return TRUE;
}
else
{
CXllApp::XlMessageBox("Failed to set long formula", XlMessageBoxTypeExclamation);
return FALSE;
}
}
Uses
CXlOper::SetLongFormula