Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

## org.apache.poi.xssf.usermodel
Class XSSFConditionalFormattingThreshold

    java.lang.Object
      org.apache.poi.xssf.usermodel.XSSFConditionalFormattingThreshold

All Implemented Interfaces:
  ConditionalFormattingThreshold

    public class XSSFConditionalFormattingThreshold

extends java.lang.Object
implements ConditionalFormattingThreshold

High level representation for Icon / Multi-State / Databar / Colour Scale change thresholds

Nested Class Summary

Nested classes/interfaces inherited from interface org.apache.poi.ss.usermodel.ConditionalFormattingThreshold
`ConditionalFormattingThreshold.RangeType`

Constructor Summary
`protected` | `XSSFConditionalFormattingThreshold(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvo cfvo)`

Method Summary
`protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvo` | `getCTCfvo()`
`java.lang.String` | `getFormula()` Formula to use to calculate the threshold, or `null` if no formula
`ConditionalFormattingThreshold.RangeType` | `getRangeType()` Get the Range Type used
`java.lang.Double` | `getValue()` Gets the value used for the threshold, or `null` if there isn't one.
`void` | `setFormula(java.lang.String formula)` Sets the formula used to calculate the threshold, or unsets it if `null` is given.
`void` | `setRangeType(ConditionalFormattingThreshold.RangeType type)` Changes the Range Type used
`void` | `setValue(java.lang.Double value)` Sets the value used for the threshold.

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Constructor Detail

### XSSFConditionalFormattingThreshold

    protected XSSFConditionalFormattingThreshold(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvo cfvo)

Method Detail

### getCTCfvo

    protected org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfvo getCTCfvo()

### getRangeType

    public ConditionalFormattingThreshold.RangeType getRangeType()

  Description copied from interface: `ConditionalFormattingThreshold`
  Get the Range Type used

  Specified by:
    `getRangeType` in interface `ConditionalFormattingThreshold`

### setRangeType

    public void setRangeType(ConditionalFormattingThreshold.RangeType type)

  Description copied from interface: `ConditionalFormattingThreshold`
  Changes the Range Type used

  If you change the range type, you need to ensure that the Formula and Value parameters are compatible with it before saving

  Specified by:
    `setRangeType` in interface `ConditionalFormattingThreshold`

### getFormula

    public java.lang.String getFormula()

  Description copied from interface: `ConditionalFormattingThreshold`
  Formula to use to calculate the threshold, or `null` if no formula

  Specified by:
    `getFormula` in interface `ConditionalFormattingThreshold`

### setFormula

    public void setFormula(java.lang.String formula)

  Description copied from interface: `ConditionalFormattingThreshold`
  Sets the formula used to calculate the threshold, or unsets it if `null` is given.

  Specified by:
    `setFormula` in interface `ConditionalFormattingThreshold`

### getValue

    public java.lang.Double getValue()

  Description copied from interface: `ConditionalFormattingThreshold`
  Gets the value used for the threshold, or `null` if there isn't one.

  Specified by:
    `getValue` in interface `ConditionalFormattingThreshold`

### setValue

    public void setValue(java.lang.Double value)

  Description copied from interface: `ConditionalFormattingThreshold`
  Sets the value used for the threshold.

  If the type is `ConditionalFormattingThreshold.RangeType.PERCENT` or `ConditionalFormattingThreshold.RangeType.PERCENTILE` it must be between 0 and 100.

  If the type is `ConditionalFormattingThreshold.RangeType.MIN` or `ConditionalFormattingThreshold.RangeType.MAX` or `ConditionalFormattingThreshold.RangeType.FORMULA` it shouldn't be set.

  Use `null` to unset

  Specified by:
    `setValue` in interface `ConditionalFormattingThreshold`

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV CLASS NEXT CLASS | FRAMES NO FRAMES
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.