org.apache.poi.ss.formula.functions

Class Roman

java.lang.Object

org.apache.poi.ss.formula.functions.Fixed2ArgFunction

org.apache.poi.ss.formula.functions.Roman

All Implemented Interfaces:

Function, Function2Arg

public class Roman
extends Fixed2ArgFunction

Implementation for Excel Roman() function.

Syntax:
Roman (number,form)

Converts an arabic numeral to roman, as text.

Number Required. The Arabic numeral you want converted.

Form Optional. A number specifying the type of roman numeral you want. The roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases.

Return_type a roman numeral, as text

Constructor Summary

Constructors

Constructor and Description
Roman()

Method Summary

Modifier and Type	Method and Description
ValueEval	evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE, ValueEval formVE) see Function.evaluate(ValueEval[], int, int)
java.lang.String	makeConcise(java.lang.String input, int form) Use conversion rule to factor some parts and make them more concise

Methods inherited from class org.apache.poi.ss.formula.functions.Fixed2ArgFunction

evaluate

Methods inherited from class java.lang.Object

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

Constructor Detail

Roman

public Roman()

Method Detail

evaluate

public ValueEval evaluate(int srcRowIndex,
                          int srcColumnIndex,
                          ValueEval numberVE,
                          ValueEval formVE)

Description copied from interface: Function2Arg

see Function.evaluate(ValueEval[], int, int)

makeConcise

public java.lang.String makeConcise(java.lang.String input,
                                    int form)

Use conversion rule to factor some parts and make them more concise

Parameters:

input - the input string

form - the level of conciseness [0..4] with 4 being most concise and simplified