Get Started

API Reference

Class

OdsFormulaEvaluator

Edit on GitHub
Namespace OfficeIMO.OpenDocument
Assembly OfficeIMO.OpenDocument
Source OfficeIMO.OpenDocument/Spreadsheet/Formulas/OdsFormulaEvaluator.cs:8
Modifiers static

Bounded, side-effect-free evaluator for a documented OpenFormula subset.

Inheritance

  • Object
  • OdsFormulaEvaluator

Methods

public static OdsFormulaEvaluationResult EvaluateCell(OdsDocument document, String sheetName, Int64 row, Int64 column, OdsFormulaEvaluationOptions options = null) #
OfficeIMO.OpenDocument/Spreadsheet/Formulas/OdsFormulaEvaluator.cs:8
Returns: OdsFormulaEvaluationResult

Evaluates a formula cell without changing its cached value.

Parameters

document OfficeIMO.OpenDocument.OdsDocument requiredposition: 0
sheetName System.String requiredposition: 1
row System.Int64 requiredposition: 2
column System.Int64 requiredposition: 3
options OfficeIMO.OpenDocument.OdsFormulaEvaluationOptions = null optionalposition: 4
public static OdsFormulaEvaluationResult EvaluateExpression(OdsDocument document, String sheetName, String formula, OdsFormulaEvaluationOptions options = null) #
OfficeIMO.OpenDocument/Spreadsheet/Formulas/OdsFormulaEvaluator.cs:20
Returns: OdsFormulaEvaluationResult

Evaluates an OpenFormula expression in the context of a worksheet.

Parameters

document OfficeIMO.OpenDocument.OdsDocument requiredposition: 0
sheetName System.String requiredposition: 1
formula System.String requiredposition: 2
options OfficeIMO.OpenDocument.OdsFormulaEvaluationOptions = null optionalposition: 3