com.iisc.jwc.jsheet
Class CellStyle

java.lang.Object
  com.iisc.jwc.jsheet.CellStyle

All Implemented Interfaces:

java.io.Serializable

public class CellStyle

extends java.lang.Object

implements java.io.Serializable

CellStyle contains the formatting information for a cell.

See Also:

Serialized Form

Field Summary

static int	BORDER_DASH_DOT Dash dot border style.
static int	BORDER_DASH_DOT_DOT Dash dot dot border style.
static int	BORDER_DASHED Dashed border style.
static int	BORDER_DOTTED Dotted border style.
static int	BORDER_DOUBLE Double border style.
static int	BORDER_HAIR Hair border style.
static int	BORDER_LINE Line border style.
static int	BORDER_MED_DASH_DOT Medium dash dot border style.
static int	BORDER_MED_DASH_DOT_DOT Medium dash dot dot border style.
static int	BORDER_MED_DASHED Medium dashed border style.
static int	BORDER_MEDIUM Medium border style.
static int	BORDER_NONE No border.
static int	BORDER_SLANT_DASH_DOT Slash dash dot border style.
static int	BORDER_THICK Thick border style.
static int	BOTTOM_BORDER Bottom border edge.
static int	DIAGONAL_BORDER Diagonal border edge.
static int	DIAGONAL_BORDER_BOTH Diagonal border both (up and down).
static int	DIAGONAL_BORDER_DOWN Diagonal border down.
static int	DIAGONAL_BORDER_UP Diagonal border up.
static int	FONT_ACCOUNTING_DOUBLE Accounting double underline font style.
static int	FONT_ACCOUNTING_SINGLE Accounting single underline font style.
static int	FONT_BOLD Bold font style.
static int	FONT_ITALIC Italic font style.
static int	FONT_PLAIN Plain font style.
static int	FONT_STRIKE_THROUGH Strikethrough font style.
static int	FONT_SUBSCRIPT Subscript font style.
static int	FONT_SUPERSCRIPT Superscript font style.
static int	FONT_UNDERLINE_DOUBLE Double underline font style.
static int	FONT_UNDERLINE_SINGLE Single underline font style.
static int	FORMAT_CURRENCY Currency format type.
static int	FORMAT_CUSTOM Custom format type.
static int	FORMAT_DATE1 Date1 format type.
static int	FORMAT_DATE2 Date2 format type.
static int	FORMAT_DATE3 Date3 format type.
static int	FORMAT_DATE4 Date4 format type.
static int	FORMAT_DATE5 Date5 format type.
static int	FORMAT_FIXED Fixed format type.
static int	FORMAT_GENERAL General format type.
static int	FORMAT_PERCENT Percent format type.
static int	FORMAT_SCIENTIFIC Scientific format type.
static int	FORMAT_TIME1 Time1 format type.
static int	FORMAT_TIME2 Time2 format type.
static int	FORMAT_TIME3 Time3 format type.
static int	FORMAT_TIME4 Time4 format type.
static int	HALIGN_CENTER Center horizontal alignment.
static int	HALIGN_FILL Fill horizontal alignment.
static int	HALIGN_GENERAL General horizontal alignment.
static int	HALIGN_JUSTIFY Justify horizontal alignment.
static int	HALIGN_LEFT Left horizontal alignment.
static int	HALIGN_MASK Used by setAlignment to set horizontal alignment.
static int	HALIGN_RIGHT Right horizontal alignment.
static int	LEFT_BORDER Left border edge.
static int	RIGHT_BORDER Right border edge.
static int	TOP_BORDER Top border edge.
static int	VALIGN_BOTTOM Bottom vertical alignment.
static int	VALIGN_CENTER Center vertical alignment.
static int	VALIGN_JUSTIFY Justify vertical alignment.
static int	VALIGN_MASK Used by setAlignment to set vertical alignment.
static int	VALIGN_TOP Top vertical alignment.

Constructor Summary

CellStyle()
The empty constructor is for the JSClientProxy interactive applet, to allow the creation of a serializable version of this object to be used by JavaScript when communicating between browser client and server via HTTP.

Method Summary

