IXlsCalculationOptions

COM interface ( getting help with interfaces )

interface IXlsCalculationOptions : IDispatch
{

  [id(1), propget] HRESULT AutoRecalc([out, retval] BOOL* bAutoRecalc);
  [id(1), propput] HRESULT AutoRecalc([in]BOOL bAutoRecalc);
  [id(2), propget] HRESULT TreatErrorsAsCodeErrors([out, retval] BOOL* bCodeErrors);
  [id(2), propput] HRESULT TreatErrorsAsCodeErrors([in]BOOL bCodeErrors);
  [id(3), propget] HRESULT LastFormulaError([out, retval]IXlsFormulaError** lastError);
  [id(4), propput] HRESULT AutoRecalcOnClose([in]enumAutoRecalcOption bAutoRecalcOnClose);

}

HRESULT AutoRecalc([out, retval] BOOL* bAutoRecalc);
returns whether or not xlsgen should automatically keep track and recalculate formula value changes. If set to true, performance may be degraded accordingly. Default value is : no auto recalc.

HRESULT AutoRecalc([in]BOOL bAutoRecalc);
sets whether or not xlsgen should automatically keep track and recalculate formula value changes. If set to true, performance may be degraded accordingly. Default value is : no auto recalc.

HRESULT TreatErrorsAsCodeErrors([out, retval] BOOL* bCodeErrors);
returns whether or not xlsgen should treat formula calculation errors as code execution errors, or let those fail silently. Default value is : fail silently.

HRESULT TreatErrorsAsCodeErrors([in]BOOL bCodeErrors);
sets whether or not xlsgen should treat formula calculation errors as code execution errors, or let those fail silently. Default value is : fail silently.

HRESULT LastFormulaError([out, retval]IXlsFormulaError** lastError);
returns the last formula error after a calculation.

HRESULT AutoRecalcOnClose([in]enumAutoRecalcOption bAutoRecalcOnClose);
sets whether or not xlsgen should automatically recalculate the entire workbook on close, when it's saved. Default value is : true.