CellStyle (Keikai Spreadsheet Build 5.0.0 API)

All Known Subinterfaces:

DxfCellStyle, NamedStyle

All Known Implementing Classes:

HSSFCellStyle, HSSFNamedStyle, XSSFCellStyle, XSSFDxfCellStyle, XSSFNamedStyle
```
public interface CellStyle
```

Field Summary

Fields
Modifier and Type	Field and Description
`static short`	`ALIGN_CENTER` center horizontal alignment
`static short`	`ALIGN_CENTER_SELECTION` center-selection? horizontal alignment
`static short`	`ALIGN_FILL` fill? horizontal alignment
`static short`	`ALIGN_GENERAL` general (normal) horizontal alignment
`static short`	`ALIGN_JUSTIFY` justified horizontal alignment
`static short`	`ALIGN_LEFT` left-justified horizontal alignment
`static short`	`ALIGN_RIGHT` right-justified horizontal alignment
`static short`	`ALT_BARS` Wide dots
`static short`	`BIG_SPOTS` Large spots
`static short`	`BORDER_DASH_DOT` dash-dot border
`static short`	`BORDER_DASH_DOT_DOT` dash-dot-dot border
`static short`	`BORDER_DASHED` dash border
`static short`	`BORDER_DOTTED` dot border
`static short`	`BORDER_DOUBLE` double-line border
`static short`	`BORDER_HAIR` hair-line border
`static short`	`BORDER_MEDIUM` Medium border
`static short`	`BORDER_MEDIUM_DASH_DOT` medium dash-dot border
`static short`	`BORDER_MEDIUM_DASH_DOT_DOT` medium dash-dot-dot border
`static short`	`BORDER_MEDIUM_DASHED` Medium dashed border
`static short`	`BORDER_NONE` No border
`static short`	`BORDER_SLANTED_DASH_DOT` slanted dash-dot border
`static short`	`BORDER_THICK` Thick border
`static short`	`BORDER_THIN` Thin border
`static short`	`BRICKS` Brick-like layout
`static short`	`DIAMONDS` Diamonds
`static short`	`FINE_DOTS` Small fine dots
`static short`	`LEAST_DOTS` Least Dots
`static short`	`LESS_DOTS` Less Dots
`static short`	`NO_FILL` No background
`static short`	`SOLID_FOREGROUND` Solidly filled
`static short`	`SPARSE_DOTS` Sparse dots
`static short`	`SQUARES` Squares
`static short`	`THICK_BACKWARD_DIAG` Thick backward facing diagonals
`static short`	`THICK_FORWARD_DIAG` Thick forward facing diagonals
`static short`	`THICK_HORZ_BANDS` Thick horizontal bands
`static short`	`THICK_VERT_BANDS` Thick vertical bands
`static short`	`THIN_BACKWARD_DIAG` Thin backward diagonal
`static short`	`THIN_FORWARD_DIAG` Thin forward diagonal
`static short`	`THIN_HORZ_BANDS` Thin horizontal bands
`static short`	`THIN_VERT_BANDS` Thin vertical bands
`static short`	`VERTICAL_BOTTOM` bottom-aligned vertical alignment
`static short`	`VERTICAL_CENTER` center-aligned vertical alignment
`static short`	`VERTICAL_JUSTIFY` vertically justified vertical alignment
`static short`	`VERTICAL_TOP` top-aligned vertical alignment

Method Summary

