Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, CLI, Studio and browser tools 565 stars PSWriteOfficePowerShell module 165 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/

API Reference

Class

GoogleSheetsFormulaCatalog

Edit on GitHub
Namespace OfficeIMO.Excel.GoogleSheets
Assembly OfficeIMO.Excel.GoogleSheets
Source ../../../../_/OfficeIMO.Excel.GoogleSheets/GoogleSheetsFormulaCatalog.cs:62
Modifiers static

Conservative Excel-to-Sheets function catalog and formula rewriter.

Inheritance

  • Object
  • GoogleSheetsFormulaCatalog

Methods

public static GoogleSheetsFormulaTranslation Translate(String formula, GoogleSheetsFormulaOptions options = null) #
../../../../_/OfficeIMO.Excel.GoogleSheets/GoogleSheetsFormulaCatalog.cs:62
Returns: GoogleSheetsFormulaTranslation

Normalizes a formula and rewrites known or caller-mapped function names.

Parameters

formula System.String requiredposition: 0
options OfficeIMO.Excel.GoogleSheets.GoogleSheetsFormulaOptions = null optionalposition: 1