Package taro.spreadsheet.model

Class SpreadsheetCellStyle

java.lang.Object

taro.spreadsheet.model.SpreadsheetCellStyle

public class SpreadsheetCellStyle
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
static SpreadsheetCellStyle	CENTER
static SpreadsheetCellStyle	CENTER_ONE_DECIMAL
static Color	COLOR_BAD
static Color	COLOR_GOOD
static Color	COLOR_NEUTRAL
static Color	COLOR_NOTE
static SpreadsheetCellStyle	DEFAULT
static SpreadsheetCellStyle	HEADER
static SpreadsheetCellStyle	LEFT
static SpreadsheetCellStyle	RIGHT
static SpreadsheetCellStyle	SUBTITLE
static SpreadsheetCellStyle	TITLE

Constructor Summary

Constructors

Constructor	Description
SpreadsheetCellStyle()

Method Summary

Modifier and Type	Method	Description
SpreadsheetCellStyle	apply(SpreadsheetCellStyle other)	Returns a new style that applies the given style to this one, ignoring all null fields.
SpreadsheetCellStyle	copy()
boolean	equals(Object o)
org.apache.poi.ss.usermodel.HorizontalAlignment	getAlign()
Color	getBackgroundColor()
Boolean	getBold()
org.apache.poi.ss.usermodel.BorderStyle	getBottomBorder()
Color	getBottomBorderColor()
String	getDataFormatString()
Boolean	getDoubleUnderline()
SpreadsheetFont	getFont()
String	getFontName()
Integer	getFontOffset()
Integer	getFontSizeInPoints()
Integer	getIndention()
Boolean	getItalic()
org.apache.poi.ss.usermodel.BorderStyle	getLeftBorder()
Color	getLeftBorderColor()
Boolean	getLocked()
SpreadsheetFont	getOrCreateFont()
org.apache.poi.ss.usermodel.BorderStyle	getRightBorder()
Color	getRightBorderColor()
Integer	getRotation()
Boolean	getStrikeout()
org.apache.poi.ss.usermodel.BorderStyle	getTopBorder()
Color	getTopBorderColor()
Boolean	getUnderline()
org.apache.poi.ss.usermodel.VerticalAlignment	getVerticalAlign()
Boolean	getWrapText()
int	hashCode()
Boolean	isHidden()
SpreadsheetCellStyle	withAlign(org.apache.poi.ss.usermodel.HorizontalAlignment align)
SpreadsheetCellStyle	withBackgroundColor(Color backgroundColor)
SpreadsheetCellStyle	withBold(Boolean bold)
SpreadsheetCellStyle	withBottomBorder(org.apache.poi.ss.usermodel.BorderStyle bottomBorder)
SpreadsheetCellStyle	withBottomBorderColor(Color bottomBorderColor)
SpreadsheetCellStyle	withDataFormatString(String dataFormatString)
SpreadsheetCellStyle	withDoubleUnderline(boolean doubleUnderline)
SpreadsheetCellStyle	withFont(SpreadsheetFont font)
SpreadsheetCellStyle	withFontName(String fontName)
SpreadsheetCellStyle	withFontOffset(Integer fontOffset)
SpreadsheetCellStyle	withFontSizeInPoints(Integer fontSizeInPoints)
SpreadsheetCellStyle	withHidden(Boolean hidden)
SpreadsheetCellStyle	withIndention(Integer indention)
SpreadsheetCellStyle	withItalic(Boolean italic)
SpreadsheetCellStyle	withLeftBorder(org.apache.poi.ss.usermodel.BorderStyle leftBorder)
SpreadsheetCellStyle	withLeftBorderColor(Color leftBorderColor)
SpreadsheetCellStyle	withLocked(Boolean locked)
SpreadsheetCellStyle	withNumDecimals(int numDecimals)
SpreadsheetCellStyle	withRightBorder(org.apache.poi.ss.usermodel.BorderStyle rightBorder)
SpreadsheetCellStyle	withRightBorderColor(Color rightBorderColor)
SpreadsheetCellStyle	withRotation(Integer rotation)
SpreadsheetCellStyle	withStrikeout(Boolean strikeout)
SpreadsheetCellStyle	withSurroundBorder(org.apache.poi.ss.usermodel.BorderStyle border)
SpreadsheetCellStyle	withTopBorder(org.apache.poi.ss.usermodel.BorderStyle topBorder)
SpreadsheetCellStyle	withTopBorderColor(Color topBorderColor)
SpreadsheetCellStyle	withUnderline(boolean underline)
SpreadsheetCellStyle	withVerticalAlign(org.apache.poi.ss.usermodel.VerticalAlignment verticalAlign)
SpreadsheetCellStyle	withWrapText(Boolean wrapText)

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, toString, wait, wait, wait

Field Detail

COLOR_BAD

public static final Color COLOR_BAD

COLOR_GOOD

public static final Color COLOR_GOOD

COLOR_NEUTRAL

public static final Color COLOR_NEUTRAL

COLOR_NOTE

public static final Color COLOR_NOTE

DEFAULT

public static final SpreadsheetCellStyle DEFAULT

CENTER

public static final SpreadsheetCellStyle CENTER

RIGHT

public static final SpreadsheetCellStyle RIGHT

LEFT

public static final SpreadsheetCellStyle LEFT

CENTER_ONE_DECIMAL

public static final SpreadsheetCellStyle CENTER_ONE_DECIMAL

SUBTITLE