All Methods Instance Methods Abstract Methods Deprecated Methods
Modifier and Type	Method and Description
`void`	`cloneStyleFrom(CellStyle source)` Clones all the style information from another CellStyle, onto this one.
`short`	`getAlignment()` get the type of horizontal alignment for the cell
`short`	`getBorderBottom()` get the type of border to use for the bottom border of the cell
`short`	`getBorderDiagonal()` get the type of border to use for the diagonal border of the cell
`short`	`getBorderLeft()` get the type of border to use for the left border of the cell
`short`	`getBorderRight()` get the type of border to use for the right border of the cell
`short`	`getBorderTop()` get the type of border to use for the top border of the cell
`short`	`getBottomBorderColor()` get the color to use for the left border
`Color`	`getBottomBorderColorColor()`
`short`	`getDataFormat()` get the index of the format
`String`	`getDataFormatString()` Get the format string
`short`	`getDiagonalBorderColor()` get the color to use for the diagonal border
`Color`	`getDiagonalBorderColorColor()`
`short`	`getFillBackgroundColor()` get the background fill color, if the fill is defined with an indexed color.
`Color`	`getFillBackgroundColorColor()` Gets the color object representing the current background fill, resolving indexes using the supplied workbook.
`short`	`getFillForegroundColor()` get the foreground fill color, if the fill is defined with an indexed color.
`Color`	`getFillForegroundColorColor()` Gets the color object representing the current foreground fill, resolving indexes using the supplied workbook.
`short`	`getFillPattern()` get the fill pattern (??) - set to 1 to fill with foreground color
`short`	`getFontIndex()` gets the index of the font for this style
`boolean`	`getHidden()` get whether the cell's using this style are to be hidden
`short`	`getIndention()` get the number of spaces to indent the text in the cell
`int`	`getIndex()` get the index within the Workbook (sequence within the collection of ExtnededFormat objects) Note since 3.9.9 we have changed the return value type from short to int because the limit of distinct cell styles in Excel 2007 and beyond is 64000 while that of Excel 97-2003 is 4000 only; have to extend it to accommodate the capacity.
`short`	`getLeftBorderColor()` get the color to use for the left border
`Color`	`getLeftBorderColorColor()`
`boolean`	`getLocked()` get whether the cell's using this style are to be locked
`String`	`getRawDataFormatString()` Get the raw data format string that are not transfered by ZSS Context Locale
`short`	`getRightBorderColor()` get the color to use for the left border
`Color`	`getRightBorderColorColor()`
`short`	`getRotation()` get the degree of rotation for the text in the cell
`short`	`getTopBorderColor()` get the color to use for the top border
`Color`	`getTopBorderColorColor()`
`short`	`getVerticalAlignment()` get the type of vertical alignment for the cell
`boolean`	`getWrapText()` get whether the text should be wrapped
`boolean`	`isBuiltinDataFormat()` Check if the data format is build in format
`boolean`	`isShowDiagonalDownBorder()` Whether show diagonalDown diagonal border
`boolean`	`isShowDiagonalUpBorder()` Whether show diagonalUp diagonal border
`void`	`setAlignment(short align)` set the type of horizontal alignment for the cell
`void`	`setBorder(short left, Color leftColor, short top, Color topColor, short right, Color rightColor, short bottom, Color bottomColor)`
`void`	`setBorder(short left, Color leftColor, short top, Color topColor, short right, Color rightColor, short bottom, Color bottomColor, short diagonal, Color diagonalColor, short horizontal, Color horizontalColor, short vertical, Color verticalColor, boolean diaUp, boolean diaDown)`
`void`	`setBorderBottom(short border)` set the type of border to use for the bottom border of the cell
`void`	`setBorderDiagonal(short border)` set the type of border to use for the diagonal border of the cell
`void`	`setBorderLeft(short border)` set the type of border to use for the left border of the cell
`void`	`setBorderRight(short border)` set the type of border to use for the right border of the cell
`void`	`setBorderTop(short border)` set the type of border to use for the top border of the cell
`void`	`setBottomBorderColor(short color)` set the color to use for the bottom border
`void`	`setCellAlignment(short hAlign, short vAlign, boolean wrapText)` Deprecated.
`void`	`setCellAlignment(short hAlign, short vAlign, boolean wrapText, short rotation)`
`void`	`setDataFormat(short fmt)` set the data format (must be a valid format)
`void`	`setDiagonalBorderColor(short color)` set the color to use for the diagonal border
`void`	`setFill(Color fillColor, Color backColor, short pattern)`
`void`	`setFillBackgroundColor(short bg)` set the background fill color.
`void`	`setFillForegroundColor(short bg)` set the foreground fill color Note: Ensure Foreground color is set prior to background color.
`void`	`setFillPattern(short fp)` setting to one fills the cell with the foreground color...
`void`	`setFont(Font font)` set the font for this style
`void`	`setFontColorColor(Color fontColor)`
`void`	`setHidden(boolean hidden)` set the cell's using this style to be hidden
`void`	`setIndention(short indent)` set the number of spaces to indent the text in the cell
`void`	`setLeftBorderColor(short color)` set the color to use for the left border
`void`	`setLocked(boolean locked)` set the cell's using this style to be locked
`void`	`setProtection(boolean locked, boolean hidden)`
`void`	`setRightBorderColor(short color)` set the color to use for the right border
`void`	`setRotation(short rotation)` set the degree of rotation for the text in the cell
`void`	`setShowDiagonalDownBorder(boolean down)` Whether show diagonalDown diagonal border
`void`	`setShowDiagonalUpBorder(boolean up)` Whether show diagonalUp diagonal border
`void`	`setTopBorderColor(short color)` set the color to use for the top border
`void`	`setVerticalAlignment(short align)` set the type of vertical alignment for the cell
`void`	`setWrapText(boolean wrapped)` Set whether the text should be wrapped.

