com.vaadin.addon.spreadsheet

Class FormulaFormatter

java.lang.Object

com.vaadin.addon.spreadsheet.FormulaFormatter

All Implemented Interfaces:

Serializable

public class FormulaFormatter
extends Object
implements Serializable

Converts between a localized formula and a non-localized formula.

This is needed because internally POI only handles formulas with '.' as the decimal separator, and ',' as the argument separator.

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected class	FormulaFormatter.NumberToken
protected class	FormulaFormatter.SeparatorToken

Constructor Summary

Constructors

Constructor and Description
FormulaFormatter()

Method Summary

Modifier and Type	Method and Description
protected char	getCurrentDecimalSeparator(Locale locale)
protected DecimalFormat	getDecimalFormat(Locale locale)
boolean	isFormulaFormat(String value)
protected boolean	isNumberChar(Character current, Locale locale)
boolean	isValidFormulaFormat(String value, Locale locale) Rudimentary checks if the given string could be a valid formula
String	reFormatFormulaValue(String formulaValue, Locale locale) Convert from a non-localized format to a localized.
protected List<com.vaadin.addon.spreadsheet.FormulaFormatter.FormulaToken>	tokenizeFormula(String formulaValue, Locale from)
protected String	tokensToString(List<com.vaadin.addon.spreadsheet.FormulaFormatter.FormulaToken> tokens)
String	unFormatFormulaValue(String formulaValue, Locale locale) Convert from a localized format to a non-localized.
protected List<com.vaadin.addon.spreadsheet.FormulaFormatter.FormulaToken>	unLocalizeTokens(List<com.vaadin.addon.spreadsheet.FormulaFormatter.FormulaToken> tokens, Locale locale)

Methods inherited from class java.lang.Object

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

Constructor Detail

FormulaFormatter

public FormulaFormatter()

Method Detail

unFormatFormulaValue

public String unFormatFormulaValue(String formulaValue,
                                   Locale locale)

Convert from a localized format to a non-localized.

Parameters:

formulaValue - the value that should be converted

locale - the locale of the given value

Returns:

the non-localized formula

reFormatFormulaValue

public String reFormatFormulaValue(String formulaValue,
                                   Locale locale)

Convert from a non-localized format to a localized.

Parameters:

formulaValue - the value that should be converted

locale - the target locale

Returns:

the localized formula

isFormulaFormat

public boolean isFormulaFormat(String value)

isValidFormulaFormat

public boolean isValidFormulaFormat(String value,
                                    Locale locale)

Rudimentary checks if the given string could be a valid formula

Parameters:

value - whole formula as a string, must start with '=' or '+'

locale - the current locale

Returns:

true if the formula could be valid

tokensToString

protected String tokensToString(List<com.vaadin.addon.spreadsheet.FormulaFormatter.FormulaToken> tokens)

unLocalizeTokens

protected List<com.vaadin.addon.spreadsheet.FormulaFormatter.FormulaToken> unLocalizeTokens(List<com.vaadin.addon.spreadsheet.FormulaFormatter.FormulaToken> tokens,
                                                                                            Locale locale)

tokenizeFormula

protected List<com.vaadin.addon.spreadsheet.FormulaFormatter.FormulaToken> tokenizeFormula(String formulaValue,
                                                                                           Locale from)

isNumberChar

protected boolean isNumberChar(Character current,
                               Locale locale)

getDecimalFormat

protected DecimalFormat getDecimalFormat(Locale locale)

getCurrentDecimalSeparator

protected char getCurrentDecimalSeparator(Locale locale)