public static final SpreadsheetCellStyle SUBTITLE

TITLE

public static final SpreadsheetCellStyle TITLE

HEADER

public static final SpreadsheetCellStyle HEADER

Constructor Detail

SpreadsheetCellStyle

public SpreadsheetCellStyle()

Method Detail

apply

public SpreadsheetCellStyle apply(SpreadsheetCellStyle other)

Returns a new style that applies the given style to this one, ignoring all null fields. For instance, you could define a style that represents an 'invalid' cell and make the background color red and give it a red border. Then you could take any other style or cell and apply the invalid style to it. It would change the color to red and add the red border, but leave all other stylings (such as alignment, font, etc.) alone.

copy

public SpreadsheetCellStyle copy()

getFont

public SpreadsheetFont getFont()

withFont

public SpreadsheetCellStyle withFont(SpreadsheetFont font)

getOrCreateFont

public SpreadsheetFont getOrCreateFont()

getAlign

public org.apache.poi.ss.usermodel.HorizontalAlignment getAlign()

withAlign

public SpreadsheetCellStyle withAlign(org.apache.poi.ss.usermodel.HorizontalAlignment align)

getBackgroundColor

public Color getBackgroundColor()

withBackgroundColor

public SpreadsheetCellStyle withBackgroundColor(Color backgroundColor)

getBold

public Boolean getBold()

withBold

public SpreadsheetCellStyle withBold(Boolean bold)

getBottomBorder

public org.apache.poi.ss.usermodel.BorderStyle getBottomBorder()

withBottomBorder

public SpreadsheetCellStyle withBottomBorder(org.apache.poi.ss.usermodel.BorderStyle bottomBorder)

getBottomBorderColor

public Color getBottomBorderColor()

withBottomBorderColor

public SpreadsheetCellStyle withBottomBorderColor(Color bottomBorderColor)

getDataFormatString

public String getDataFormatString()

withDataFormatString

public SpreadsheetCellStyle withDataFormatString(String dataFormatString)

getFontName

public String getFontName()

withFontName

public SpreadsheetCellStyle withFontName(String fontName)

getFontOffset

public Integer getFontOffset()

withFontOffset

public SpreadsheetCellStyle withFontOffset(Integer fontOffset)

getFontSizeInPoints

public Integer getFontSizeInPoints()

withFontSizeInPoints

public SpreadsheetCellStyle withFontSizeInPoints(Integer fontSizeInPoints)

isHidden

public Boolean isHidden()

withHidden

public SpreadsheetCellStyle withHidden(Boolean hidden)

getItalic

public Boolean getItalic()

withItalic

public SpreadsheetCellStyle withItalic(Boolean italic)

getLeftBorder

public org.apache.poi.ss.usermodel.BorderStyle getLeftBorder()

withLeftBorder

public SpreadsheetCellStyle withLeftBorder(org.apache.poi.ss.usermodel.BorderStyle leftBorder)

getLeftBorderColor

public Color getLeftBorderColor()

withLeftBorderColor

public SpreadsheetCellStyle withLeftBorderColor(Color leftBorderColor)

withSurroundBorder

public SpreadsheetCellStyle withSurroundBorder(org.apache.poi.ss.usermodel.BorderStyle border)

getLocked

public Boolean getLocked()

withLocked

public SpreadsheetCellStyle withLocked(Boolean locked)

getRightBorder

public org.apache.poi.ss.usermodel.BorderStyle getRightBorder()

withRightBorder

public SpreadsheetCellStyle withRightBorder(org.apache.poi.ss.usermodel.BorderStyle rightBorder)

getRightBorderColor

public Color getRightBorderColor()

withRightBorderColor

public SpreadsheetCellStyle withRightBorderColor(Color rightBorderColor)

getStrikeout

public Boolean getStrikeout()

withStrikeout

public SpreadsheetCellStyle withStrikeout(Boolean strikeout)

getTopBorder

public org.apache.poi.ss.usermodel.BorderStyle getTopBorder()

withTopBorder

public SpreadsheetCellStyle withTopBorder(org.apache.poi.ss.usermodel.BorderStyle topBorder)

getTopBorderColor

public Color getTopBorderColor()

withTopBorderColor

public SpreadsheetCellStyle withTopBorderColor(Color topBorderColor)

getUnderline

public Boolean getUnderline()

withUnderline

public SpreadsheetCellStyle withUnderline(boolean underline)

getDoubleUnderline

public Boolean getDoubleUnderline()

withDoubleUnderline

public SpreadsheetCellStyle withDoubleUnderline(boolean doubleUnderline)

getVerticalAlign

public org.apache.poi.ss.usermodel.VerticalAlignment getVerticalAlign()

withVerticalAlign

public SpreadsheetCellStyle withVerticalAlign(org.apache.poi.ss.usermodel.VerticalAlignment verticalAlign)

getWrapText

public Boolean getWrapText()

withWrapText

public SpreadsheetCellStyle withWrapText(Boolean wrapText)

getIndention

public Integer getIndention()

withIndention

public SpreadsheetCellStyle withIndention(Integer indention)

getRotation

public Integer getRotation()

withRotation

public SpreadsheetCellStyle withRotation(Integer rotation)

withNumDecimals

public SpreadsheetCellStyle withNumDecimals(int numDecimals)

equals

public boolean equals(Object o)

Overrides:

equals in class Object

hashCode

public int hashCode()

Overrides:

hashCode in class Object