# GoogleSheetsUnsupportedFormulaMode

Action selected when a formula cannot be translated reliably.

Enum 

`OfficeIMO.Excel.GoogleSheets`

**Namespace**

`OfficeIMO.Excel.GoogleSheets`

**Assembly**

`OfficeIMO.Excel.GoogleSheets`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

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

**Base**

`Enum`

**Implements**

`IComparable` `ISpanFormattable` `IFormattable` `IConvertible`

**Modifiers**

sealed

Action selected when a formula cannot be translated reliably.

## Inheritance

- Enum
- GoogleSheetsUnsupportedFormulaMode

## Usage

Explore 4 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 4

- Property [GoogleSheetsFormulaOptions.UnsupportedFormulaMode](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsformulaoptions/#property-unsupportedformulamode)
- Field [GoogleSheetsUnsupportedFormulaMode.Error](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsunsupportedformulamode/#field-error)
- Field [GoogleSheetsUnsupportedFormulaMode.PreserveWithWarning](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsunsupportedformulamode/#field-preservewithwarning)
- Field [GoogleSheetsUnsupportedFormulaMode.UseCachedValue](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsunsupportedformulamode/#field-usecachedvalue)

Filter members 

Show inherited

## Inherited Methods

`public int CompareTo(object? target)` [#](#method-compareto-object)

Inherited from Enum

Parameters

**target object? required**

Returns

`int`

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

Inherited from Enum

Parameters

**obj object? required**

Returns

`bool`

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

Inherited from Enum

Returns

`int`

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

Inherited from object

Returns

`Type`

`public TypeCode GetTypeCode()` [#](#method-gettypecode)

Inherited from Enum

Returns

`TypeCode`

`public bool HasFlag(Enum flag)` [#](#method-hasflag-enum)

Inherited from Enum

Parameters

**flag Enum required**

Returns

`bool`

ToString 4 overloads

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

Inherited from Enum

Returns

`string`

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

Inherited from Enum

Parameters

**format string? required**

Returns

`string`

`public string ToString(IFormatProvider? provider)` [#](#method-tostring-iformatprovider)

Inherited from Enum

`Obsolete("The provider argument is not used. Use ToString() instead.")`

Parameters

**provider IFormatProvider? required**

Returns

`string`

`public string ToString(string? format, IFormatProvider? provider)` [#](#method-tostring-string-iformatprovider)

Inherited from Enum

`Obsolete("The provider argument is not used. Use ToString(String) instead.")`

Parameters

**format string? required**

**provider IFormatProvider? required**

Returns

`string`

## Values

`public const GoogleSheetsUnsupportedFormulaMode Error` [#](#field-error)

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

Report an error for unsupported formulas; whether it blocks export depends on the fidelity preflight mode and accepted diagnostic codes.

Value: `0`

`public const GoogleSheetsUnsupportedFormulaMode PreserveWithWarning` [#](#field-preservewithwarning)

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

Preserve the formula text and record a warning.

Value: `1`

`public const GoogleSheetsUnsupportedFormulaMode UseCachedValue` [#](#field-usecachedvalue)

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

Write the cached value when one is available.

Value: `2`

<!-- PowerForge markdown artifact sha256:5F6F766DC1C46E3683EBFC9A31631EC20F5B715C047FCD576B6BB100CAB51458 -->
