public void ApplyCellFormula( int columnIndex, string formula, Nullable<CellReferenceMode> cellReferenceMode )
Exception | Description |
---|---|
System.ArgumentOutOfRangeException | columnIndex is less than zero or greater than or equal to the number of columns in the worksheet. |
System.ArgumentNullException | formula is null or empty. |
FormulaParseException | formula is not a valid formula. |
System.InvalidOperationException | The cell is part of an array formula or data table which is not confined to just the cell. |
Infragistics.Documents.Excel.MockClasses.InvalidEnumArgumentException | cellReferenceMode is not defined in the CellReferenceMode enumeration. |
System.InvalidOperationException | If the row was removed from the worksheet. |
formula is parsed based on the CellReferenceMode of the Workbook to which the row belongs. If the row's Worksheet has been removed from its parent collection, the A1 CellReferenceMode will be used to parse the formula.
Target Platforms: Android 4.4+, iOS 8+
Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+