org.zkoss.poi.ss.formula

Class FormulaRenderer

java.lang.Object

org.zkoss.poi.ss.formula.FormulaRenderer

public class FormulaRenderer
extends Object

Common logic for rendering formulas.
For POI internal use only

Author:

Josh Micich

Constructor Summary

Constructors

Constructor and Description
FormulaRenderer()

Method Summary

Modifier and Type	Method and Description
static String	toFormulaCopyText(FormulaRenderingWorkbook book, Ptg[] tokens, String formula)
static String	toFormulaEditText(FormulaRenderingWorkbook book, Ptg[] tokens, String formula)
static String	toFormulaString(FormulaRenderingWorkbook book, Ptg[] ptgs) Static method to convert an array of Ptgs in RPN order to a human readable string format in infix mode.
static String	toInternalFormulaString(FormulaRenderingWorkbook book, Ptg[] ptgs) Static method to convert an array of Ptgs in RPN order to internal string format for storing into file.
static Ptg[][]	unwrapPtgArrays(Ptg[] ptgs) Static method to convert an RPN ptgs in the form of (areaPtg1, areaPtg2, ...) to Ptg[][].

Methods inherited from class java.lang.Object

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

Constructor Detail

FormulaRenderer

public FormulaRenderer()

Method Detail

toFormulaString

public static String toFormulaString(FormulaRenderingWorkbook book,
                                     Ptg[] ptgs)

Static method to convert an array of Ptgs in RPN order to a human readable string format in infix mode.

Parameters:

book - used for defined names and 3D references

ptgs - must not be null

Returns:

a human readable String

toInternalFormulaString

public static String toInternalFormulaString(FormulaRenderingWorkbook book,
                                             Ptg[] ptgs)

Static method to convert an array of Ptgs in RPN order to internal string format for storing into file.

Parameters:

book - used for defined names and 3D references

ptgs - must not be null

Returns:

a human readable String

toFormulaEditText

public static String toFormulaEditText(FormulaRenderingWorkbook book,
                                       Ptg[] tokens,
                                       String formula)

unwrapPtgArrays

public static Ptg[][] unwrapPtgArrays(Ptg[] ptgs)

Static method to convert an RPN ptgs in the form of (areaPtg1, areaPtg2, ...) to Ptg[][].

Parameters:

book - used for defined names and 3D references

ptgs - must not be null

Returns:

a human readable String

Since:

3.9.6

toFormulaCopyText

public static String toFormulaCopyText(FormulaRenderingWorkbook book,
                                       Ptg[] tokens,
                                       String formula)