ListColumn

Inheritance: java.lang.Object

public class ListColumn

Represents a column in a Table.

Example

         Workbook workbook = new Workbook();
         Cells cells = workbook.getWorksheets().get(0).getCells();
         for (int i = 0; i  ? i++)
         {
         cells.get(0,i).putValue(CellsHelper.columnIndexToName(i));
          }
         for (int row = 1; row  ? row++)
         {
          for (int column = 0; column  ? 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(com.aspose.cells.TotalsCalculation.SUM);
         listColumn.setFormula("=[A]");
         workbook.save("Book1.xlsx");

Methods

MethodDescription
equals(Object arg0)
getClass()
getCustomCalculatedFormula(boolean isR1C1, boolean isLocal)Gets the formula of this list column.
getCustomTotalsRowFormula(boolean isR1C1, boolean 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 the formula of the list column.
getName()Gets the name of the column.
getRange()Gets the range of this list column.
getTotalsCalculation()Gets the type of calculation in the Totals row of the list column.
getTotalsRowLabel()Gets the display labels of total row.
hashCode()
notify()
notifyAll()
setCustomCalculatedFormula(String formula, boolean isR1C1, boolean isLocal)Sets the formula for this list column.
setCustomTotalsRowFormula(String formula, boolean isR1C1, boolean isLocal)Gets the formula of totals row of this list column.
setDataStyle(Style style)Sets the style of the data in this column of the table.
setFormula(String value)Sets the formula of the list column.
setName(String value)Sets the name of the column.
setTotalsCalculation(int value)Sets the type of calculation in the Totals row of the list column.
setTotalsRowLabel(String value)Sets the display labels of total row.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getCustomCalculatedFormula(boolean isR1C1, boolean isLocal)

public String getCustomCalculatedFormula(boolean isR1C1, boolean isLocal)

Gets the formula of this list column.

Parameters:

ParameterTypeDescription
isR1C1booleanWhether the formula needs to be formatted as R1C1.
isLocalbooleanWhether the formula needs to be formatted by locale.

Returns: java.lang.String - The formula of this list column.

getCustomTotalsRowFormula(boolean isR1C1, boolean isLocal)

public String getCustomTotalsRowFormula(boolean isR1C1, boolean isLocal)

Gets the formula of totals row of this list column.

Parameters:

ParameterTypeDescription
isR1C1booleanWhether the formula needs to be formatted as R1C1.
isLocalbooleanWhether the formula needs to be formatted by locale.

Returns: java.lang.String - The formula of this list column.

getDataStyle()

public Style getDataStyle()

Gets the style of the data in this column of the table.

Returns: Style

getFormula()

public String getFormula()

Gets the formula of the list column.

Returns: java.lang.String

getName()

public String getName()

Gets the name of the column.

Remarks

If sets the name of the column, the according cell’ value will be changed too.

Returns: java.lang.String

getRange()

public Range getRange()

Gets the range of this list column.

Returns: Range

getTotalsCalculation()

public int getTotalsCalculation()

Gets the type of calculation in the Totals row of the list column.

See TotalsCalculation.

Returns: int

getTotalsRowLabel()

public String getTotalsRowLabel()

Gets the display labels of total row.

Returns: java.lang.String

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setCustomCalculatedFormula(String formula, boolean isR1C1, boolean isLocal)

public void setCustomCalculatedFormula(String formula, boolean isR1C1, boolean isLocal)

Sets the formula for this list column.

Parameters:

ParameterTypeDescription
formulajava.lang.Stringthe formula for this list column.
isR1C1booleanWhether the formula needs to be formatted as R1C1.
isLocalbooleanWhether the formula needs to be formatted by locale.

setCustomTotalsRowFormula(String formula, boolean isR1C1, boolean isLocal)

public void setCustomTotalsRowFormula(String formula, boolean isR1C1, boolean isLocal)

Gets the formula of totals row of this list column.

Parameters:

ParameterTypeDescription
formulajava.lang.Stringthe formula for this list column.
isR1C1booleanWhether the formula needs to be formatted as R1C1.
isLocalbooleanWhether the formula needs to be formatted by locale.

setDataStyle(Style style)

public void setDataStyle(Style style)

Sets the style of the data in this column of the table.

Parameters:

ParameterTypeDescription
styleStyle

setFormula(String value)

public void setFormula(String value)

Sets the formula of the list column.

Parameters:

ParameterTypeDescription
valuejava.lang.String

setName(String value)

public void setName(String value)

Sets the name of the column.

Remarks

If sets the name of the column, the according cell’ value will be changed too.

Parameters:

ParameterTypeDescription
valuejava.lang.String

setTotalsCalculation(int value)

public void setTotalsCalculation(int value)

Sets the type of calculation in the Totals row of the list column.

See TotalsCalculation.

Parameters:

ParameterTypeDescription
valueint

setTotalsRowLabel(String value)

public void setTotalsRowLabel(String value)

Sets the display labels of total row.

Parameters:

ParameterTypeDescription
valuejava.lang.String

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int