CellFormula Class
The CellFormula class provides a API that is used to handle the cell formula. More...
| Header: | #include <CellFormula> |
Public Types
| enum | FormulaType { NormalType, ArrayType, DataTableType, SharedType } |
Public Functions
| CellFormula() | |
| CellFormula(const char * formula, FormulaType type = NormalType) | |
| CellFormula(const QString & formula, FormulaType type = NormalType) | |
| CellFormula(const QString & formula, const CellRange & ref, FormulaType type) | |
| CellFormula(const CellFormula & other) | |
| ~CellFormula() | |
| QString | formulaText() const |
| FormulaType | formulaType() const |
| bool | isValid() const |
| CellRange | reference() const |
| int | sharedIndex() const |
| CellFormula & | operator=(const CellFormula & other) |
Detailed Description
The CellFormula class provides a API that is used to handle the cell formula.
Member Type Documentation
enum CellFormula::FormulaType
| Constant | Value |
|---|---|
| CellFormula::NormalType | 0 |
| CellFormula::ArrayType | 1 |
| CellFormula::DataTableType | 2 |
| CellFormula::SharedType | 3 |
Member Function Documentation
CellFormula::CellFormula()
Creates a new formula.
CellFormula::CellFormula(const char * formula, FormulaType type = NormalType)
Creates a new formula with the given formula and type.
CellFormula::CellFormula(const QString & formula, FormulaType type = NormalType)
Creates a new formula with the given formula and type.
CellFormula::CellFormula(const QString & formula, const CellRange & ref, FormulaType type)
Creates a new formula with the given formula, ref and type.
CellFormula::CellFormula(const CellFormula & other)
Creates a new formula with the same attributes as the other formula.
CellFormula::~CellFormula()
Destroys this formula.
QString CellFormula::formulaText() const
Returns the contents of the formula.
FormulaType CellFormula::formulaType() const
Returns the type of the formula.
bool CellFormula::isValid() const
Returns whether the formula is valid.
CellRange CellFormula::reference() const
Returns the reference cells of the formula. For normal formula, this will return an invalid CellRange object.
int CellFormula::sharedIndex() const
Returns the shared index for shared formula.
CellFormula & CellFormula::operator=(const CellFormula & other)
Assigns the other formula to this formula, and returns a reference to this formula.