ConditionalFormat class reference

  • Font* font()
    Returns the pointer to the current used font for this conditional format.
  • NumFormat numFormat() const
    Returns the number format identifier.
  • void setNumFormat(NumFormat numFormat)
    Sets the number format identifier. The identifier must be a valid built-in number format identifier:
  • const wchar_t* customNumFormat() const
    Returns a custom format string. See custom format string guidelines.
  • void setCustomNumFormat(const wchar_t* customNumFormat)
    Sets a custom number format. The format string customNumFormat indicates how to format and render the numeric value of a cell. See custom format strings guidelines.
  • void setBorder(BorderStyle style = BORDERSTYLE_THIN)
    Sets the border style.
    BorderStyle valueView
    BORDERSTYLE_NONEBORDERSTYLE_NONE
    BORDERSTYLE_THINBORDERSTYLE_THIN
    BORDERSTYLE_MEDIUMBORDERSTYLE_MEDIUM
    BORDERSTYLE_DASHEDBORDERSTYLE_DASHED
    BORDERSTYLE_DOTTEDBORDERSTYLE_DOTTED
    BORDERSTYLE_THICKBORDERSTYLE_THICK
    BORDERSTYLE_DOUBLEBORDERSTYLE_DOUBLE
    BORDERSTYLE_HAIRBORDERSTYLE_HAIR
    BORDERSTYLE_MEDIUMDASHEDBORDERSTYLE_MEDIUMDASHED
    BORDERSTYLE_DASHDOTBORDERSTYLE_DASHDOT
    BORDERSTYLE_MEDIUMDASHDOTBORDERSTYLE_MEDIUMDASHDOT
    BORDERSTYLE_DASHDOTDOTBORDERSTYLE_DASHDOTDOT
    BORDERSTYLE_MEDIUMDASHDOTDOTBORDERSTYLE_MEDIUMDASHDOTDOT
    BORDERSTYLE_SLANTDASHDOTBORDERSTYLE_SLANTDASHDOT
  • void setBorderColor(Color color)
    Sets the border color.
  • BorderStyle borderLeft() const
    Returns the left border style.
  • void setBorderLeft(BorderStyle style = BORDERSTYLE_THIN)
    Sets the left border style.
  • BorderStyle borderRight() const
    Returns the right border style.
  • void setBorderRight(BorderStyle style = BORDERSTYLE_THIN)
    Sets the right border style.
  • BorderStyle borderTop() const
    Returns the top border style.
  • void setBorderTop(BorderStyle style = BORDERSTYLE_THIN)
    Sets the top border style.
  • BorderStyle borderBottom() const
    Returns the bottom border style.
  • void setBorderBottom(BorderStyle style = BORDERSTYLE_THIN)
    Sets the bottom border style.
  • Color borderLeftColor() const
    Returns the color of the left border.
  • void setBorderLeftColor(Color color)
    Sets the color of the left border.
  • Color borderRightColor() const
    Returns the color of the right border.
  • void setBorderRightColor(Color color)
    Sets the color of the right border.
  • Color borderTopColor() const
    Returns the color of the top border.
  • void setBorderTopColor(Color color)
    Sets the color of the top border.
  • Color borderBottomColor() const
    Returns the color of the bottom border.
  • void setBorderBottomColor(Color color)
    Sets the color of the bottom border.
  • FillPattern fillPattern() const
    Returns the fill pattern.
  • void setFillPattern(FillPattern pattern)
    Sets the fill pattern.
    FillPattern valueView
    FILLPATTERN_NONE
    FILLPATTERN_SOLIDFILLPATTERN_SOLID
    FILLPATTERN_GRAY50FILLPATTERN_GRAY50
    FILLPATTERN_GRAY75FILLPATTERN_GRAY75
    FILLPATTERN_GRAY25FILLPATTERN_GRAY25
    FILLPATTERN_HORSTRIPEFILLPATTERN_HORSTRIPE
    FILLPATTERN_VERSTRIPEFILLPATTERN_VERSTRIPE
    FILLPATTERN_REVDIAGSTRIPEFILLPATTERN_REVDIAGSTRIPE
    FILLPATTERN_DIAGSTRIPEFILLPATTERN_DIAGSTRIPE
    FILLPATTERN_DIAGCROSSHATCHFILLPATTERN_DIAGCROSSHATCH
    FILLPATTERN_THICKDIAGCROSSHATCHFILLPATTERN_THICKDIAGCROSSHATCH
    FILLPATTERN_THINHORSTRIPEFILLPATTERN_THINHORSTRIPE
    FILLPATTERN_THINVERSTRIPEFILLPATTERN_THINVERSTRIPE
    FILLPATTERN_THINREVDIAGSTRIPEFILLPATTERN_THINREVDIAGSTRIPE
    FILLPATTERN_THINDIAGSTRIPEFILLPATTERN_THINDIAGSTRIPE
    FILLPATTERN_THINHORCROSSHATCHFILLPATTERN_THINHORCROSSHATCH
    FILLPATTERN_THINDIAGCROSSHATCHFILLPATTERN_THINDIAGCROSSHATCH
    FILLPATTERN_GRAY12P5FILLPATTERN_GRAY12P5
    FILLPATTERN_GRAY6P25FILLPATTERN_GRAY6P25
  • Color patternForegroundColor() const
    Returns the foreground color of the fill pattern.
  • void setPatternForegroundColor(Color color)
    Sets the foreground color of the fill pattern.
  • Color patternBackgroundColor() const
    Returns the background color of the fill pattern.
  • void setPatternBackgroundColor(Color color)
    Sets the background color of the fill pattern.
Home Index Book Sheet Format Font AutoFilter FilterColumn RichString FormControl ConditionalFormatting ConditionalFormat Examples