GrapeCity.Documents.Excel.SjsOpenOptions

SjsOpenOptions Class

Represents options for opening a SpreadJS .sjs file.

Use this class with workbook open APIs when loading an .sjs file. A new SjsOpenOptions instance sets the file format to Sjs. By default, styles and formulas are included when the file is loaded.

Inheritance

object

OpenOptionsBase

SjsOpenOptions

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public class SjsOpenOptions : OpenOptionsBase

Public Class SjsOpenOptions
    Inherits OpenOptionsBase

Examples

SjsOpenOptions openOptions = new SjsOpenOptions();
openOptions.IncludeStyles = false;
openOptions.IncludeFormulas = true;
workbook.Open("path/to/file.sjs", openOptions);

Constructors

Name	Description
SjsOpenOptions()	Constructor.

Properties

Name Description

Name	Description
IncludeFormulas	Gets or sets whether formulas are included when loading a SpreadJS `.sjs` file. This option indicates whether formula information in the `.sjs` file is loaded. The default value is true.
IncludeStyles	Gets or sets whether styles are included when loading a SpreadJS `.sjs` file. This option controls whether style information in the `.sjs` file is loaded. The default value is true.
InvalidFormulaHandling	Gets or sets how invalid formulas are handled when opening a SpreadJS `.sjs` file. Default is Discard.

IncludeFormulas

Gets or sets whether formulas are included when loading a SpreadJS .sjs file.

This option indicates whether formula information in the .sjs file is loaded. The default value is true.

IncludeStyles

Gets or sets whether styles are included when loading a SpreadJS .sjs file.

This option controls whether style information in the .sjs file is loaded. The default value is true.

InvalidFormulaHandling

Gets or sets how invalid formulas are handled when opening a SpreadJS .sjs file. Default is Discard.