# GoogleSheetsFormulaOptions

Formula rewriting and unsupported-function policy.

Class 

`OfficeIMO.Excel.GoogleSheets`

**Namespace**

`OfficeIMO.Excel.GoogleSheets`

**Assembly**

`OfficeIMO.Excel.GoogleSheets`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[GoogleSheetsSaveOptions.cs:71](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsSaveOptions.cs#L71)

**Modifiers**

sealed

Formula rewriting and unsupported-function policy.

## Inheritance

- object
- GoogleSheetsFormulaOptions

## Usage

Explore 2 API references to this type

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

### Returned or exposed by 1

- Property [GoogleSheetsSaveOptions.Formulas](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetssaveoptions/#property-formulas)

### Accepted by parameters 1

- Method [GoogleSheetsFormulaCatalog.Translate](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsformulacatalog/#method-translate-string-officeimo-excel-googlesheets-googlesheetsformulaoptions) parameter `options`

Filter members 

Show inherited

## Constructors

`public GoogleSheetsFormulaOptions()` [#](#constructor-ctor)

[GoogleSheetsSaveOptions.cs:71](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsSaveOptions.cs#L71)

## Inherited Methods

`public virtual bool Equals(object? obj)` [#](#method-equals-object)

Inherited from object

Parameters

**obj object? required**

Returns

`bool`

`public virtual int GetHashCode()` [#](#method-gethashcode)

Inherited from object

Returns

`int`

`public Type GetType()` [#](#method-gettype)

Inherited from object

Returns

`Type`

`public virtual string? ToString()` [#](#method-tostring)

Inherited from object

Returns

`string?`

## Properties

`public GoogleSheetsUnsupportedFormulaMode UnsupportedFormulaMode { get; set; }` [#](#property-unsupportedformulamode)

[GoogleSheetsSaveOptions.cs:71](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsSaveOptions.cs#L71)

Gets or sets how unsupported formulas are handled; defaults to preserving with a warning.

`public bool TreatUnknownFunctionsAsUnsupported { get; set; }` [#](#property-treatunknownfunctionsasunsupported)

[GoogleSheetsSaveOptions.cs:73](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsSaveOptions.cs#L73)

Gets or sets whether functions absent from the catalog count as unsupported; defaults to true.

`public IDictionary<string, string> FunctionMappings { get; }` [#](#property-functionmappings)

[GoogleSheetsSaveOptions.cs:75](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsSaveOptions.cs#L75)

Gets caller-supplied, case-insensitively keyed function-name replacements.

<!-- PowerForge markdown artifact sha256:2AEFC7479CCC64048A38EEA4F1AF0E916E562C0AE7ACD3E475DAFE3F2C2F4AE5 -->