void	addFontStyle(int style) Adds this font style to the current settings.
void	clearInclude() Clears the include flag.
int	getAlignment() Returns the alignment for the cell.
java.awt.Color	getBGColor() Returns the background color.
java.awt.Color	getBorderColor(int edge) Gets the border color for the specifed edge.
int	getBorderLineStyle(int edge) Gets the border line style for the specified edge.
com.iisc.jwc.orb.CStyle	getCStyle() FOR INTERNAL USE ONLY!
java.lang.String	getCustomFormat() Returns the custom format string, null if not used.
java.awt.Color	getFGColor() Returns the foreground color, this is used for the font color.
java.lang.String	getFontName() Returns the font name.
int	getFontSize() Returns the font size.
int	getFontStyle() Returns the font style.
int	getFormatType() Returns the format type.
int	getIndent() Returns the left indent for the cell.
int	getMergedFontStyle() Returns the new font style.
java.awt.Color	getNegativeColor() Returns the negative color for numeric values.
int	getOriginalFontStyle() Returns the original font style.
int	getPrecision() Returns the precision for a numeric value.
boolean	getShowZeros() Returns the setting for showing zeroes in cells.
boolean	getUseCommas() Returns the setting for showing commas.
boolean	getUseParens() Returns the setting for displaying parenthesis for negative numeric values.
boolean	getWrapText() Returns the setting for wrapped cell text.
void	removeFontStyle(int style) Remove the font style from the current settings.
void	setAlignment(int alignment) Sets the alignment.
void	setBGColor(java.awt.Color color) Sets the background color.
void	setBold() Adds the font style bold.
void	setBorders(int edge, int diagtype, java.awt.Color color, int lineStyle) Sets the borders for the cell.
void	setCustomFormat(java.lang.String format) Sets the string for a custom format for the cell.
void	setFGColor(java.awt.Color color) Sets the foreground color, this is used for the font color.
void	setFont(java.lang.String name, int style, int size) Sets new font information.
void	setFontName(java.lang.String name) Sets a new font name.
void	setFontSize(int size) Sets the font size.
void	setFontStyle(int style) Sets the style for the font.
void	setFormatType(int type) Sets the format type.
void	setIndent(int indent) Sets the left indent for a cell if HALIGN_LEFT is set for the alignment.
void	setItalic() Adds the font style italic.
void	setNegativeColor(java.awt.Color color) Sets the color for a negative numeric value.
void	setPrecision(int precision) Sets the precision for a numeric value.
void	setShowZeros(boolean set) Defines the setting for showing data in cells that contain zeros.
void	setUnderline() Adds the font style single underline.
void	setUseCommas(boolean set) Defines the setting for showing commas in numbers that have more than three digits.
void	setUseParens(boolean set) Defines the setting for displaying parenthesis for negative numeric values.
void	setWrapText(boolean wrap) Allows the text to wrap in a cell if it is too long to fit horizontally.

Methods inherited from class java.lang.Object

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

Field Detail

BORDER_DASH_DOT

public static final int BORDER_DASH_DOT

Dash dot border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_DASH_DOT_DOT

public static final int BORDER_DASH_DOT_DOT

Dash dot dot border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_DASHED

public static final int BORDER_DASHED

Dashed border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_DOTTED

public static final int BORDER_DOTTED

Dotted border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_DOUBLE

public static final int BORDER_DOUBLE

Double border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_HAIR

public static final int BORDER_HAIR

Hair border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_LINE

public static final int BORDER_LINE

Line border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_MED_DASH_DOT

public static final int BORDER_MED_DASH_DOT

Medium dash dot border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_MED_DASH_DOT_DOT

public static final int BORDER_MED_DASH_DOT_DOT

Medium dash dot dot border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_MED_DASHED

public static final int BORDER_MED_DASHED

Medium dashed border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_MEDIUM

public static final int BORDER_MEDIUM

Medium border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_NONE

public static final int BORDER_NONE

No border.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_SLANT_DASH_DOT

public static final int BORDER_SLANT_DASH_DOT

Slash dash dot border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BORDER_THICK

public static final int BORDER_THICK

Thick border style.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

BOTTOM_BORDER

