org.zkoss.poi.ss.formula

Class FormulaRenderer

java.lang.Object

org.zkoss.poi.ss.formula.FormulaRenderer

public class FormulaRenderer
extends java.lang.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 java.lang.String	toFormulaCopyText(FormulaRenderingWorkbook book, Ptg[] tokens, java.lang.String formula)
static java.lang.String	toFormulaEditText(FormulaRenderingWorkbook book, Ptg[] tokens, java.lang.String formula)
static java.lang.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 java.lang.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 java.lang.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 java.lang.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 java.lang.String toFormulaEditText(FormulaRenderingWorkbook book,
                                                 Ptg[] tokens,
                                                 java.lang.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 java.lang.String toFormulaCopyText(FormulaRenderingWorkbook book,
                                                 Ptg[] tokens,
                                                 java.lang.String formula)