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+064d9a8047d8da6ad83b4776af2459e923cc7c3d
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