|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface CellStyle
Field Summary | |
---|---|
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
hair-line border |
static short |
BORDER_DOUBLE
double-line border |
static short |
BORDER_HAIR
dot 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 | |
---|---|
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 |
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 |
short |
getDataFormat()
get the index of the format |
java.lang.String |
getDataFormatString()
Get the format string |
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 |
short |
getIndex()
get the index within the Workbook (sequence within the collection of ExtnededFormat objects) |
short |
getLeftBorderColor()
get the color to use for the left border |
boolean |
getLocked()
get whether the cell's using this style are to be locked |
short |
getRightBorderColor()
get the color to use for the left border |
short |
getRotation()
get the degree of rotation for the text in the cell |
short |
getTopBorderColor()
get the color to use for the top border |
short |
getVerticalAlignment()
get the type of vertical alignment for the cell |
boolean |
getWrapText()
get whether the text should be wrapped |
void |
setAlignment(short align)
set the type of horizontal alignment for the cell |
void |
setBorderBottom(short border)
set the type of border to use for the bottom 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 |
setDataFormat(short fmt)
set the data format (must be a valid format) |
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 |
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 |
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 |
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 |
---|
static final short ALIGN_GENERAL
static final short ALIGN_LEFT
static final short ALIGN_CENTER
static final short ALIGN_RIGHT
static final short ALIGN_FILL
static final short ALIGN_JUSTIFY
static final short ALIGN_CENTER_SELECTION
static final short VERTICAL_TOP
static final short VERTICAL_CENTER
static final short VERTICAL_BOTTOM
static final short VERTICAL_JUSTIFY
static final short BORDER_NONE
static final short BORDER_THIN
static final short BORDER_MEDIUM
static final short BORDER_DASHED
static final short BORDER_HAIR
static final short BORDER_THICK
static final short BORDER_DOUBLE
static final short BORDER_DOTTED
static final short BORDER_MEDIUM_DASHED
static final short BORDER_DASH_DOT
static final short BORDER_MEDIUM_DASH_DOT
static final short BORDER_DASH_DOT_DOT
static final short BORDER_MEDIUM_DASH_DOT_DOT
static final short BORDER_SLANTED_DASH_DOT
static final short NO_FILL
static final short SOLID_FOREGROUND
static final short FINE_DOTS
static final short ALT_BARS
static final short SPARSE_DOTS
static final short THICK_HORZ_BANDS
static final short THICK_VERT_BANDS
static final short THICK_BACKWARD_DIAG
static final short THICK_FORWARD_DIAG
static final short BIG_SPOTS
static final short BRICKS
static final short THIN_HORZ_BANDS
static final short THIN_VERT_BANDS
static final short THIN_BACKWARD_DIAG
static final short THIN_FORWARD_DIAG
static final short SQUARES
static final short DIAMONDS
static final short LESS_DOTS
static final short LEAST_DOTS
Method Detail |
---|
short getIndex()
void setDataFormat(short fmt)
DataFormat
short getDataFormat()
DataFormat
java.lang.String getDataFormatString()
void setFont(Font font)
font
- a font object created or retreived from the Workbook objectWorkbook.createFont()
,
Workbook.getFontAt(short)
short getFontIndex()
Workbook.getFontAt(short)
void setHidden(boolean hidden)
hidden
- - whether the cell using this style should be hiddenboolean getHidden()
void setLocked(boolean locked)
locked
- - whether the cell using this style should be lockedboolean getLocked()
void setAlignment(short align)
align
- - the type of alignmentALIGN_GENERAL
,
ALIGN_LEFT
,
ALIGN_CENTER
,
ALIGN_RIGHT
,
ALIGN_FILL
,
ALIGN_JUSTIFY
,
ALIGN_CENTER_SELECTION
short getAlignment()
ALIGN_GENERAL
,
ALIGN_LEFT
,
ALIGN_CENTER
,
ALIGN_RIGHT
,
ALIGN_FILL
,
ALIGN_JUSTIFY
,
ALIGN_CENTER_SELECTION
void setWrapText(boolean wrapped)
true
make all content visible
whithin a cell by displaying it on multiple lines
wrapped
- wrap text or notboolean getWrapText()
void setVerticalAlignment(short align)
align
- the type of alignmentVERTICAL_TOP
,
VERTICAL_CENTER
,
VERTICAL_BOTTOM
,
VERTICAL_JUSTIFY
short getVerticalAlignment()
VERTICAL_TOP
,
VERTICAL_CENTER
,
VERTICAL_BOTTOM
,
VERTICAL_JUSTIFY
void setRotation(short rotation)
rotation
- degrees (between -90 and 90 degrees)short getRotation()
void setIndention(short indent)
indent
- - number of spacesshort getIndention()
void setBorderLeft(short border)
border
- typeBORDER_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
short getBorderLeft()
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
void setBorderRight(short border)
border
- typeBORDER_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
short getBorderRight()
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
void setBorderTop(short border)
border
- typeBORDER_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
short getBorderTop()
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
void setBorderBottom(short border)
border
- typeBORDER_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
short getBorderBottom()
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
void setLeftBorderColor(short color)
color
- The index of the color definitionshort getLeftBorderColor()
void setRightBorderColor(short color)
color
- The index of the color definitionshort getRightBorderColor()
void setTopBorderColor(short color)
color
- The index of the color definitionshort getTopBorderColor()
void setBottomBorderColor(short color)
color
- The index of the color definitionshort getBottomBorderColor()
void setFillPattern(short fp)
fp
- fill pattern (set to 1 to fill w/foreground color)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
short getFillPattern()
void setFillBackgroundColor(short bg)
bg
- colorshort getFillBackgroundColor()
Color getFillBackgroundColorColor()
void setFillForegroundColor(short bg)
bg
- colorshort getFillForegroundColor()
Color getFillForegroundColorColor()
void cloneStyleFrom(CellStyle source)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |