public interface EditableCellStyle extends CellStyle
CellStyle.Alignment, CellStyle.BorderType, CellStyle.FillPattern, CellStyle.VerticalAlignment
Modifier and Type | Method and Description |
---|---|
void |
setAlignment(CellStyle.Alignment alignment)
Sets horizontal alignment
Note: Spreadsheet(UI display) supports only Alignment#LEFT , Alignment#CENTER , Alignment#RIGHT
(Alignment#CENTER_SELECTION will be display as Alignment#CENTER , Other alignment will be display as Alignment#LEFT ),
However you can still set another alignment, the data will still be kept when export. |
void |
setBackColor(Color color)
Sets background-color of a fill
|
void |
setBackgroundColor(Color color)
Deprecated.
since 3.5.0 , use
setBackColor(Color) |
void |
setBorderBottom(CellStyle.BorderType borderType)
Sets bottom border
Note: Spreadsheet(UI display) only supports BorderType#NONE , BorderType#THIN , BorderType#DOTTED and BorderType#HAIR ,
(BorderType#DASH_DOT will be display as Alignment#DOTTED , Other alignment will be display as Alignment#THIN ),
However you can still set another alignment, the data will still be kept when export. |
void |
setBorderBottomColor(Color color)
Sets bottom border color
you could use Range.CellStyleHelper.createColorFromHtmlColor(String) to create a Color |
void |
setBorderLeft(CellStyle.BorderType borderType)
Sets left border
Note: Spreadsheet(UI display) only supports BorderType#NONE , BorderType#THIN , BorderType#DOTTED and BorderType#HAIR ,
(BorderType#DASH_DOT will be display as Alignment#DOTTED , Other alignment will be display as Alignment#THIN ),
However you can still set another alignment, the data will still be kept when export. |
void |
setBorderLeftColor(Color color)
Sets left border color
you could use Range.CellStyleHelper.createColorFromHtmlColor(String) to create a Color |
void |
setBorderRight(CellStyle.BorderType borderType)
Sets right border
Note: Spreadsheet(UI display) only supports BorderType#NONE , BorderType#THIN , BorderType#DOTTED and BorderType#HAIR ,
(BorderType#DASH_DOT will be display as Alignment#DOTTED , Other alignment will be display as Alignment#THIN ),
However you can still set another alignment, the data will still be kept when export. |
void |
setBorderRightColor(Color color)
Sets right border color
you could use Range.CellStyleHelper.createColorFromHtmlColor(String) to create a Color |
void |
setBorderTop(CellStyle.BorderType borderType)
Sets top border
Note: Spreadsheet(UI display) only supports BorderType#NONE , BorderType#THIN , BorderType#DOTTED and BorderType#HAIR ,
(BorderType#DASH_DOT will be display as Alignment#DOTTED , Other alignment will be display as Alignment#THIN ),
However you can still set another alignment, the data will still be kept when export. |
void |
setBorderTopColor(Color color)
Sets top border color.
|
void |
setDataFormat(String format)
Sets data format
|
void |
setFillColor(Color color)
Sets forground-color of a fill.
|
void |
setFillPattern(CellStyle.FillPattern pattern)
Sets the fill/background pattern
Note: Spreadsheet (UI display) supports only FillPattern#NONE and FillPattern#SOLID
(Other pattern will be display as {@link FillPattern#SOLID_FOREGROUND),
However you can still set another pattern, the data will still be kept when export. |
void |
setFont(Font font)
Sets font
|
void |
setHidden(boolean hidden)
Sets hidden
|
void |
setLocked(boolean locked)
Sets locked
|
void |
setVerticalAlignment(CellStyle.VerticalAlignment alignment)
Sets vertical alignment
Note: Spreadsheet(UI display) supports only VerticalAlignment#TOP , VerticalAlignment#CENTER , VerticalAlignment#TOP ,
(Other alignment will be display as VerticalAlignment#BOTTOM ), |
void |
setWrapText(boolean wraptext)
Sets wrap-text
|
getAlignment, getBackColor, getBackgroundColor, getBorderBottom, getBorderBottomColor, getBorderLeft, getBorderLeftColor, getBorderRight, getBorderRightColor, getBorderTop, getBorderTopColor, getDataFormat, getFillColor, getFillPattern, getFont, getVerticalAlignment, isHidden, isLocked, isWrapText
void setFont(Font font)
font
- the fontvoid setBackgroundColor(Color color)
setBackColor(Color)
color
- background-colorvoid setBackColor(Color color)
color
- background-colorvoid setFillColor(Color color)
color
- void setFillPattern(CellStyle.FillPattern pattern)
FillPattern#NONE
and FillPattern#SOLID
(Other pattern will be display as {@link FillPattern#SOLID_FOREGROUND),
However you can still set another pattern, the data will still be kept when export.pattern
- void setAlignment(CellStyle.Alignment alignment)
Alignment#LEFT
, Alignment#CENTER
, Alignment#RIGHT
(Alignment#CENTER_SELECTION
will be display as Alignment#CENTER
, Other alignment will be display as Alignment#LEFT
),
However you can still set another alignment, the data will still be kept when export.alignment
- void setVerticalAlignment(CellStyle.VerticalAlignment alignment)
VerticalAlignment#TOP
, VerticalAlignment#CENTER
, VerticalAlignment#TOP
,
(Other alignment will be display as VerticalAlignment#BOTTOM
),alignment
- void setWrapText(boolean wraptext)
wraptext
- wrap-textvoid setBorderLeft(CellStyle.BorderType borderType)
BorderType#NONE
, BorderType#THIN
, BorderType#DOTTED
and BorderType#HAIR
,
(BorderType#DASH_DOT
will be display as Alignment#DOTTED
, Other alignment will be display as Alignment#THIN
),
However you can still set another alignment, the data will still be kept when export.borderType
- void setBorderTop(CellStyle.BorderType borderType)
BorderType#NONE
, BorderType#THIN
, BorderType#DOTTED
and BorderType#HAIR
,
(BorderType#DASH_DOT
will be display as Alignment#DOTTED
, Other alignment will be display as Alignment#THIN
),
However you can still set another alignment, the data will still be kept when export.borderType
- void setBorderRight(CellStyle.BorderType borderType)
BorderType#NONE
, BorderType#THIN
, BorderType#DOTTED
and BorderType#HAIR
,
(BorderType#DASH_DOT
will be display as Alignment#DOTTED
, Other alignment will be display as Alignment#THIN
),
However you can still set another alignment, the data will still be kept when export.borderType
- void setBorderBottom(CellStyle.BorderType borderType)
BorderType#NONE
, BorderType#THIN
, BorderType#DOTTED
and BorderType#HAIR
,
(BorderType#DASH_DOT
will be display as Alignment#DOTTED
, Other alignment will be display as Alignment#THIN
),
However you can still set another alignment, the data will still be kept when export.borderType
- void setBorderTopColor(Color color)
Range.CellStyleHelper.createColorFromHtmlColor(String)
to create a Color
color
- void setBorderLeftColor(Color color)
Range.CellStyleHelper.createColorFromHtmlColor(String)
to create a Color
color
- void setBorderBottomColor(Color color)
Range.CellStyleHelper.createColorFromHtmlColor(String)
to create a Color
color
- void setBorderRightColor(Color color)
Range.CellStyleHelper.createColorFromHtmlColor(String)
to create a Color
color
- void setDataFormat(String format)
format
- void setLocked(boolean locked)
locked
- void setHidden(boolean hidden)
hidden
- Copyright © 2020. All rights reserved.