static Cell |
BasicFormulas.Average(Range range) |
Returns a cell with a average formula
|
static Cell |
BasicFormulas.Average(Worksheet target,
Range range) |
Returns a cell with a average formula
|
static Cell |
BasicFormulas.Ceil(Address address,
int decimals) |
Returns a cell with a ceil formula
|
static Cell |
BasicFormulas.Ceil(Worksheet target,
Address address,
int decimals) |
Returns a cell with a ceil formula
|
static Cell |
BasicFormulas.Floor(Address address,
int decimals) |
Returns a cell with a floor formula
|
static Cell |
BasicFormulas.Floor(Worksheet target,
Address address,
int decimals) |
Returns a cell with a floor formula
|
Cell |
Worksheet.getCell(int columnNumber,
int rowNumber) |
Gets the cell of the specified column and row number (zero-based)
|
Cell |
Worksheet.getCell(Address address) |
Gets the cell of the specified address
|
static Cell |
BasicFormulas.Max(Range range) |
Returns a cell with a max formula
|
static Cell |
BasicFormulas.Max(Worksheet target,
Range range) |
Returns a cell with a max formula
|
static Cell |
BasicFormulas.Median(Range range) |
Returns a cell with a median formula
|
static Cell |
BasicFormulas.Median(Worksheet target,
Range range) |
Returns a cell with a median formula
|
static Cell |
BasicFormulas.Min(Range range) |
Returns a cell with a min formula
|
static Cell |
BasicFormulas.Min(Worksheet target,
Range range) |
Returns a cell with a min formula
|
static Cell |
BasicFormulas.Round(Address address,
int decimals) |
Returns a cell with a round formula
|
static Cell |
BasicFormulas.Round(Worksheet target,
Address address,
int decimals) |
Returns a cell with a round formula
|
static Cell |
BasicFormulas.Sum(Range range) |
Returns a cell with a sum formula
|
static Cell |
BasicFormulas.Sum(Worksheet target,
Range range) |
Returns a cell with a sum formula
|
static Cell |
BasicFormulas.VLookup(Address address,
Range range,
int columnIndex,
boolean exactMatch) |
Function to generate a Vlookup as Excel function
|
static Cell |
BasicFormulas.VLookup(Worksheet queryTarget,
Address address,
Worksheet rangeTarget,
Range range,
int columnIndex,
boolean exactMatch) |
Function to generate a Vlookup as Excel function
|
static Cell |
BasicFormulas.VLookup(Object number,
Range range,
int columnIndex,
boolean exactMatch) |
Function to generate a Vlookup as Excel function
|
static Cell |
BasicFormulas.VLookup(Object number,
Worksheet rangeTarget,
Range range,
int columnIndex,
boolean exactMatch) |
Function to generate a Vlookup as Excel function
|