Cell.BasicFormulas.GetBasicFormula Method

NanoXLSX Library Documentation

CellBasicFormulasGetBasicFormula Method

Function to generate a basic Excel function with one cell range as parameter and an optional post argument

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 1.2.3.0 (1.2.3)

Syntax

private static Cell GetBasicFormula(
	Worksheet target,
	CellRange range,
	string functionName,
	string postArg
)

target: Type: NanoXLSXWorksheet
Target worksheet of the cell reference. Can be null if on the same worksheet
range: Type: NanoXLSXCellRange
Main argument as cell range. If applied on one cell, the start and end address are identical
functionName: Type: SystemString
Internal Excel function name
postArg: Type: SystemString
Optional argument

Type: Cell
Prepared Cell object, ready to be added to a worksheet