Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate


com.aspose.cells
Class ConditionalFormattings

java.lang.Object
  extended by com.aspose.cells.ConditionalFormattings

public class ConditionalFormattings
extends java.lang.Object

Represents all conditional formattings in the worksheet.


Method Summary
 int add()
          Adds an empty FormatConditions object to the ConditionalFormattings.
 int add(CellArea cellArea, int type, int operator, java.lang.String formula1, java.lang.String formula2)
          Adds an FormatConditions object to the ConditionalFormattings.
 void delete(int index)
          Removes FormatConditions object by index.
 FormatConditions get(int index)
          Gets FormatConditions object by index.
 int size()
          Gets number of the FormatConditions objects.
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

add

public int add()
Adds an empty FormatConditions object to the ConditionalFormattings.

Returns:
FormatConditions object index.
Throws:
CellsException - if conditional formattings has been removed.

add

public int add(CellArea cellArea,
               int type,
               int operator,
               java.lang.String formula1,
               java.lang.String formula2)
Adds an FormatConditions object to the ConditionalFormattings.

Parameters:
cellArea - conditional formatted cell range.
type - type of conditinal formatting.
operator - comparison operator.
formula1 - the value or expression associated with conditinal formatting.
formula2 - the value or expression associated with conditinal formatting.
Returns:
FormatConditions object index.
Throws:
CellsException - if conditional formattings has been removed.
See Also:
FormatConditions.addFormatCondition(CellArea, int, int, String, String)

delete

public void delete(int index)
Removes FormatConditions object by index.

Parameters:
index - the index of the FormatConditions object to removed.
Throws:
CellsException - if conditional formattings has been removed.
java.lang.IllegalArgumentException - if index is out of range.

get

public FormatConditions get(int index)
Gets FormatConditions object by index.

Parameters:
index - index of the FormatConditions object to return.
Returns:
the FormatConditions object.
Throws:
CellsException - if conditional formattings has been removed.
java.lang.IllegalArgumentException - if index is out of range.

size

public int size()
Gets number of the FormatConditions objects.

Returns:
number of the FormatConditions objects.
Throws:
CellsException - if conditional formattings has been removed.