Click or drag to resize
PicoXLSX

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: 3.4.5+6ab75fa9edd66571b0de8e574b48108101297ca1
Syntax
C#
Copy
private static Cell GetBasicFormula(
	Worksheet target,
	CellRange range,
	string functionName,
	string postArg
)

Parameters

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

Return Value

Cell
Prepared Cell object, ready to be added to a worksheet.
See Also