io.keikai.range.impl

Class WholeStyleUtil

java.lang.Object

io.keikai.range.impl.WholeStyleUtil

public class WholeStyleUtil
extends Object

A utility class to help spreadsheet set style of a row, column and cell

Since:

3.5.0

Author:

Dennis.Chen

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static interface	WholeStyleUtil.StyleApplyer

Constructor Summary

Constructors

Constructor and Description
WholeStyleUtil()

Method Summary

Modifier and Type	Method and Description
static void	setBackColor(SRange wholeRange, String htmlColor)
static void	setDataFormat(SRange wholeRange, String format)
static void	setFillColor(SRange wholeRange, String htmlColor)
static void	setFillOptions(SRange wholeRange, String backColor, String fillColor, SFill.FillPattern pattern)
static void	setFontBoldWeight(SRange wholeRange, SFont.Boldweight fontBoldweight)
static void	setFontColor(SRange wholeRange, String htmlColor)
static void	setFontHeightPoints(SRange wholeRange, int fontHeightPoints)
static void	setFontItalic(SRange wholeRange, boolean italic)
static void	setFontName(SRange wholeRange, String fontName)
static void	setFontStrikethrough(SRange wholeRange, boolean strikeout)
static void	setFontTypeOffset(SRange wholeRange, SFont.TypeOffset fontTypeOffset)
static void	setFontUnderline(SRange wholeRange, SFont.Underline fontUnderline)
static void	setTextHAlign(SRange wholeRange, SCellStyle.Alignment hAlignment)
static void	setTextIndention(SRange wholeRange, int indention)
static void	setTextIndentionOffset(SRange wholeRange, int offset)
static void	setTextRotation(SRange wholeRange, int rotation)
static void	setTextVAlign(SRange wholeRange, SCellStyle.VerticalAlignment vAlignment)
static void	setTextWrap(SRange wholeRange, boolean wraptext)
static void	setWholeColumnCellStyle(SRange range, WholeStyleUtil.StyleApplyer applyer)
static void	setWholeRowCellStyle(SRange range, WholeStyleUtil.StyleApplyer applyer)
static void	setWholeStyle(SRange range, WholeStyleUtil.StyleApplyer applyer)

Methods inherited from class java.lang.Object

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

Constructor Detail

WholeStyleUtil

public WholeStyleUtil()

Method Detail

setWholeStyle

public static void setWholeStyle(SRange range,
                                 WholeStyleUtil.StyleApplyer applyer)

setWholeRowCellStyle

public static void setWholeRowCellStyle(SRange range,
                                        WholeStyleUtil.StyleApplyer applyer)

setWholeColumnCellStyle

public static void setWholeColumnCellStyle(SRange range,
                                           WholeStyleUtil.StyleApplyer applyer)

setFillColor

public static void setFillColor(SRange wholeRange,
                                String htmlColor)

setFillOptions

public static void setFillOptions(SRange wholeRange,
                                  String backColor,
                                  String fillColor,
                                  SFill.FillPattern pattern)

setBackColor

public static void setBackColor(SRange wholeRange,
                                String htmlColor)

setTextHAlign

public static void setTextHAlign(SRange wholeRange,
                                 SCellStyle.Alignment hAlignment)

setTextVAlign

public static void setTextVAlign(SRange wholeRange,
                                 SCellStyle.VerticalAlignment vAlignment)

setTextWrap

public static void setTextWrap(SRange wholeRange,
                               boolean wraptext)

setDataFormat

public static void setDataFormat(SRange wholeRange,
                                 String format)

setFontName

public static void setFontName(SRange wholeRange,
                               String fontName)

setFontHeightPoints

public static void setFontHeightPoints(SRange wholeRange,
                                       int fontHeightPoints)

setFontBoldWeight

public static void setFontBoldWeight(SRange wholeRange,
                                     SFont.Boldweight fontBoldweight)

setFontItalic

public static void setFontItalic(SRange wholeRange,
                                 boolean italic)

setFontStrikethrough

public static void setFontStrikethrough(SRange wholeRange,
                                        boolean strikeout)

setFontUnderline

public static void setFontUnderline(SRange wholeRange,
                                    SFont.Underline fontUnderline)

setFontColor

public static void setFontColor(SRange wholeRange,
                                String htmlColor)

setFontTypeOffset

public static void setFontTypeOffset(SRange wholeRange,
                                     SFont.TypeOffset fontTypeOffset)

setTextRotation

public static void setTextRotation(SRange wholeRange,
                                   int rotation)

setTextIndentionOffset

public static void setTextIndentionOffset(SRange wholeRange,
                                          int offset)

setTextIndention

public static void setTextIndention(SRange wholeRange,
                                    int indention)