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.2+f55916d49ef2baa43fc7dc8f5c7d751a77c50baf
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