public static final int BOTTOM_BORDER

Bottom border edge.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

DIAGONAL_BORDER

public static final int DIAGONAL_BORDER

Diagonal border edge.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

DIAGONAL_BORDER_BOTH

public static final int DIAGONAL_BORDER_BOTH

Diagonal border both (up and down).

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

DIAGONAL_BORDER_DOWN

public static final int DIAGONAL_BORDER_DOWN

Diagonal border down.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

DIAGONAL_BORDER_UP

public static final int DIAGONAL_BORDER_UP

Diagonal border up.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

FONT_ACCOUNTING_DOUBLE

public static final int FONT_ACCOUNTING_DOUBLE

Accounting double underline font style.

See Also:

setFontStyle(int), Constant Field Values

FONT_ACCOUNTING_SINGLE

public static final int FONT_ACCOUNTING_SINGLE

Accounting single underline font style.

See Also:

setFontStyle(int), Constant Field Values

FONT_BOLD

public static final int FONT_BOLD

Bold font style.

See Also:

setFontStyle(int), Constant Field Values

FONT_ITALIC

public static final int FONT_ITALIC

Italic font style.

See Also:

setFontStyle(int), Constant Field Values

FONT_PLAIN

public static final int FONT_PLAIN

Plain font style.

See Also:

setFontStyle(int), Constant Field Values

FONT_STRIKE_THROUGH

public static final int FONT_STRIKE_THROUGH

Strikethrough font style.

See Also:

setFontStyle(int), Constant Field Values

FONT_SUBSCRIPT

public static final int FONT_SUBSCRIPT

Subscript font style.

See Also:

setFontStyle(int), Constant Field Values

FONT_SUPERSCRIPT

public static final int FONT_SUPERSCRIPT

Superscript font style.

See Also:

setFontStyle(int), Constant Field Values

FONT_UNDERLINE_DOUBLE

public static final int FONT_UNDERLINE_DOUBLE

Double underline font style.

See Also:

setFontStyle(int), Constant Field Values

FONT_UNDERLINE_SINGLE

public static final int FONT_UNDERLINE_SINGLE

Single underline font style.

See Also:

setFontStyle(int), Constant Field Values

FORMAT_CURRENCY

public static final int FORMAT_CURRENCY

Currency format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_CUSTOM

public static final int FORMAT_CUSTOM

Custom format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_DATE1

public static final int FORMAT_DATE1

Date1 format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_DATE2

public static final int FORMAT_DATE2

Date2 format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_DATE3

public static final int FORMAT_DATE3

Date3 format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_DATE4

public static final int FORMAT_DATE4

Date4 format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_DATE5

public static final int FORMAT_DATE5

Date5 format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_FIXED

public static final int FORMAT_FIXED

Fixed format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_GENERAL

public static final int FORMAT_GENERAL

General format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_PERCENT

public static final int FORMAT_PERCENT

Percent format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_SCIENTIFIC

public static final int FORMAT_SCIENTIFIC

Scientific format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_TIME1

public static final int FORMAT_TIME1

Time1 format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_TIME2

public static final int FORMAT_TIME2

Time2 format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_TIME3

public static final int FORMAT_TIME3

Time3 format type.

See Also:

setFormatType(int), Constant Field Values

FORMAT_TIME4

public static final int FORMAT_TIME4

Time4 format type.

See Also:

setFormatType(int), Constant Field Values

HALIGN_CENTER

public static final int HALIGN_CENTER

Center horizontal alignment.

See Also:

setAlignment(int), Constant Field Values

HALIGN_FILL

public static final int HALIGN_FILL

Fill horizontal alignment.

See Also:

setAlignment(int), Constant Field Values

HALIGN_GENERAL

public static final int HALIGN_GENERAL

General horizontal alignment.

See Also:

setAlignment(int), Constant Field Values

HALIGN_JUSTIFY

public static final int HALIGN_JUSTIFY

Justify horizontal alignment.

See Also:

setAlignment(int), Constant Field Values

HALIGN_LEFT

public static final int HALIGN_LEFT

Left horizontal alignment.

See Also:

setAlignment(int), Constant Field Values

HALIGN_MASK

