 | CellBasic |
Class for handling of basic Excel formulas
Inheritance HierarchyNamespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.2.1+e0edc719a6aeecf6c989e5a57750c75d6f3175bb
SyntaxC#
public static class BasicFormulas
The CellBasicFormulas type exposes the following members.
Methods| Name | Description | |
|---|---|---|
  | Average(CellRange) | Returns a cell with a average formula |
| Average(Worksheet, CellRange) | Returns a cell with a average formula |
| Ceil(CellAddress, Int32) | Returns a cell with a ceil formula |
| Ceil(Worksheet, CellAddress, Int32) | Returns a cell with a ceil formula |
| Floor(CellAddress, Int32) | Returns a cell with a floor formula |
| Floor(Worksheet, CellAddress, Int32) | Returns a cell with a floor formula |
 | GetBasicFormula | Function to generate a basic Excel function with one cell range as parameter and an optional post argument |
| GetVLookup | Function to generate a Vlookup as Excel function |
| Max(CellRange) | Returns a cell with a max formula |
| Max(Worksheet, CellRange) | Returns a cell with a max formula |
| Median(CellRange) | Returns a cell with a median formula |
| Median(Worksheet, CellRange) | Returns a cell with a median formula |
| Min(CellRange) | Returns a cell with a min formula |
| Min(Worksheet, CellRange) | Returns a cell with a min formula |
| Round(CellAddress, Int32) | Returns a cell with a round formula |
| Round(Worksheet, CellAddress, Int32) | Returns a cell with a round formula |
| Sum(CellRange) | Returns a cell with a sum formula |
| Sum(Worksheet, CellRange) | Returns a cell with a sum formula |
| VLookup(CellAddress, CellRange, Int32, Boolean) | Function to generate a Vlookup as Excel function |
| VLookup(Object, CellRange, Int32, Boolean) | Function to generate a Vlookup as Excel function |
| VLookup(Object, Worksheet, CellRange, Int32, Boolean) | Function to generate a Vlookup as Excel function |
| VLookup(Worksheet, CellAddress, Worksheet, CellRange, Int32, Boolean) | Function to generate a Vlookup as Excel function |
See Also