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.3+c820fb107cc06ae187946bad43db42d71f6faf1c
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