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.2+7f12a949130e0be1e987e553d2d08c083176cdca
Syntax
C#
Copy
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