- Field Detail
  - ALIGN_GENERAL
```
static final short ALIGN_GENERAL
```
    general (normal) horizontal alignment
    
    See Also:
    
    Constant Field Values
  - ALIGN_LEFT
```
static final short ALIGN_LEFT
```
    left-justified horizontal alignment
    
    See Also:
    
    Constant Field Values
  - ALIGN_CENTER
```
static final short ALIGN_CENTER
```
    center horizontal alignment
    
    See Also:
    
    Constant Field Values
  - ALIGN_RIGHT
```
static final short ALIGN_RIGHT
```
    right-justified horizontal alignment
    
    See Also:
    
    Constant Field Values
  - ALIGN_FILL
```
static final short ALIGN_FILL
```
    fill? horizontal alignment
    
    See Also:
    
    Constant Field Values
  - ALIGN_JUSTIFY
```
static final short ALIGN_JUSTIFY
```
    justified horizontal alignment
    
    See Also:
    
    Constant Field Values
  - ALIGN_CENTER_SELECTION
```
static final short ALIGN_CENTER_SELECTION
```
    center-selection? horizontal alignment
    
    See Also:
    
    Constant Field Values
  - VERTICAL_TOP
```
static final short VERTICAL_TOP
```
    top-aligned vertical alignment
    
    See Also:
    
    Constant Field Values
  - VERTICAL_CENTER
```
static final short VERTICAL_CENTER
```
    center-aligned vertical alignment
    
    See Also:
    
    Constant Field Values
  - VERTICAL_BOTTOM
```
static final short VERTICAL_BOTTOM
```
    bottom-aligned vertical alignment
    
    See Also:
    
    Constant Field Values
  - VERTICAL_JUSTIFY
```
static final short VERTICAL_JUSTIFY
```
    vertically justified vertical alignment
    
    See Also:
    
    Constant Field Values
  - BORDER_NONE
```
static final short BORDER_NONE
```
    No border
    
    See Also:
    
    Constant Field Values
  - BORDER_THIN
```
static final short BORDER_THIN
```
    Thin border
    
    See Also:
    
    Constant Field Values
  - BORDER_MEDIUM
```
static final short BORDER_MEDIUM
```
    Medium border
    
    See Also:
    
    Constant Field Values
  - BORDER_DASHED
```
static final short BORDER_DASHED
```
    dash border
    
    See Also:
    
    Constant Field Values
  - BORDER_DOTTED
```
static final short BORDER_DOTTED
```
    dot border
    
    See Also:
    
    Constant Field Values
  - BORDER_THICK
```
static final short BORDER_THICK
```
    Thick border
    
    See Also:
    
    Constant Field Values
  - BORDER_DOUBLE
```
static final short BORDER_DOUBLE
```
    double-line border
    
    See Also:
    
    Constant Field Values
  - BORDER_HAIR
```
static final short BORDER_HAIR
```
    hair-line border
    
    See Also:
    
    Constant Field Values
  - BORDER_MEDIUM_DASHED
```
static final short BORDER_MEDIUM_DASHED
```
    Medium dashed border
    
    See Also:
    
    Constant Field Values
  - BORDER_DASH_DOT
```
static final short BORDER_DASH_DOT
```
    dash-dot border
    
    See Also:
    
    Constant Field Values
  - BORDER_MEDIUM_DASH_DOT
```
static final short BORDER_MEDIUM_DASH_DOT
```
    medium dash-dot border
    
    See Also:
    
    Constant Field Values
  - BORDER_DASH_DOT_DOT
