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.7+b0ed5f8a99a50b9e6528224889fbd7f23c30b364
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