|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.apache.poi.xssf.usermodel.XSSFCellStyle
public class XSSFCellStyle
High level representation of the the possible formatting information for the contents of the cells on a sheet in a SpreadsheetML document.
XSSFWorkbook.createCellStyle()
,
XSSFWorkbook.getCellStyleAt(short)
,
XSSFCell.setCellStyle(org.apache.poi.ss.usermodel.CellStyle)
Field Summary |
---|
Constructor Summary | |
---|---|
XSSFCellStyle(int cellXfId,
int cellStyleXfId,
StylesTable stylesSource,
ThemesTable theme)
Creates a Cell Style from the supplied parts |
|
XSSFCellStyle(StylesTable stylesSource)
Creates an empty Cell Style |
Method Summary | |
---|---|
java.lang.Object |
clone()
Make a copy of this style. |
void |
cloneStyleFrom(CellStyle source)
Clones all the style information from another XSSFCellStyle, onto this one. |
boolean |
equals(java.lang.Object o)
Checks is the supplied style is equal to this style |
short |
getAlignment()
Get the type of horizontal alignment for the cell |
HorizontalAlignment |
getAlignmentEnum()
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 |
BorderStyle |
getBorderBottomEnum()
Get the type of border to use for the bottom border of the cell |
XSSFColor |
getBorderColor(XSSFCellBorder.BorderSide side)
Gets border color |
short |
getBorderLeft()
Get the type of border to use for the left border of the cell |
BorderStyle |
getBorderLeftEnum()
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 |
BorderStyle |
getBorderRightEnum()
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 |
BorderStyle |
getBorderTopEnum()
Get the type of border to use for the top border of the cell |
short |
getBottomBorderColor()
Get the color to use for the bottom border Color is optional. |
XSSFColor |
getBottomBorderXSSFColor()
Get the color to use for the bottom border as a XSSFColor |
protected XSSFCellAlignment |
getCellAlignment()
get the cellAlignment object to use for manage alignment |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf |
getCoreXf()
Used so that StylesSource can figure out our location |
short |
getDataFormat()
Get the index of the number format (numFmt) record used by this cell format. |
java.lang.String |
getDataFormatString()
Get the contents of the format string, by looking up the StylesSource |
short |
getFillBackgroundColor()
Get the background fill color. |
XSSFColor |
getFillBackgroundColorColor()
Gets the color object representing the current background fill, resolving indexes using the supplied workbook. |
XSSFColor |
getFillBackgroundXSSFColor()
Get the background fill color. |
short |
getFillForegroundColor()
Get the foreground fill color. |
XSSFColor |
getFillForegroundColorColor()
Gets the color object representing the current foreground fill, resolving indexes using the supplied workbook. |
XSSFColor |
getFillForegroundXSSFColor()
Get the foreground fill color. |
short |
getFillPattern()
Get the fill pattern |
FillPatternType |
getFillPatternEnum()
Get the fill pattern |
XSSFFont |
getFont()
Gets the font for this style |
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 StylesTable (sequence within the collection of CTXf elements) |
short |
getLeftBorderColor()
Get the color to use for the left border |
XSSFColor |
getLeftBorderXSSFColor()
Get the color to use for the left border |
boolean |
getLocked()
Get whether the cell's using this style are locked |
short |
getRightBorderColor()
Get the color to use for the right border |
XSSFColor |
getRightBorderXSSFColor()
Get the color to use for the right border |
short |
getRotation()
Get the degree of rotation for the text in the cell |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf |
getStyleXf()
Used so that StylesSource can figure out our location |
short |
getTopBorderColor()
Get the color to use for the top border |
XSSFColor |
getTopBorderXSSFColor()
Get the color to use for the top border |
short |
getVerticalAlignment()
Get the type of vertical alignment for the cell |
VerticalAlignment |
getVerticalAlignmentEnum()
Get the type of vertical alignment for the cell |
boolean |
getWrapText()
Whether the text should be wrapped |
int |
hashCode()
Returns a hash code value for the object. |
void |
setAlignment(HorizontalAlignment align)
Set the type of horizontal alignment for the cell |
void |
setAlignment(short align)
Set the type of horizontal alignment for the cell |
void |
setBorderBottom(BorderStyle border)
Set the type of border to use for the bottom border of the cell |
void |
setBorderBottom(short border)
Set the type of border to use for the bottom border of the cell |
void |
setBorderColor(XSSFCellBorder.BorderSide side,
XSSFColor color)
Set the color to use for the selected border |
void |
setBorderLeft(BorderStyle border)
Set the type of border to use for the left border of the cell |
void |
setBorderLeft(short border)
Set the type of border to use for the left border of the cell |
void |
setBorderRight(BorderStyle border)
Set the type of border to use for the right border of the cell |
void |
setBorderRight(short border)
Set the type of border to use for the right border of the cell |
void |
setBorderTop(BorderStyle border)
Set the type of border to use for the top 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 |
setBottomBorderColor(XSSFColor color)
Set the color to use for the bottom border |
void |
setDataFormat(short fmt)
Set the index of a data format |
void |
setFillBackgroundColor(short bg)
Set the background fill color represented as a indexed color value. |
void |
setFillBackgroundColor(XSSFColor color)
Set the background fill color represented as a XSSFColor value. |
void |
setFillForegroundColor(short fg)
Set the foreground fill color as a indexed color value Note: Ensure Foreground color is set prior to background color. |
void |
setFillForegroundColor(XSSFColor color)
Set the foreground fill color represented as a XSSFColor value. |
void |
setFillPattern(FillPatternType ptrn)
This element is used to specify cell fill information for pattern and solid color cell fills. |
void |
setFillPattern(short fp)
This element is used to specify cell fill information for pattern and solid color cell fills. |
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 as a indexed color value |
void |
setLeftBorderColor(XSSFColor color)
Set the color to use for the left border as a XSSFColor value |
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 |
setRightBorderColor(XSSFColor color)
Set the color to use for the right border as a XSSFColor value |
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 |
setTopBorderColor(XSSFColor color)
Set the color to use for the top border as a XSSFColor value |
void |
setVerticalAlignment(short align)
Set the type of vertical alignment for the cell |
void |
setVerticalAlignment(VerticalAlignment align)
Set the type of vertical alignment for the cell |
void |
setWrapText(boolean wrapped)
Set whether the text should be wrapped. |
void |
verifyBelongsToStylesSource(StylesTable src)
Verifies that this style belongs to the supplied Workbook Styles Source. |
Methods inherited from class java.lang.Object |
---|
finalize, getClass, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public XSSFCellStyle(int cellXfId, int cellStyleXfId, StylesTable stylesSource, ThemesTable theme)
cellXfId
- The main XF for the cell. Must be a valid 0-based index into the XF tablecellStyleXfId
- Optional, style xf. A value of -1
means no xf.stylesSource
- Styles Source to work offpublic XSSFCellStyle(StylesTable stylesSource)
Method Detail |
---|
@Internal public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf getCoreXf()
@Internal public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXf getStyleXf()
public void verifyBelongsToStylesSource(StylesTable src)
java.lang.IllegalArgumentException
- if there's a workbook mis-matchpublic void cloneStyleFrom(CellStyle source)
cloneStyleFrom
in interface CellStyle
public short getAlignment()
getAlignment
in interface CellStyle
CellStyle.ALIGN_GENERAL
,
CellStyle.ALIGN_LEFT
,
CellStyle.ALIGN_CENTER
,
CellStyle.ALIGN_RIGHT
,
CellStyle.ALIGN_FILL
,
CellStyle.ALIGN_JUSTIFY
,
CellStyle.ALIGN_CENTER_SELECTION
public HorizontalAlignment getAlignmentEnum()
HorizontalAlignment
public short getBorderBottom()
getBorderBottom
in interface CellStyle
CellStyle.BORDER_NONE
,
CellStyle.BORDER_THIN
,
CellStyle.BORDER_MEDIUM
,
CellStyle.BORDER_DASHED
,
CellStyle.BORDER_DOTTED
,
CellStyle.BORDER_THICK
,
CellStyle.BORDER_DOUBLE
,
CellStyle.BORDER_HAIR
,
CellStyle.BORDER_MEDIUM_DASHED
,
CellStyle.BORDER_DASH_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT
,
CellStyle.BORDER_DASH_DOT_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT
,
CellStyle.BORDER_SLANTED_DASH_DOT
public BorderStyle getBorderBottomEnum()
BorderStyle
public short getBorderLeft()
getBorderLeft
in interface CellStyle
CellStyle.BORDER_NONE
CellStyle.BORDER_NONE
,
CellStyle.BORDER_THIN
,
CellStyle.BORDER_MEDIUM
,
CellStyle.BORDER_DASHED
,
CellStyle.BORDER_DOTTED
,
CellStyle.BORDER_THICK
,
CellStyle.BORDER_DOUBLE
,
CellStyle.BORDER_HAIR
,
CellStyle.BORDER_MEDIUM_DASHED
,
CellStyle.BORDER_DASH_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT
,
CellStyle.BORDER_DASH_DOT_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT
,
CellStyle.BORDER_SLANTED_DASH_DOT
public BorderStyle getBorderLeftEnum()
BorderStyle.NONE
public short getBorderRight()
getBorderRight
in interface CellStyle
CellStyle.BORDER_NONE
CellStyle.BORDER_NONE
,
CellStyle.BORDER_THIN
,
CellStyle.BORDER_MEDIUM
,
CellStyle.BORDER_DASHED
,
CellStyle.BORDER_DOTTED
,
CellStyle.BORDER_THICK
,
CellStyle.BORDER_DOUBLE
,
CellStyle.BORDER_HAIR
,
CellStyle.BORDER_MEDIUM_DASHED
,
CellStyle.BORDER_DASH_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT
,
CellStyle.BORDER_DASH_DOT_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT
,
CellStyle.BORDER_SLANTED_DASH_DOT
public BorderStyle getBorderRightEnum()
BorderStyle.NONE
public short getBorderTop()
getBorderTop
in interface CellStyle
CellStyle.BORDER_NONE
CellStyle.BORDER_NONE
,
CellStyle.BORDER_THIN
,
CellStyle.BORDER_MEDIUM
,
CellStyle.BORDER_DASHED
,
CellStyle.BORDER_DOTTED
,
#BORDER_THICK
,
CellStyle.BORDER_DOUBLE
,
CellStyle.BORDER_HAIR
,
CellStyle.BORDER_MEDIUM_DASHED
,
CellStyle.BORDER_DASH_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT
,
CellStyle.BORDER_DASH_DOT_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT
,
CellStyle.BORDER_SLANTED_DASH_DOT
public BorderStyle getBorderTopEnum()
BorderStyle.NONE
public short getBottomBorderColor()
getBottomBorderColor
in interface CellStyle
IndexedColors.AUTOMATIC
IndexedColors
public XSSFColor getBottomBorderXSSFColor()
XSSFColor
null
if not setpublic short getDataFormat()
getDataFormat
in interface CellStyle
DataFormat
public java.lang.String getDataFormatString()
getDataFormatString
in interface CellStyle
public short getFillBackgroundColor()
Note - many cells are actually filled with a foreground
fill, not a background fill - see getFillForegroundColor()
getFillBackgroundColor
in interface CellStyle
IndexedColors.AUTOMATIC
IndexedColors
public XSSFColor getFillBackgroundColorColor()
CellStyle
getFillBackgroundColorColor
in interface CellStyle
public XSSFColor getFillBackgroundXSSFColor()
Note - many cells are actually filled with a foreground
fill, not a background fill - see getFillForegroundColor()
null
if not setXSSFColor.getRgb()
public short getFillForegroundColor()
Many cells are filled with this, instead of a
background color (getFillBackgroundColor()
)
getFillForegroundColor
in interface CellStyle
IndexedColors.AUTOMATIC
IndexedColors
public XSSFColor getFillForegroundColorColor()
CellStyle
getFillForegroundColorColor
in interface CellStyle
public XSSFColor getFillForegroundXSSFColor()
null
if not setpublic short getFillPattern()
getFillPattern
in interface CellStyle
CellStyle.NO_FILL
CellStyle.NO_FILL
,
CellStyle.SOLID_FOREGROUND
,
CellStyle.FINE_DOTS
,
CellStyle.ALT_BARS
,
CellStyle.SPARSE_DOTS
,
CellStyle.THICK_HORZ_BANDS
,
CellStyle.THICK_VERT_BANDS
,
CellStyle.THICK_BACKWARD_DIAG
,
CellStyle.THICK_FORWARD_DIAG
,
CellStyle.BIG_SPOTS
,
CellStyle.BRICKS
,
CellStyle.THIN_HORZ_BANDS
,
CellStyle.THIN_VERT_BANDS
,
CellStyle.THIN_BACKWARD_DIAG
,
CellStyle.THIN_FORWARD_DIAG
,
CellStyle.SQUARES
,
CellStyle.DIAMONDS
public FillPatternType getFillPatternEnum()
FillPatternType.NO_FILL
public XSSFFont getFont()
public short getFontIndex()
getFontIndex
in interface CellStyle
XSSFWorkbook.getFontAt(short)
public boolean getHidden()
getHidden
in interface CellStyle
public short getIndention()
getIndention
in interface CellStyle
public short getIndex()
getIndex
in interface CellStyle
public short getLeftBorderColor()
getLeftBorderColor
in interface CellStyle
IndexedColors.BLACK
IndexedColors
public XSSFColor getLeftBorderXSSFColor()
null
if not setIndexedColors
public boolean getLocked()
getLocked
in interface CellStyle
public short getRightBorderColor()
getRightBorderColor
in interface CellStyle
IndexedColors.BLACK
IndexedColors
public XSSFColor getRightBorderXSSFColor()
null
if not setpublic short getRotation()
Expressed in degrees. Values range from 0 to 180. The first letter of
the text is considered the center-point of the arc.
For 0 - 90, the value represents degrees above horizon. For 91-180 the degrees below the
horizon is calculated as:
[degrees below horizon] = 90 - textRotation.
getRotation
in interface CellStyle
public short getTopBorderColor()
getTopBorderColor
in interface CellStyle
IndexedColors.BLACK
IndexedColors
public XSSFColor getTopBorderXSSFColor()
null
if not setpublic short getVerticalAlignment()
getVerticalAlignment
in interface CellStyle
CellStyle.VERTICAL_BOTTOM
CellStyle.VERTICAL_TOP
,
CellStyle.VERTICAL_CENTER
,
CellStyle.VERTICAL_BOTTOM
,
CellStyle.VERTICAL_JUSTIFY
public VerticalAlignment getVerticalAlignmentEnum()
VerticalAlignment.BOTTOM
VerticalAlignment
public boolean getWrapText()
getWrapText
in interface CellStyle
public void setAlignment(short align)
setAlignment
in interface CellStyle
align
- - the type of alignmentCellStyle.ALIGN_GENERAL
,
CellStyle.ALIGN_LEFT
,
CellStyle.ALIGN_CENTER
,
CellStyle.ALIGN_RIGHT
,
CellStyle.ALIGN_FILL
,
CellStyle.ALIGN_JUSTIFY
,
CellStyle.ALIGN_CENTER_SELECTION
public void setAlignment(HorizontalAlignment align)
align
- - the type of alignmentHorizontalAlignment
public void setBorderBottom(short border)
setBorderBottom
in interface CellStyle
border
- the type of border to useCellStyle.BORDER_NONE
,
CellStyle.BORDER_THIN
,
CellStyle.BORDER_MEDIUM
,
CellStyle.BORDER_DASHED
,
CellStyle.BORDER_DOTTED
,
CellStyle.BORDER_THICK
,
CellStyle.BORDER_DOUBLE
,
CellStyle.BORDER_HAIR
,
CellStyle.BORDER_MEDIUM_DASHED
,
CellStyle.BORDER_DASH_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT
,
CellStyle.BORDER_DASH_DOT_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT
,
CellStyle.BORDER_SLANTED_DASH_DOT
public void setBorderBottom(BorderStyle border)
border
- - type of border to useBorderStyle
public void setBorderLeft(short border)
setBorderLeft
in interface CellStyle
border
- the type of border to useCellStyle.BORDER_NONE
,
CellStyle.BORDER_THIN
,
CellStyle.BORDER_MEDIUM
,
CellStyle.BORDER_DASHED
,
CellStyle.BORDER_DOTTED
,
CellStyle.BORDER_THICK
,
CellStyle.BORDER_DOUBLE
,
CellStyle.BORDER_HAIR
,
CellStyle.BORDER_MEDIUM_DASHED
,
CellStyle.BORDER_DASH_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT
,
CellStyle.BORDER_DASH_DOT_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT
,
CellStyle.BORDER_SLANTED_DASH_DOT
public void setBorderLeft(BorderStyle border)
border
- the type of border to usepublic void setBorderRight(short border)
setBorderRight
in interface CellStyle
border
- the type of border to useCellStyle.BORDER_NONE
,
CellStyle.BORDER_THIN
,
CellStyle.BORDER_MEDIUM
,
CellStyle.BORDER_DASHED
,
CellStyle.BORDER_DOTTED
,
CellStyle.BORDER_THICK
,
CellStyle.BORDER_DOUBLE
,
CellStyle.BORDER_HAIR
,
CellStyle.BORDER_MEDIUM_DASHED
,
CellStyle.BORDER_DASH_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT
,
CellStyle.BORDER_DASH_DOT_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT
,
CellStyle.BORDER_SLANTED_DASH_DOT
public void setBorderRight(BorderStyle border)
border
- the type of border to usepublic void setBorderTop(short border)
setBorderTop
in interface CellStyle
border
- the type of border to useCellStyle.BORDER_NONE
,
CellStyle.BORDER_THIN
,
CellStyle.BORDER_MEDIUM
,
CellStyle.BORDER_DASHED
,
CellStyle.BORDER_DOTTED
,
CellStyle.BORDER_THICK
,
CellStyle.BORDER_DOUBLE
,
CellStyle.BORDER_HAIR
,
CellStyle.BORDER_MEDIUM_DASHED
,
CellStyle.BORDER_DASH_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT
,
CellStyle.BORDER_DASH_DOT_DOT
,
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT
,
CellStyle.BORDER_SLANTED_DASH_DOT
public void setBorderTop(BorderStyle border)
border
- the type of border to usepublic void setBottomBorderColor(short color)
setBottomBorderColor
in interface CellStyle
color
- the index of the color definitionIndexedColors
public void setBottomBorderColor(XSSFColor color)
color
- the color to use, null means no colorpublic void setDataFormat(short fmt)
setDataFormat
in interface CellStyle
fmt
- the index of a data formatDataFormat
public void setFillBackgroundColor(XSSFColor color)
XSSFColor
value.
For example:
cs.setFillPattern(XSSFCellStyle.FINE_DOTS ); cs.setFillBackgroundXSSFColor(new XSSFColor(java.awt.Color.RED));optionally a Foreground and background fill can be applied: Note: Ensure Foreground color is set prior to background
cs.setFillPattern(XSSFCellStyle.FINE_DOTS ); cs.setFillForegroundColor(new XSSFColor(java.awt.Color.BLUE)); cs.setFillBackgroundColor(new XSSFColor(java.awt.Color.GREEN));or, for the special case of SOLID_FILL:
cs.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND ); cs.setFillForegroundColor(new XSSFColor(java.awt.Color.GREEN));It is necessary to set the fill style in order for the color to be shown in the cell.
color
- - the color to usepublic void setFillBackgroundColor(short bg)
For example:
cs.setFillPattern(XSSFCellStyle.FINE_DOTS ); cs.setFillBackgroundXSSFColor(IndexedColors.RED.getIndex());optionally a Foreground and background fill can be applied: Note: Ensure Foreground color is set prior to background
cs.setFillPattern(XSSFCellStyle.FINE_DOTS ); cs.setFillForegroundColor(IndexedColors.BLUE.getIndex()); cs.setFillBackgroundColor(IndexedColors.RED.getIndex());or, for the special case of SOLID_FILL:
cs.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND ); cs.setFillForegroundColor(IndexedColors.RED.getIndex());It is necessary to set the fill style in order for the color to be shown in the cell.
setFillBackgroundColor
in interface CellStyle
bg
- - the color to useIndexedColors
public void setFillForegroundColor(XSSFColor color)
XSSFColor
value.
color
- the color to use)
public void setFillForegroundColor(short fg)
setFillForegroundColor
in interface CellStyle
fg
- the color to useIndexedColors
public void setFillPattern(short fp)
setFillPattern
in interface CellStyle
fp
- fill pattern (set to CellStyle.SOLID_FOREGROUND
to fill w/foreground color)CellStyle.NO_FILL
,
CellStyle.SOLID_FOREGROUND
,
CellStyle.FINE_DOTS
,
CellStyle.ALT_BARS
,
CellStyle.SPARSE_DOTS
,
CellStyle.THICK_HORZ_BANDS
,
CellStyle.THICK_VERT_BANDS
,
CellStyle.THICK_BACKWARD_DIAG
,
CellStyle.THICK_FORWARD_DIAG
,
CellStyle.BIG_SPOTS
,
CellStyle.BRICKS
,
CellStyle.THIN_HORZ_BANDS
,
CellStyle.THIN_VERT_BANDS
,
CellStyle.THIN_BACKWARD_DIAG
,
CellStyle.THIN_FORWARD_DIAG
,
CellStyle.SQUARES
,
CellStyle.DIAMONDS
,
setFillBackgroundColor(short)
,
setFillForegroundColor(short)
public void setFillPattern(FillPatternType ptrn)
ptrn
- the fill pattern to usesetFillBackgroundColor(short)
,
setFillForegroundColor(short)
,
FillPatternType
public void setFont(Font font)
setFont
in interface CellStyle
font
- a font object created or retreived from the XSSFWorkbook objectXSSFWorkbook.createFont()
,
XSSFWorkbook.getFontAt(short)
public void setHidden(boolean hidden)
setHidden
in interface CellStyle
hidden
- - whether the cell using this style should be hiddenpublic void setIndention(short indent)
setIndention
in interface CellStyle
indent
- - number of spacespublic void setLeftBorderColor(short color)
setLeftBorderColor
in interface CellStyle
color
- the index of the color definitionIndexedColors
public void setLeftBorderColor(XSSFColor color)
XSSFColor
value
color
- the color to usepublic void setLocked(boolean locked)
setLocked
in interface CellStyle
locked
- - whether the cell using this style should be lockedpublic void setRightBorderColor(short color)
setRightBorderColor
in interface CellStyle
color
- the index of the color definitionIndexedColors
public void setRightBorderColor(XSSFColor color)
XSSFColor
value
color
- the color to usepublic void setRotation(short rotation)
Expressed in degrees. Values range from 0 to 180. The first letter of
the text is considered the center-point of the arc.
For 0 - 90, the value represents degrees above horizon. For 91-180 the degrees below the
horizon is calculated as:
[degrees below horizon] = 90 - textRotation.
setRotation
in interface CellStyle
rotation
- - the rotation degrees (between 0 and 180 degrees)public void setTopBorderColor(short color)
setTopBorderColor
in interface CellStyle
color
- the index of the color definitionIndexedColors
public void setTopBorderColor(XSSFColor color)
XSSFColor
value
color
- the color to usepublic void setVerticalAlignment(short align)
setVerticalAlignment
in interface CellStyle
align
- - align the type of alignmentCellStyle.VERTICAL_TOP
,
CellStyle.VERTICAL_CENTER
,
CellStyle.VERTICAL_BOTTOM
,
CellStyle.VERTICAL_JUSTIFY
,
VerticalAlignment
public void setVerticalAlignment(VerticalAlignment align)
align
- - the type of alignmentpublic void setWrapText(boolean wrapped)
Setting this flag to true
make all content visible
whithin a cell by displaying it on multiple lines
setWrapText
in interface CellStyle
wrapped
- a boolean value indicating if the text in a cell should be line-wrapped within the cell.public XSSFColor getBorderColor(XSSFCellBorder.BorderSide side)
side
- the border side
public void setBorderColor(XSSFCellBorder.BorderSide side, XSSFColor color)
side
- - where to apply the color definitioncolor
- - the color to useprotected XSSFCellAlignment getCellAlignment()
public int hashCode()
hashCode
in class java.lang.Object
public boolean equals(java.lang.Object o)
equals
in class java.lang.Object
o
- the style to check
public java.lang.Object clone()
clone
in class java.lang.Object
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |