API Reference
Class
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() #Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
Properties
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.