```
static final short BORDER_DASH_DOT_DOT
```
    dash-dot-dot border
    
    See Also:
    
    Constant Field Values
  - BORDER_MEDIUM_DASH_DOT_DOT
```
static final short BORDER_MEDIUM_DASH_DOT_DOT
```
    medium dash-dot-dot border
    
    See Also:
    
    Constant Field Values
  - BORDER_SLANTED_DASH_DOT
```
static final short BORDER_SLANTED_DASH_DOT
```
    slanted dash-dot border
    
    See Also:
    
    Constant Field Values
  - NO_FILL
```
static final short NO_FILL
```
    No background
    
    See Also:
    
    Constant Field Values
  - SOLID_FOREGROUND
```
static final short SOLID_FOREGROUND
```
    Solidly filled
    
    See Also:
    
    Constant Field Values
  - FINE_DOTS
```
static final short FINE_DOTS
```
    Small fine dots
    
    See Also:
    
    Constant Field Values
  - ALT_BARS
```
static final short ALT_BARS
```
    Wide dots
    
    See Also:
    
    Constant Field Values
  - SPARSE_DOTS
```
static final short SPARSE_DOTS
```
    Sparse dots
    
    See Also:
    
    Constant Field Values
  - THICK_HORZ_BANDS
```
static final short THICK_HORZ_BANDS
```
    Thick horizontal bands
    
    See Also:
    
    Constant Field Values
  - THICK_VERT_BANDS
```
static final short THICK_VERT_BANDS
```
    Thick vertical bands
    
    See Also:
    
    Constant Field Values
  - THICK_BACKWARD_DIAG
```
static final short THICK_BACKWARD_DIAG
```
    Thick backward facing diagonals
    
    See Also:
    
    Constant Field Values
  - THICK_FORWARD_DIAG
```
static final short THICK_FORWARD_DIAG
```
    Thick forward facing diagonals
    
    See Also:
    
    Constant Field Values
  - BIG_SPOTS
```
static final short BIG_SPOTS
```
    Large spots
    
    See Also:
    
    Constant Field Values
  - BRICKS
```
static final short BRICKS
```
    Brick-like layout
    
    See Also:
    
    Constant Field Values
  - THIN_HORZ_BANDS
```
static final short THIN_HORZ_BANDS
```
    Thin horizontal bands
    
    See Also:
    
    Constant Field Values
  - THIN_VERT_BANDS
```
static final short THIN_VERT_BANDS
```
    Thin vertical bands
    
    See Also:
    
    Constant Field Values
  - THIN_BACKWARD_DIAG
```
static final short THIN_BACKWARD_DIAG
```
    Thin backward diagonal
    
    See Also:
    
    Constant Field Values
  - THIN_FORWARD_DIAG
```
static final short THIN_FORWARD_DIAG
```
    Thin forward diagonal
    
    See Also:
    
    Constant Field Values
  - SQUARES
```
static final short SQUARES
```
    Squares
    
    See Also:
    
    Constant Field Values
  - DIAMONDS
```
static final short DIAMONDS
```
    Diamonds
    
    See Also:
    
    Constant Field Values
  - LESS_DOTS
```
static final short LESS_DOTS
```
    Less Dots
    
    See Also:
    
    Constant Field Values
  - LEAST_DOTS
```
static final short LEAST_DOTS
```
    Least Dots
    
    See Also:
    
    Constant Field Values
- Method Detail
  - getIndex
```
int getIndex()
```
    get the index within the Workbook (sequence within the collection of ExtnededFormat objects) Note since 3.9.9 we have changed the return value type from short to int because the limit of distinct cell styles in Excel 2007 and beyond is 64000 while that of Excel 97-2003 is 4000 only; have to extend it to accommodate the capacity.
    
    Returns:
    
    unique index number of the underlying record this style represents (probably you don't care unless you're comparing which one is which)
    
    Since:
    
    3.9.9
  - setDataFormat
```
void setDataFormat(short fmt)
```
    set the data format (must be a valid format)
    
    See Also:
    
    DataFormat
  - getDataFormat
```
short getDataFormat()
```
    get the index of the format
    
    See Also:
    
    DataFormat
  - getDataFormatString
```
String getDataFormatString()
```
    Get the format string
  - getRawDataFormatString
