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+3a069966d2787c42b695e5043a5e083b247634e3
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