Cell.BasicFormulas.GetBasicFormula Method

NanoXLSX

previous page next page
NanoXLSX

CellBasicFormulasGetBasicFormula Method

Function to generate a basic Excel function with one cell range as parameter and an optional post argument

Namespace:  NanoXLSX
Assembly:  NanoXLSX (in NanoXLSX.dll) Version: 1.2.3.0 (1.2.3)
Syntax
C#
Copy
private static Cell GetBasicFormula(
	Worksheet target,
	CellRange range,
	string functionName,
	string postArg
)

Parameters

target
Type: NanoXLSXWorksheet
Target worksheet of the cell reference. Can be null if on the same worksheet
range
Type: NanoXLSXCellRange
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 be added to a worksheet
See Also
previous page start next page