API Reference
ExcelCalculationOptions
Controls how formula cells are treated before a workbook is saved.
Inheritance
- Object
- ExcelCalculationOptions
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Property ExcelDocument.Calculation
Constructors
public ExcelCalculationOptions() #Methods
public Void ClearCustomFunctions() #VoidRemoves all custom formula functions registered for this workbook.
public Void RegisterCustomFunction(String name, ExcelCustomFormulaFunction function) #VoidRegisters or replaces a custom formula function for this workbook.
Parameters
- name System.String
- function OfficeIMO.Excel.ExcelCustomFormulaFunction
public Boolean RemoveCustomFunction(String name) #BooleanRemoves a registered custom formula function.
Parameters
- name System.String
Inherited Methods
Properties
public Int32 MaximumDependencyDepth { get; set; } #Gets or sets the maximum number of nested formula cells OfficeIMO evaluates in one dependency chain.
public Boolean EvaluateFormulasBeforeSave { get; set; } #When true, OfficeIMO evaluates supported formulas and writes cached values before saving. Unsupported formulas are left intact and can still be recalculated by Excel.
public Boolean MarkFormulasDirtyBeforeSave { get; set; } #When true, formula cells are marked dirty so Excel-compatible applications recalculate them on open.
public Boolean ForceFullCalculationOnOpen { get; set; } #When true, workbook calculation properties request a full recalculation when the file opens.
public Boolean ClearCachedFormulaResultsBeforeSave { get; set; } #When true, cached formula results are removed before saving. Ignored when EvaluateFormulasBeforeSave is true.
public IReadOnlyList<String> CustomFunctionNames { get; } #Gets the registered custom function names in ordinal order.