Module io.github.tonywasher.joceanus.prometheus.sheet.api

Package io.github.tonywasher.joceanus.prometheus.service.sheet

Class PrometheusSheetFormats

java.lang.Object

io.github.tonywasher.joceanus.prometheus.service.sheet.PrometheusSheetFormats

public final class PrometheusSheetFormats
extends Object

Excel/Oasis format string builder class.

Field Summary

Fields

Modifier and Type	Field	Description
(package private) static final int	ACCOUNTING_WIDTH	Money accounting format width.
static final int	FONT_HEIGHT	Font Height.
static final String	FONT_NUMERIC	Numeric Font.
static final String	FONT_VALUE	Value Font.
(package private) static final String	OASIS_DATE	Oasis date format.
static final int	WIDTH_BOOL	Boolean width.
static final int	WIDTH_DATE	Date width.
static final int	WIDTH_DILUTION	Dilution width.
static final int	WIDTH_INT	Integer width.
static final int	WIDTH_MONEY	Money width.
static final int	WIDTH_PRICE	Price width.
static final int	WIDTH_RATE	Rate width.
static final int	WIDTH_RATIO	Ratio width.
static final int	WIDTH_STRING	String width.
static final int	WIDTH_UNITS	Units width.

Method Summary

Modifier and Type	Method	Description
static String	getAlternateFormatName(Object pValue)	Obtain currency format name for a cell.
static String	getAlternateFormatString(Object pValue)	Obtain alternate data format string for a cell value.
static PrometheusSheetCellStyleType	getCellStyleType(Object pValue)	Obtain data format for a value.
static String	getDataFormatString(PrometheusSheetCellStyleType pType)	Obtain data format string for a cell type.
static String	getDataFormatString(Object pValue)	Obtain data format string for a cell value.
static Object	getDefaultValue(PrometheusSheetCellStyleType pType)	Obtain default value for a cell type.
static String	getFormatName(PrometheusSheetCellStyleType pType)	Obtain data format string for a cell type.
static String	getFormatName(Object pValue)	Obtain format name for a cell.
static boolean	hasDataFormat(PrometheusSheetCellStyleType pType)	Determine whether cell type has data format.

Methods inherited from class java.lang.Object

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

Field Details

ACCOUNTING_WIDTH

static final int ACCOUNTING_WIDTH

Money accounting format width.

See Also:

• Constant Field Values

WIDTH_DATE

public static final int WIDTH_DATE

Date width.

See Also:

• Constant Field Values

WIDTH_INT

public static final int WIDTH_INT

Integer width.

See Also:

• Constant Field Values

WIDTH_BOOL

public static final int WIDTH_BOOL

Boolean width.

See Also:

• Constant Field Values

WIDTH_MONEY

public static final int WIDTH_MONEY

Money width.

See Also:

• Constant Field Values

WIDTH_UNITS

public static final int WIDTH_UNITS

Units width.

See Also:

• Constant Field Values

WIDTH_RATE

public static final int WIDTH_RATE

Rate width.

See Also:

• Constant Field Values

WIDTH_DILUTION

public static final int WIDTH_DILUTION

Dilution width.

See Also:

• Constant Field Values

WIDTH_RATIO

public static final int WIDTH_RATIO

Ratio width.

See Also:

• Constant Field Values

WIDTH_PRICE

public static final int WIDTH_PRICE

Price width.

See Also:

• Constant Field Values

WIDTH_STRING

public static final int WIDTH_STRING

String width.

See Also:

• Constant Field Values

FONT_HEIGHT

public static final int FONT_HEIGHT

Font Height.

See Also:

• Constant Field Values

FONT_VALUE

public static final String FONT_VALUE

Value Font.

See Also:

• Constant Field Values

FONT_NUMERIC

public static final String FONT_NUMERIC

Numeric Font.

See Also:

• Constant Field Values

OASIS_DATE

static final String OASIS_DATE

Oasis date format.

See Also:

• Constant Field Values

Method Details

getDataFormatString

public static String getDataFormatString(PrometheusSheetCellStyleType pType)

Obtain data format string for a cell type.

Parameters:

pType - the cell style type

Returns:

the format string

getDefaultValue

public static Object getDefaultValue(PrometheusSheetCellStyleType pType)

Obtain default value for a cell type.

Parameters:

pType - the cell style type

Returns:

the format string

getDataFormatString

public static String getDataFormatString(Object pValue)

Obtain data format string for a cell value.

Parameters:

pValue - the cell value

Returns:

the format string

getAlternateFormatString

public static String getAlternateFormatString(Object pValue)

Obtain alternate data format string for a cell value.

Parameters:

pValue - the cell value

Returns:

the format string

getFormatName

public static String getFormatName(PrometheusSheetCellStyleType pType)

Obtain data format string for a cell type.

Parameters:

pType - the cell style type

Returns:

the format string

getFormatName

public static String getFormatName(Object pValue)

Obtain format name for a cell.

Parameters:

pValue - the cell value

Returns:

the format string

getAlternateFormatName

public static String getAlternateFormatName(Object pValue)

Obtain currency format name for a cell.

Parameters:

pValue - the cell value

Returns:

the format string

hasDataFormat

public static boolean hasDataFormat(PrometheusSheetCellStyleType pType)

Determine whether cell type has data format.

Parameters:

pType - the cell type

Returns:

true/false

getCellStyleType

public static PrometheusSheetCellStyleType getCellStyleType(Object pValue)

Obtain data format for a value.

Parameters:

pValue - the cell value

Returns:

the cell style type