```
String getRawDataFormatString()
```
    Get the raw data format string that are not transfered by ZSS Context Locale
    
    Returns:
  - isBuiltinDataFormat
```
boolean isBuiltinDataFormat()
```
    Check if the data format is build in format
    
    Returns:
  - setFont
```
void setFont(Font font)
```
    set the font for this style
    
    Parameters:
    
    font - a font object created or retreived from the Workbook object
    
    See Also:
    
    Workbook.createFont(), Workbook.getFontAt(short)
  - getFontIndex
```
short getFontIndex()
```
    gets the index of the font for this style
    
    See Also:
    
    Workbook.getFontAt(short)
  - setHidden
```
void setHidden(boolean hidden)
```
    set the cell's using this style to be hidden
    
    Parameters:
    
    hidden - - whether the cell using this style should be hidden
  - getHidden
```
boolean getHidden()
```
    get whether the cell's using this style are to be hidden
    
    Returns:
    
    hidden - whether the cell using this style should be hidden
  - setLocked
```
void setLocked(boolean locked)
```
    set the cell's using this style to be locked
    
    Parameters:
    
    locked - - whether the cell using this style should be locked
  - getLocked
```
boolean getLocked()
```
    get whether the cell's using this style are to be locked
    
    Returns:
    
    hidden - whether the cell using this style should be locked
  - setAlignment
```
void setAlignment(short align)
```
    set the type of horizontal alignment for the cell
    
    Parameters:
    
    align - - the type of alignment
    
    See Also:
    
    ALIGN_GENERAL, ALIGN_LEFT, ALIGN_CENTER, ALIGN_RIGHT, ALIGN_FILL, ALIGN_JUSTIFY, ALIGN_CENTER_SELECTION
  - getAlignment
```
short getAlignment()
```
    get the type of horizontal alignment for the cell
    
    Returns:
    
    align - the type of alignment
    
    See Also:
    
    ALIGN_GENERAL, ALIGN_LEFT, ALIGN_CENTER, ALIGN_RIGHT, ALIGN_FILL, ALIGN_JUSTIFY, ALIGN_CENTER_SELECTION
  - setWrapText
```
void setWrapText(boolean wrapped)
```
    Set whether the text should be wrapped. Setting this flag to true make all content visible whithin a cell by displaying it on multiple lines
    
    Parameters:
    
    wrapped - wrap text or not
  - getWrapText
```
boolean getWrapText()
```
    get whether the text should be wrapped
    
    Returns:
    
    wrap text or not
  - setVerticalAlignment
```
void setVerticalAlignment(short align)
```
    set the type of vertical alignment for the cell
    
    Parameters:
    
    align - the type of alignment
    
    See Also:
    
    VERTICAL_TOP, VERTICAL_CENTER, VERTICAL_BOTTOM, VERTICAL_JUSTIFY
  - getVerticalAlignment
```
short getVerticalAlignment()
```
    get the type of vertical alignment for the cell
    
    Returns:
    
    align the type of alignment
    
    See Also:
    
    VERTICAL_TOP, VERTICAL_CENTER, VERTICAL_BOTTOM, VERTICAL_JUSTIFY
  - setRotation
```
void setRotation(short rotation)
```
    set the degree of rotation for the text in the cell
    
    Parameters:
    
    rotation - degrees (between -90 and 90 degrees)
  - getRotation
```
short getRotation()
```
    get the degree of rotation for the text in the cell
    
    Returns:
    
    rotation degrees (between -90 and 90 degrees)
  - setIndention
```
void setIndention(short indent)
```
    set the number of spaces to indent the text in the cell
    
    Parameters:
    
    indent - - number of spaces
  - getIndention
```
short getIndention()
```
    get the number of spaces to indent the text in the cell
    
    Returns:
    
    indent - number of spaces
  - setBorderLeft
```
void setBorderLeft(short border)
```
    set the type of border to use for the left border of the cell
    
    Parameters:
    
    border - type
    
    See Also:
    
    BORDER_NONE, BORDER_THIN, BORDER_MEDIUM, BORDER_DASHED, BORDER_DOTTED, BORDER_THICK, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM_DASHED, BORDER_DASH_DOT, BORDER_MEDIUM_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_SLANTED_DASH_DOT
  - getBorderLeft
