API Reference

Class

ExcelSaveOptions

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Optional behaviors applied during ExcelSaveOptions) and CancellationToken) to strengthen robustness and CI validation.

Inheritance

  • Object
  • ExcelSaveOptions

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

Accepted by parameters

Constructors

public ExcelSaveOptions() #

Properties

public Boolean SafeRepairDefinedNames { get; set; } #

When true, attempts to repair common defined-name issues (duplicates, out-of-range LocalSheetId, #REF!) before save.

public Boolean ValidateOpenXml { get; set; } #

When true, validates the saved package using OpenXmlValidator and throws on any errors.

public Boolean SafePreflight { get; set; } #

When true, performs a safety preflight on all worksheets before saving, removing empty containers (e.g., empty Hyperlinks/MergeCells), dropping orphaned drawing/header-footer references, and cleaning up invalid table references. This can prevent rare "Repaired Records" notices in Excel.

public Boolean DisableFastPackageWriter { get; set; } #

When true, disables direct fast package writers and always uses the standard save finalization path.

public Boolean EvaluateFormulasBeforeSave { get; set; } #

When true, evaluates supported formulas and writes cached values before this save. Unsupported formulas are preserved for Excel-compatible applications to calculate.

public Boolean ClearCachedFormulaResultsBeforeSave { get; set; } #

When true, removes cached formula results before this save. Ignored when EvaluateFormulasBeforeSave is true.

public Boolean MarkFormulasDirtyBeforeSave { get; set; } #

When true, marks formulas dirty before this save so Excel-compatible applications recalculate on open.

public Boolean ForceFullCalculationOnOpen { get; set; } #

When true, writes workbook calculation properties requesting a full recalculation on open.

public static ExcelSaveOptions None { get; } #

Returns an options instance with all features disabled.