Aspose::Cells::Tables::ListColumn class
Contents
[
Hide
]ListColumn class
Represents a column in a Table.
class ListColumn
Methods
Method | Description |
---|---|
GetCustomCalculatedFormula(bool isR1C1, bool isLocal) | Gets the formula of this list column. |
GetCustomTotalsRowFormula(bool isR1C1, bool isLocal) | Gets the formula of totals row of this list column. |
GetDataStyle() | Gets the style of the data in this column of the table. |
GetFormula() | Gets and sets the formula of the list column. |
GetName() | Gets and sets the name of the column. |
GetRange() | Gets the range of this list column. |
GetTotalsCalculation() | Gets and sets the type of calculation in the Totals row of the list column. |
GetTotalsRowLabel() | Gets and sets the display labels of total row. |
IsNull() const | Checks whether the implementation object is nullptr. |
ListColumn(ListColumn_Impl* impl) | Constructs from an implementation object. |
ListColumn(const ListColumn& src) | Copy constructor. |
explicit operator bool() const | operator bool() |
operator=(const ListColumn& src) | operator= |
SetCustomCalculatedFormula(const U16String& formula, bool isR1C1, bool isLocal) | Sets the formula for this list column. |
SetCustomCalculatedFormula(const char16_t* formula, bool isR1C1, bool isLocal) | Sets the formula for this list column. |
SetCustomTotalsRowFormula(const U16String& formula, bool isR1C1, bool isLocal) | Gets the formula of totals row of this list column. |
SetCustomTotalsRowFormula(const char16_t* formula, bool isR1C1, bool isLocal) | Gets the formula of totals row of this list column. |
SetDataStyle(const Style& style) | Sets the style of the data in this column of the table. |
SetFormula(const U16String& value) | Gets and sets the formula of the list column. |
SetFormula(const char16_t* value) | Gets and sets the formula of the list column. |
SetName(const U16String& value) | Gets and sets the name of the column. |
SetName(const char16_t* value) | Gets and sets the name of the column. |
SetTotalsCalculation(TotalsCalculation value) | Gets and sets the type of calculation in the Totals row of the list column. |
SetTotalsRowLabel(const U16String& value) | Gets and sets the display labels of total row. |
SetTotalsRowLabel(const char16_t* value) | Gets and sets the display labels of total row. |
~ListColumn() | Destructor. |
Fields
Field | Description |
---|---|
_impl | The implementation object. |
Examples
Aspose::Cells::Startup();
Workbook workbook;
Cells cells = workbook.GetWorksheets().Get(0).GetCells();
for (int i = 0; i < 5; i++)
{
cells.Get(0, i).PutValue(CellsHelper::ColumnIndexToName(i));
}
for (int row = 1; row < 10; row++)
{
for (int column = 0; column < 4; column++)
{
cells.Get(row, column).PutValue(row * column);
}
}
ListObjectCollection tables = workbook.GetWorksheets().Get(0).GetListObjects();
int index = tables.Add(0, 0, 9, 4, true);
ListObject table = tables.Get(0);
table.SetShowTotals(true);
ListColumn listColumn = table.GetListColumns().Get(4);
listColumn.SetTotalsCalculation(TotalsCalculation::Sum);
listColumn.SetFormula(u"=[A]");
workbook.Save(u"Book1.xlsx");
Aspose::Cells::Cleanup();
See Also
- Namespace Aspose::Cells::Tables
- Library Aspose.Cells for C++