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.5+4f4b44a718a20dda8ca2c0c4d00bd7eee7c80f5d
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