Click or drag to resize
NanoXLSX

BasicFormulasGetBasicFormula 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: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc
Syntax
C#
private static Cell GetBasicFormula(
	Worksheet target,
	Range range,
	string functionName,
	string postArg
)

Parameters

target  Worksheet
Target worksheet of the cell reference. Can be null if on the same worksheet
range  Range
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