public static final int HALIGN_MASK

Used by setAlignment to set horizontal alignment.

See Also:

setAlignment(int), Constant Field Values

HALIGN_RIGHT

public static final int HALIGN_RIGHT

Right horizontal alignment.

See Also:

setAlignment(int), Constant Field Values

LEFT_BORDER

public static final int LEFT_BORDER

Left border edge.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

RIGHT_BORDER

public static final int RIGHT_BORDER

Right border edge.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

TOP_BORDER

public static final int TOP_BORDER

Top border edge.

See Also:

setBorders(int, int, java.awt.Color, int), Constant Field Values

VALIGN_BOTTOM

public static final int VALIGN_BOTTOM

Bottom vertical alignment.

See Also:

setAlignment(int), Constant Field Values

VALIGN_CENTER

public static final int VALIGN_CENTER

Center vertical alignment.

See Also:

setAlignment(int), Constant Field Values

VALIGN_JUSTIFY

public static final int VALIGN_JUSTIFY

Justify vertical alignment.

See Also:

setAlignment(int), Constant Field Values

VALIGN_MASK

public static final int VALIGN_MASK

Used by setAlignment to set vertical alignment.

See Also:

setAlignment(int), Constant Field Values

VALIGN_TOP

public static final int VALIGN_TOP

Top vertical alignment.

See Also:

setAlignment(int), Constant Field Values

Constructor Detail

CellStyle

public CellStyle()

The empty constructor is for the JSClientProxy interactive applet, to allow the creation of a serializable version of this object to be used by JavaScript when communicating between browser client and server via HTTP. NOTE: right now the Javascript calls the getBGColor method directly, and gets away with it here because there is no underlying CORBA reference to the server side. It appears that the other methods in this object will have the same results.

Method Detail

addFontStyle

public void addFontStyle(int style)

Adds this font style to the current settings.

Parameters:

style - style flags for the font.

See Also:

setFontStyle(int)

clearInclude

public void clearInclude()

Clears the include flag.

getAlignment

public int getAlignment()

Returns the alignment for the cell.

Returns:

Alignment for the cell.

See Also:

setAlignment(int)

getBGColor

public java.awt.Color getBGColor()

Returns the background color.

Returns:

the background color.

getBorderColor

public java.awt.Color getBorderColor(int edge)

Gets the border color for the specifed edge.

Parameters:

edge - the edge to which the settings refer.

LEFT_BORDER	0	Left border edge.
RIGHT_BORDER	1	Right border edge.
TOP_BORDER	2	Top border edge.
BOTTOM_BORDER	3	Bottom border edge.
DIAGONAL_BORDER	4	Diagonal border edge.

Returns:

the border color.

See Also:

setBorders(int, int, java.awt.Color, int)

getBorderLineStyle

public int getBorderLineStyle(int edge)

Gets the border line style for the specified edge.

Parameters:

edge - the edge to which the settings refer.

LEFT_BORDER	0	Left border edge.
RIGHT_BORDER	1	Right border edge.
TOP_BORDER	2	Top border edge.
BOTTOM_BORDER	3	Bottom border edge.
DIAGONAL_BORDER	4	Diagonal border edge.

Returns:

the border style.

See Also:

setBorders(int, int, java.awt.Color, int)

getCStyle

public com.iisc.jwc.orb.CStyle getCStyle()

FOR INTERNAL USE ONLY!

getCustomFormat

public java.lang.String getCustomFormat()

Returns the custom format string, null if not used.

Returns:

the custom format string.

getFGColor

public java.awt.Color getFGColor()

Returns the foreground color, this is used for the font color.

Returns:

the foreground color.

getFontName

public java.lang.String getFontName()

Returns the font name.

Returns:

the font name.

getFontSize

public int getFontSize()

Returns the font size.

Returns:

the size of the font.

getFontStyle

public int getFontStyle()

Returns the font style.

Returns:

the font style.

See Also:

setFontStyle(int)

getFormatType

public int getFormatType()

Returns the format type.

Available format types and associated int values are:

TYPE NAME	INTVALUE	FORMAT Example
-------------------------	-------------	--------------------
FORMAT_CURRENCY	1	$1,234.00
FORMAT_DATE1	2	4-Mar-98
FORMAT_DATE2	3	4-Mar
FORMAT_DATE3	4	Mar-98
FORMAT_DATE4	5	03-04-98
FORMAT_DATE5	6	03-98
FORMAT_FIXED	7	123.45
FORMAT_GENERAL	8	12345
FORMAT_PERCENT	9	1234.00%
FORMAT_SCIENTIFIC	10	1.23E+04
FORMAT_TIME1	12	1:30:55 PM
FORMAT_TIME2	13	1:30 PM
FORMAT_TIME3	14	1:30:55
FORMAT_TIME4	15	13:30
FORMAT_CUSTOM	16	Custom format type.

Returns:

the format type.

See Also:

setFormatType(int)

getIndent

public int getIndent()

Returns the left indent for the cell.

Returns:

left indent for the cell.

getMergedFontStyle

public int getMergedFontStyle()

Returns the new font style.

Returns:

the new font style.

getNegativeColor

public java.awt.Color getNegativeColor()

Returns the negative color for numeric values.

Returns:

the negative color.

getOriginalFontStyle

public int getOriginalFontStyle()

Returns the original font style.

Returns:

original font style.

getPrecision

public int getPrecision()

Returns the precision for a numeric value.

Returns:

the precision for a numeric value.

getShowZeros

public boolean getShowZeros()

Returns the setting for showing zeroes in cells.

Returns:

setting for showing zeros in cells.

getUseCommas

public boolean getUseCommas()

Returns the setting for showing commas.

Returns:

setting for showing commas.

getUseParens

public boolean getUseParens()

Returns the setting for displaying parenthesis for negative numeric values.

Returns:

setting for displaying parenthesis for negative numeric values.

getWrapText

public boolean getWrapText()

Returns the setting for wrapped cell text.

Returns:

the wrap setting for the cell.

removeFontStyle

public void removeFontStyle(int style)

Remove the font style from the current settings.

Parameters:

style - style flags for the font.

See Also:

setFontStyle(int)

setAlignment

public void setAlignment(int alignment)

Sets the alignment.

Parameters:

alignment - the cell alignment bits.

Combine the following:

HALIGN_GENERAL	1	General horizontal alignment.
HALIGN_LEFT	2	Left horizontal alignment.
HALIGN_CENTER	3	Center horizontal alignment.
HALIGN_RIGHT	4	Right horizontal alignment.
HALIGN_JUSTIFY	5	Justify horizontal alignment.
HALIGN_FILL	6	Fill horizontal alignment.
HALIGN_MASK	15	Required to set horizontal alignment.
VALIGN_TOP	16	Top vertical alignment.
VALIGN_BOTTOM	32	Bottom vertical alignment.
VALIGN_CENTER	48	Center vertical alignment.
VALIGN_JUSTIFY	64	Justify vertical alignment.
VALIGN_MASK	240	Required to set vertical alignment.

setBGColor

public void setBGColor(java.awt.Color color)

Sets the background color.

Parameters:

color - the color to use.

setBold

public void setBold()

Adds the font style bold.

setBorders

public void setBorders(int edge,
                       int diagtype,
                       java.awt.Color color,
                       int lineStyle)

Sets the borders for the cell.

Parameters:

edge - the edge to which the settings refer.

LEFT_BORDER	0	Left border edge.
RIGHT_BORDER	1	Right border edge.
TOP_BORDER	2	Top border edge.
BOTTOM_BORDER	3	Bottom border edge.
DIAGONAL_BORDER	4	Diagonal border edge.

diagtype - the diagonal style. DIAGONAL_BORDER_DOWN32Diagonal border down. DIAGONAL_BORDER_UP64Diagonal border up. DIAGONAL_BORDER_BOTH96Diagonal border both (up and down).

color - the color.

