IXlsFormulaError

COM interface ( getting help with interfaces )

interface IXlsFormulaError : IDispatch
{

  [id(1), propget] HRESULT FormulaWorksheet([out, retval] int* index);
  [id(2), propget] HRESULT FormulaRow([out, retval] int* row);
  [id(3), propget] HRESULT FormulaColumn([out, retval] int* column);
  [id(4), propget] HRESULT FormulaError([out, retval] enumFormulaError* error);

}

The IXlsFormulaError interface can be accessed from the LastFormulaError property of the IXlsCalculationOptions interface, which itself is exposed by the workbook.

HRESULT FormulaWorksheet([out, retval] int* index);
returns the index that identifies the worksheet formula where there is a calculation error.

HRESULT FormulaRow([out, retval] int* row);
returns the row that identifies the formula where there is a calculation error.

HRESULT FormulaColumn([out, retval] int* column);
returns the column that identifies the formula where there is a calculation error.

HRESULT FormulaError([out, retval] enumFormulaError* error);
returns the last formula error.