```
short getBorderLeft()
```
    get the type of border to use for the left border of the cell
    
    Returns:
    
    border type
    
    See Also:
    
    BORDER_NONE, BORDER_THIN, BORDER_MEDIUM, BORDER_DASHED, BORDER_DOTTED, BORDER_THICK, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM_DASHED, BORDER_DASH_DOT, BORDER_MEDIUM_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_SLANTED_DASH_DOT
  - setBorderRight
```
void setBorderRight(short border)
```
    set the type of border to use for the right border of the cell
    
    Parameters:
    
    border - type
    
    See Also:
    
    BORDER_NONE, BORDER_THIN, BORDER_MEDIUM, BORDER_DASHED, BORDER_DOTTED, BORDER_THICK, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM_DASHED, BORDER_DASH_DOT, BORDER_MEDIUM_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_SLANTED_DASH_DOT
  - getBorderRight
```
short getBorderRight()
```
    get the type of border to use for the right border of the cell
    
    Returns:
    
    border type
    
    See Also:
    
    BORDER_NONE, BORDER_THIN, BORDER_MEDIUM, BORDER_DASHED, BORDER_DOTTED, BORDER_THICK, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM_DASHED, BORDER_DASH_DOT, BORDER_MEDIUM_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_SLANTED_DASH_DOT
  - setBorderTop
```
void setBorderTop(short border)
```
    set the type of border to use for the top border of the cell
    
    Parameters:
    
    border - type
    
    See Also:
    
    BORDER_NONE, BORDER_THIN, BORDER_MEDIUM, BORDER_DASHED, BORDER_DOTTED, BORDER_THICK, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM_DASHED, BORDER_DASH_DOT, BORDER_MEDIUM_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_SLANTED_DASH_DOT
  - getBorderTop
```
short getBorderTop()
```
    get the type of border to use for the top border of the cell
    
    Returns:
    
    border type
    
    See Also:
    
    BORDER_NONE, BORDER_THIN, BORDER_MEDIUM, BORDER_DASHED, BORDER_DOTTED, BORDER_THICK, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM_DASHED, BORDER_DASH_DOT, BORDER_MEDIUM_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_SLANTED_DASH_DOT
  - setBorderBottom
```
void setBorderBottom(short border)
```
    set the type of border to use for the bottom border of the cell
    
    Parameters:
    
    border - type
    
    See Also:
    
    BORDER_NONE, BORDER_THIN, BORDER_MEDIUM, BORDER_DASHED, BORDER_DOTTED, BORDER_THICK, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM_DASHED, BORDER_DASH_DOT, BORDER_MEDIUM_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_SLANTED_DASH_DOT
  - getBorderBottom
```
short getBorderBottom()
```
    get the type of border to use for the bottom border of the cell
    
    Returns:
    
    border type
    
    See Also:
    
    BORDER_NONE, BORDER_THIN, BORDER_MEDIUM, BORDER_DASHED, BORDER_DOTTED, BORDER_THICK, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM_DASHED, BORDER_DASH_DOT, BORDER_MEDIUM_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_SLANTED_DASH_DOT
  - setLeftBorderColor
```
void setLeftBorderColor(short color)
```
    set the color to use for the left border
    
    Parameters:
    
    color - The index of the color definition
  - getLeftBorderColor
```
short getLeftBorderColor()
```
    get the color to use for the left border
  - setRightBorderColor
```
void setRightBorderColor(short color)
```
    set the color to use for the right border
    
    Parameters:
    
    color - The index of the color definition
  - getRightBorderColor
```
short getRightBorderColor()
```
    get the color to use for the left border
    
    Returns:
    
    the index of the color definition
  - setTopBorderColor
```
void setTopBorderColor(short color)
```
    set the color to use for the top border
    
    Parameters:
    
    color - The index of the color definition
  - getTopBorderColor
```
short getTopBorderColor()
```
    get the color to use for the top border
    
    Returns:
    
    hhe index of the color definition
  - setBottomBorderColor
```
void setBottomBorderColor(short color)
```
    set the color to use for the bottom border
    
    Parameters:
    
    color - The index of the color definition
  - getBottomBorderColor
```
short getBottomBorderColor()
```
    get the color to use for the left border
    
    Returns:
    
    the index of the color definition
  - setFillPattern