lineStyle - the line style. BORDER_NONE0No border. BORDER_LINE1Line border style. BORDER_MEDIUM2Medium border style. BORDER_DASHED3Dashed border style. BORDER_DOTTED4Dotted border style. BORDER_THICK5Thick border style. BORDER_DOUBLE6Double border style. BORDER_HAIR7Hair border style. BORDER_MED_DASHED8Medium dashed border style. BORDER_DASH_DOT9Dash dot border style. BORDER_MED_DASH_DOT10Medium dash dot border style. BORDER_DASH_DOT_DOT11Dash dot dot border style. BORDER_MED_DASH_DOT_DOT12Medium dash dot dot border style. BORDER_SLANT_DASH_DOT13Slash dash dot border style.

setCustomFormat

public void setCustomFormat(java.lang.String format)

Sets the string for a custom format for the cell.

Parameters:

format - the custom format string.

setFGColor

public void setFGColor(java.awt.Color color)

Sets the foreground color, this is used for the font color.

Parameters:

color - the color to use.

setFont

public void setFont(java.lang.String name,
                    int style,
                    int size)

Sets new font information.

Parameters:

name - font name.

style - style flags for the font.

size - point size of the font.

See Also:

setFontName(java.lang.String), setFontStyle(int), setFontSize(int)

setFontName

public void setFontName(java.lang.String name)

Sets a new font name.

Parameters:

name - the name of the font.

setFontSize

public void setFontSize(int size)

Sets the font size.

Parameters:

size - the point size.

setFontStyle

public void setFontStyle(int style)

Sets the style for the font.

Parameters:

style - the font style bits.

Combine the following:

FONT_PLAIN	0	Plain font style.
FONT_BOLD	1	Bold font style.
FONT_ITALIC	2	Italic font style.
FONT_STRIKE_THROUGH	4	Strike through font style.
FONT_SUBSCRIPT	8	Subscript font style.
FONT_SUPERSCRIPT	16	Superscript font style.
FONT_UNDERLINE_SINGLE	32	Single underline font style.
FONT_UNDERLINE_DOUBLE	64	Double underline font style.
FONT_ACCOUNTING_SINGLE	256	Accounting single underline font style.
FONT_ACCOUNTING_DOUBLE	512	Accounting double underline font style.

setFormatType

public void setFormatType(int type)

Sets the format type.

Parameters:

type - which numeric formatting type to use.

TYPE NAME	INTVALUE	FORMAT Example
-------------------------	-------------	--------------------
FORMAT_CURRENCY	1	$1,234.00
FORMAT_DATE1	2	4-Mar-98
FORMAT_DATE2	3	4-Mar
FORMAT_DATE3	4	Mar-98
FORMAT_DATE4	5	03-04-98
FORMAT_DATE5	6	03-98
FORMAT_FIXED	7	123.45
FORMAT_GENERAL	8	12345
FORMAT_PERCENT	9	1234.00%
FORMAT_SCIENTIFIC	10	1.23E+04
FORMAT_TIME1	12	1:30:55 PM
FORMAT_TIME2	13	1:30 PM
FORMAT_TIME3	14	1:30:55
FORMAT_TIME4	15	13:30
FORMAT_CUSTOM	16	Custom format type.

setIndent

public void setIndent(int indent)

Sets the left indent for a cell if HALIGN_LEFT is set for the alignment.

Parameters:

indent - the indent size in pixels.

setItalic

public void setItalic()

Adds the font style italic.

setNegativeColor

public void setNegativeColor(java.awt.Color color)

Sets the color for a negative numeric value.

Parameters:

color - the color for the number.

setPrecision

public void setPrecision(int precision)

Sets the precision for a numeric value.

Parameters:

precision - the precision for a numeric value.

setShowZeros

public void setShowZeros(boolean set)

Defines the setting for showing data in cells that contain zeros.

Parameters:

set - if true, show the zeroes.

setUnderline

public void setUnderline()

Adds the font style single underline.

setUseCommas

public void setUseCommas(boolean set)

Defines the setting for showing commas in numbers that have more than three digits.

Parameters:

set - if true show the commas.

setUseParens

public void setUseParens(boolean set)

Defines the setting for displaying parenthesis for negative numeric values.

Parameters:

set - if true, show parenthesis.

setWrapText

public void setWrapText(boolean wrap)

Allows the text to wrap in a cell if it is too long to fit horizontally.

Parameters:

wrap - if true, wrap the text.