Package org.xlsx4j.org.apache.poi.ss.usermodel

Class FractionFormat

java.lang.Object

java.text.Format

org.xlsx4j.org.apache.poi.ss.usermodel.FractionFormat

All Implemented Interfaces:

Serializable, Cloneable

public class FractionFormat
extends Format

Format class that handles Excel style fractions, such as "# #/#" and "#/###"

As of this writing, this is still not 100% accurate, but it does a reasonable job of trying to mimic Excel's fraction calculations. It does not currently maintain Excel's spacing.

This class relies on a method lifted nearly verbatim from org.apache.math.fraction. If further uses for Commons Math are found, we will consider adding it as a dependency. For now, we have in-lined the one method to keep things simple.

See Also:

• Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class java.text.Format

Format.Field

Field Summary

Fields

Modifier and Type	Field	Description
private static final Pattern	DENOM_FORMAT_PATTERN
private final int	exactDenom
private static final int	MAX_DENOM_POW
private final int	maxDenom
private final String	wholePartFormatString

Constructor Summary

Constructors

Constructor	Description
FractionFormat(String wholePartFormatString, String denomFormatString)	Single parameter ctor

Method Summary

Modifier and Type	Method	Description
String	format(Number num)
StringBuffer	format(Object obj, StringBuffer toAppendTo, FieldPosition pos)
Object	parseObject(String source, ParsePosition pos)

Methods inherited from class java.text.Format

clone, format, formatToCharacterIterator, parseObject

Methods inherited from class java.lang.Object

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

Field Details

DENOM_FORMAT_PATTERN

private static final Pattern DENOM_FORMAT_PATTERN

MAX_DENOM_POW

private static final int MAX_DENOM_POW

See Also:

• Constant Field Values

exactDenom

private final int exactDenom

maxDenom

private final int maxDenom

wholePartFormatString

private final String wholePartFormatString

Constructor Details

FractionFormat

public FractionFormat(String wholePartFormatString,
 String denomFormatString)

Single parameter ctor

Parameters:

denomFormatString - The format string for the denominator

Method Details

format

public String format(Number num)

format

public StringBuffer format(Object obj,
 StringBuffer toAppendTo,
 FieldPosition pos)

Specified by:

format in class Format

parseObject

public Object parseObject(String source,
 ParsePosition pos)

Specified by:

parseObject in class Format