```
void setFillPattern(short fp)
```
    setting to one fills the cell with the foreground color... No idea about other values
    
    Parameters:
    
    fp - fill pattern (set to 1 to fill w/foreground color)
    
    See Also:
    
    NO_FILL, SOLID_FOREGROUND, FINE_DOTS, ALT_BARS, SPARSE_DOTS, THICK_HORZ_BANDS, THICK_VERT_BANDS, THICK_BACKWARD_DIAG, THICK_FORWARD_DIAG, BIG_SPOTS, BRICKS, THIN_HORZ_BANDS, THIN_VERT_BANDS, THIN_BACKWARD_DIAG, THIN_FORWARD_DIAG, SQUARES, DIAMONDS
  - getFillPattern
```
short getFillPattern()
```
    get the fill pattern (??) - set to 1 to fill with foreground color
    
    Returns:
    
    fill pattern
  - setFillBackgroundColor
```
void setFillBackgroundColor(short bg)
```
    set the background fill color.
    
    Parameters:
    
    bg - color
  - getFillBackgroundColor
```
short getFillBackgroundColor()
```
    get the background fill color, if the fill is defined with an indexed color.
    
    Returns:
    
    fill color index, or 0 if not indexed (XSSF only)
  - getFillBackgroundColorColor
```
Color getFillBackgroundColorColor()
```
    Gets the color object representing the current background fill, resolving indexes using the supplied workbook. This will work for both indexed and rgb defined colors.
  - setFillForegroundColor
```
void setFillForegroundColor(short bg)
```
    set the foreground fill color Note: Ensure Foreground color is set prior to background color.
    
    Parameters:
    
    bg - color
  - getFillForegroundColor
```
short getFillForegroundColor()
```
    get the foreground fill color, if the fill is defined with an indexed color.
    
    Returns:
    
    fill color, or 0 if not indexed (XSSF only)
  - getFillForegroundColorColor
```
Color getFillForegroundColorColor()
```
    Gets the color object representing the current foreground fill, resolving indexes using the supplied workbook. This will work for both indexed and rgb defined colors.
  - cloneStyleFrom
```
void cloneStyleFrom(CellStyle source)
```
    Clones all the style information from another CellStyle, onto this one. This CellStyle will then have all the same properties as the source, but the two may be edited independently. Any stylings on this CellStyle will be lost! The source CellStyle could be from another Workbook if you like. This allows you to copy styles from one Workbook to another. However, both of the CellStyles will need to be of the same type (HSSFCellStyle or XSSFCellStyle)
  - getTopBorderColorColor
```
Color getTopBorderColorColor()
```
  - getBottomBorderColorColor
```
Color getBottomBorderColorColor()
```
  - getRightBorderColorColor
```
Color getRightBorderColorColor()
```
  - getLeftBorderColorColor
```
Color getLeftBorderColorColor()
```
  - setFontColorColor
```
void setFontColorColor(Color fontColor)
```
  - setBorder
```
void setBorder(short left,
               Color leftColor,
               short top,
               Color topColor,
               short right,
               Color rightColor,
               short bottom,
               Color bottomColor)
```
  - setBorder
```
void setBorder(short left,
               Color leftColor,
               short top,
               Color topColor,
               short right,
               Color rightColor,
               short bottom,
               Color bottomColor,
               short diagonal,
               Color diagonalColor,
               short horizontal,
               Color horizontalColor,
               short vertical,
               Color verticalColor,
               boolean diaUp,
               boolean diaDown)
```
  - setFill
```
void setFill(Color fillColor,
             Color backColor,
             short pattern)
```
  - setCellAlignment
```
@Deprecated
void setCellAlignment(short hAlign,
                                  short vAlign,
                                  boolean wrapText)
```
    Deprecated.
  - setCellAlignment
```
void setCellAlignment(short hAlign,
                      short vAlign,
                      boolean wrapText,
                      short rotation)
```
  - setProtection
```
void setProtection(boolean locked,
                   boolean hidden)
```
  - setBorderDiagonal
