Cell.BasicFormulas.GetBasicFormula Method

PicoXLSX

previous page next page
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: 2.4.0.0 (2.4.0)
Syntax
C#
Copy
private static Cell GetBasicFormula(
	Worksheet target,
	CellRange range,
	string functionName,
	string postArg
)

Parameters

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

Return Value

Type: Cell
Prepared Cell object, ready to added to a worksheet
See Also
previous page start next page