Package io.keikai.api.model
Interface EditableCellStyle
- All Superinterfaces:
CellStyle
- All Known Implementing Classes:
EditableCellStyleImpl
Deprecated.
This interface allows you to change a cell's style.
- Since:
- 3.0.0
- Author:
- dennis
-
Nested Class Summary
Nested classes/interfaces inherited from interface io.keikai.api.model.CellStyle
CellStyle.Alignment, CellStyle.BorderType, CellStyle.Builder, CellStyle.FillPattern, CellStyle.VerticalAlignment -
Method Summary
Modifier and TypeMethodDescriptionvoidsetAlignment(CellStyle.Alignment alignment) Deprecated.Sets horizontal alignment
Note: Spreadsheet(UI display) supports onlyCellStyle.Alignment.LEFT,CellStyle.Alignment.CENTER,CellStyle.Alignment.RIGHT(CellStyle.Alignment.CENTER_SELECTIONwill be display asCellStyle.Alignment.CENTER, Other alignment will be display asCellStyle.Alignment.LEFT), However you can still set another alignment, the data will still be kept when export.voidsetBackColor(Color color) Deprecated.Sets background-color of a fillvoidsetBorderBottom(CellStyle.BorderType borderType) Deprecated.Sets bottom border
Note: Spreadsheet(UI display) only supportsCellStyle.BorderType.NONE,CellStyle.BorderType.THIN,CellStyle.BorderType.DOTTEDandCellStyle.BorderType.HAIR, (CellStyle.BorderType.DASH_DOTwill be display asCellStyle.BorderType.DOTTED, Other alignment will be display asCellStyle.BorderType.THIN), However you can still set another alignment, the data will still be kept when export.voidsetBorderBottomColor(Color color) Deprecated.Sets bottom border color
you could useRange.CellStyleHelper.createColorFromHtmlColor(String)to create aColorvoidsetBorderLeft(CellStyle.BorderType borderType) Deprecated.Sets left border
Note: Spreadsheet(UI display) only supportsCellStyle.BorderType.NONE,CellStyle.BorderType.THIN,CellStyle.BorderType.DOTTEDandCellStyle.BorderType.HAIR, (CellStyle.BorderType.DASH_DOTwill be display asCellStyle.BorderType.DOTTED, Other alignment will be display asCellStyle.BorderType.THIN), However you can still set another alignment, the data will still be kept when export.voidsetBorderLeftColor(Color color) Deprecated.Sets left border color
you could useRange.CellStyleHelper.createColorFromHtmlColor(String)to create aColorvoidsetBorderRight(CellStyle.BorderType borderType) Deprecated.Sets right border
Note: Spreadsheet(UI display) only supportsCellStyle.BorderType.NONE,CellStyle.BorderType.THIN,CellStyle.BorderType.DOTTEDandCellStyle.BorderType.HAIR, (CellStyle.BorderType.DASH_DOTwill be display asCellStyle.BorderType.DOTTED, Other alignment will be display asCellStyle.BorderType.THIN), However you can still set another alignment, the data will still be kept when export.voidsetBorderRightColor(Color color) Deprecated.Sets right border color
you could useRange.CellStyleHelper.createColorFromHtmlColor(String)to create aColorvoidsetBorderTop(CellStyle.BorderType borderType) Deprecated.Sets top border
Note: Spreadsheet(UI display) only supportsCellStyle.BorderType.NONE,CellStyle.BorderType.THIN,CellStyle.BorderType.DOTTEDandCellStyle.BorderType.HAIR, (CellStyle.BorderType.DASH_DOTwill be display asCellStyle.BorderType.DOTTED, Other alignment will be display asCellStyle.BorderType.THIN), However you can still set another alignment, the data will still be kept when export.voidsetBorderTopColor(Color color) Deprecated.Sets top border color.voidsetDataFormat(String format) Deprecated.Sets data formatvoidsetFillColor(Color color) Deprecated.Sets forground-color of a fill.voidsetFillPattern(CellStyle.FillPattern pattern) Deprecated.Sets the fill/background pattern
Note: Spreadsheet (UI display) supports onlyCellStyle.FillPattern.NONEandCellStyle.FillPattern.SOLID(Other pattern will be display as {@link FillPattern#SOLID), However you can still set another pattern, the data will still be kept when export.voidDeprecated.Sets fontvoidsetHidden(boolean hidden) Deprecated.Sets hiddenvoidsetLocked(boolean locked) Deprecated.Sets lockedvoidsetVerticalAlignment(CellStyle.VerticalAlignment alignment) Deprecated.Sets vertical alignment
Note: Spreadsheet(UI display) supports onlyCellStyle.VerticalAlignment.TOP,CellStyle.VerticalAlignment.CENTER,CellStyle.VerticalAlignment.TOP, (Other alignment will be display asCellStyle.VerticalAlignment.BOTTOM),voidsetWrapText(boolean wraptext) Deprecated.Sets wrap-textMethods inherited from interface io.keikai.api.model.CellStyle
getAlignment, getBackColor, getBorderBottom, getBorderBottomColor, getBorderLeft, getBorderLeftColor, getBorderRight, getBorderRightColor, getBorderTop, getBorderTopColor, getDataFormat, getFillColor, getFillPattern, getFont, getRotation, getVerticalAlignment, isHidden, isLocked, isWrapText
-
Method Details
-
setFont
Deprecated.Sets font- Parameters:
font- the font
-
setBackColor
Deprecated.Sets background-color of a fill- Parameters:
color- background-color- Since:
- 3.8.1
-
setFillColor
Deprecated.Sets forground-color of a fill.- Parameters:
color-- Since:
- 3.5.0
-
setFillPattern
Deprecated.Sets the fill/background pattern
Note: Spreadsheet (UI display) supports onlyCellStyle.FillPattern.NONEandCellStyle.FillPattern.SOLID(Other pattern will be display as {@link FillPattern#SOLID), However you can still set another pattern, the data will still be kept when export.- Parameters:
pattern-
-
setAlignment
Deprecated.Sets horizontal alignment
Note: Spreadsheet(UI display) supports onlyCellStyle.Alignment.LEFT,CellStyle.Alignment.CENTER,CellStyle.Alignment.RIGHT(CellStyle.Alignment.CENTER_SELECTIONwill be display asCellStyle.Alignment.CENTER, Other alignment will be display asCellStyle.Alignment.LEFT), However you can still set another alignment, the data will still be kept when export.- Parameters:
alignment-
-
setVerticalAlignment
Deprecated.Sets vertical alignment
Note: Spreadsheet(UI display) supports onlyCellStyle.VerticalAlignment.TOP,CellStyle.VerticalAlignment.CENTER,CellStyle.VerticalAlignment.TOP, (Other alignment will be display asCellStyle.VerticalAlignment.BOTTOM),- Parameters:
alignment-
-
setWrapText
void setWrapText(boolean wraptext) Deprecated.Sets wrap-text- Parameters:
wraptext- wrap-text
-
setBorderLeft
Deprecated.Sets left border
Note: Spreadsheet(UI display) only supportsCellStyle.BorderType.NONE,CellStyle.BorderType.THIN,CellStyle.BorderType.DOTTEDandCellStyle.BorderType.HAIR, (CellStyle.BorderType.DASH_DOTwill be display asCellStyle.BorderType.DOTTED, Other alignment will be display asCellStyle.BorderType.THIN), However you can still set another alignment, the data will still be kept when export.- Parameters:
borderType-
-
setBorderTop
Deprecated.Sets top border
Note: Spreadsheet(UI display) only supportsCellStyle.BorderType.NONE,CellStyle.BorderType.THIN,CellStyle.BorderType.DOTTEDandCellStyle.BorderType.HAIR, (CellStyle.BorderType.DASH_DOTwill be display asCellStyle.BorderType.DOTTED, Other alignment will be display asCellStyle.BorderType.THIN), However you can still set another alignment, the data will still be kept when export.- Parameters:
borderType-
-
setBorderRight
Deprecated.Sets right border
Note: Spreadsheet(UI display) only supportsCellStyle.BorderType.NONE,CellStyle.BorderType.THIN,CellStyle.BorderType.DOTTEDandCellStyle.BorderType.HAIR, (CellStyle.BorderType.DASH_DOTwill be display asCellStyle.BorderType.DOTTED, Other alignment will be display asCellStyle.BorderType.THIN), However you can still set another alignment, the data will still be kept when export.- Parameters:
borderType-
-
setBorderBottom
Deprecated.Sets bottom border
Note: Spreadsheet(UI display) only supportsCellStyle.BorderType.NONE,CellStyle.BorderType.THIN,CellStyle.BorderType.DOTTEDandCellStyle.BorderType.HAIR, (CellStyle.BorderType.DASH_DOTwill be display asCellStyle.BorderType.DOTTED, Other alignment will be display asCellStyle.BorderType.THIN), However you can still set another alignment, the data will still be kept when export.- Parameters:
borderType-
-
setBorderTopColor
Deprecated.Sets top border color.
you could useRange.CellStyleHelper.createColorFromHtmlColor(String)to create aColor- Parameters:
color-
-
setBorderLeftColor
Deprecated.Sets left border color
you could useRange.CellStyleHelper.createColorFromHtmlColor(String)to create aColor- Parameters:
color-
-
setBorderBottomColor
Deprecated.Sets bottom border color
you could useRange.CellStyleHelper.createColorFromHtmlColor(String)to create aColor- Parameters:
color-
-
setBorderRightColor
Deprecated.Sets right border color
you could useRange.CellStyleHelper.createColorFromHtmlColor(String)to create aColor- Parameters:
color-
-
setDataFormat
Deprecated.Sets data format- Parameters:
format-
-
setLocked
void setLocked(boolean locked) Deprecated.Sets locked- Parameters:
locked-
-
setHidden
void setHidden(boolean hidden) Deprecated.Sets hidden- Parameters:
hidden-
-
Range.CellStyleHelper.builder(CellStyle)to build an immutable cell style