```
void setBorderDiagonal(short border)
```
    set the type of border to use for the diagonal border of the cell
    
    Parameters:
    
    border - type
    
    Since:
    
    3.9.5
    
    See Also:
    
    BORDER_NONE, BORDER_THIN, BORDER_MEDIUM, BORDER_DASHED, BORDER_DOTTED, BORDER_THICK, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM_DASHED, BORDER_DASH_DOT, BORDER_MEDIUM_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_SLANTED_DASH_DOT
  - getBorderDiagonal
```
short getBorderDiagonal()
```
    get the type of border to use for the diagonal border of the cell
    
    Returns:
    
    border type
    
    Since:
    
    3.9.6
    
    See Also:
    
    BORDER_NONE, BORDER_THIN, BORDER_MEDIUM, BORDER_DASHED, BORDER_DOTTED, BORDER_THICK, BORDER_DOUBLE, BORDER_HAIR, BORDER_MEDIUM_DASHED, BORDER_DASH_DOT, BORDER_MEDIUM_DASH_DOT, BORDER_DASH_DOT_DOT, BORDER_MEDIUM_DASH_DOT_DOT, BORDER_SLANTED_DASH_DOT
  - getDiagonalBorderColorColor
```
Color getDiagonalBorderColorColor()
```
    Returns:
    
    Since:
    
    3.9.6
  - setDiagonalBorderColor
```
void setDiagonalBorderColor(short color)
```
    set the color to use for the diagonal border
    
    Parameters:
    
    color - The index of the color definition
    
    Since:
    
    3.9.6
  - getDiagonalBorderColor
```
short getDiagonalBorderColor()
```
    get the color to use for the diagonal border
    
    Since:
    
    3.9.6
  - isShowDiagonalUpBorder
```
boolean isShowDiagonalUpBorder()
```
    Whether show diagonalUp diagonal border
    
    Returns:
    
    Since:
    
    3.9.6
  - setShowDiagonalUpBorder
```
void setShowDiagonalUpBorder(boolean up)
```
    Whether show diagonalUp diagonal border
    
    Since:
    
    3.9.6
  - isShowDiagonalDownBorder
```
boolean isShowDiagonalDownBorder()
```
    Whether show diagonalDown diagonal border
    
    Returns:
    
    Since:
    
    3.9.6
  - setShowDiagonalDownBorder
```
void setShowDiagonalDownBorder(boolean down)
```
    Whether show diagonalDown diagonal border
    
    Since:
    
    3.9.6

Interface CellStyle

Field Summary

Method Summary

Field Detail

ALIGN_GENERAL

ALIGN_LEFT

ALIGN_CENTER

ALIGN_RIGHT

ALIGN_FILL

ALIGN_JUSTIFY

ALIGN_CENTER_SELECTION

VERTICAL_TOP

VERTICAL_CENTER

VERTICAL_BOTTOM

VERTICAL_JUSTIFY

BORDER_NONE

BORDER_THIN

BORDER_MEDIUM

BORDER_DASHED

BORDER_DOTTED

BORDER_THICK

BORDER_DOUBLE

BORDER_HAIR

BORDER_MEDIUM_DASHED

BORDER_DASH_DOT

BORDER_MEDIUM_DASH_DOT

BORDER_DASH_DOT_DOT

BORDER_MEDIUM_DASH_DOT_DOT

BORDER_SLANTED_DASH_DOT

NO_FILL

SOLID_FOREGROUND

FINE_DOTS

ALT_BARS

SPARSE_DOTS

THICK_HORZ_BANDS

THICK_VERT_BANDS

THICK_BACKWARD_DIAG

THICK_FORWARD_DIAG

BIG_SPOTS

BRICKS

THIN_HORZ_BANDS

THIN_VERT_BANDS

THIN_BACKWARD_DIAG

THIN_FORWARD_DIAG

SQUARES

DIAMONDS

LESS_DOTS

LEAST_DOTS

Method Detail

getIndex

setDataFormat

getDataFormat

getDataFormatString

getRawDataFormatString

isBuiltinDataFormat

setFont

getFontIndex

setHidden

getHidden

setLocked

getLocked

setAlignment

getAlignment

setWrapText

getWrapText

setVerticalAlignment

getVerticalAlignment

setRotation

getRotation

setIndention

getIndention

setBorderLeft

getBorderLeft

setBorderRight

getBorderRight

setBorderTop

getBorderTop

setBorderBottom

getBorderBottom

setLeftBorderColor