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.

Accepted by parameters

Constructors

public ExcelSaveOptions() #

Properties

public Nullable<Int64> MaxInMemoryPackageBytes { get; set; } #

Maximum package size that may be materialized in memory while saving. The default is 256 MiB. Set to null only for explicitly trusted, intentionally larger workbooks.

public Nullable<Int64> MaxTemporaryPackageBytes { get; set; } #

Maximum package size that may be staged in a temporary file when a target framework requires a seekable package destination. The default is 256 MiB. Set to null only for explicitly trusted, intentionally larger workbooks.

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 OfficeConversionLossPolicy LossPolicy { get; set; } #

Controls saves of workbooks projected from legacy XLS files when known legacy-only content cannot be represented by the selected output format. The default blocks the save.

public OfficeSignatureMutationPolicy SignatureMutationPolicy { get; set; } #

Gets or sets how save operations handle digital-signature metadata. The safe default blocks package rewriting; removing or preserving invalidated markup must be selected explicitly.

public static ExcelSaveOptions Default { get; } #

Returns a fresh options instance with the default save policy.

Fields

public const Int64 DefaultMaxInMemoryPackageBytes #

Default maximum package size materialized by save operations: 256 MiB.

Value: 268435456
public const Int64 DefaultMaxTemporaryPackageBytes #

Default maximum temporary package size staged for a non-seekable destination: 256 MiB.

Value: 268435456