Cell.BasicFormulas.GetBasicFormula Method

PicoXLSX Library Documentation

CellBasicFormulasGetBasicFormula Method

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

Namespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 2.4.0.0 (2.4.0)

Syntax

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

target: Type: PicoXLSXWorksheet
Target worksheet of the cell reference. Can be null if on the same worksheet
range: Type: PicoXLSXCellRange
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 added to a worksheet