1 files changed, 0 insertions, 153 deletions
diff --git a/xmerge/java/org/openoffice/xmerge/converter/xml/sxc/pexcel/records/formula/FormulaHelper.java b/xmerge/java/org/openoffice/xmerge/converter/xml/sxc/pexcel/records/formula/FormulaHelper.java
deleted file mode 100644
index 1752d0e6336e..000000000000
--- a/xmerge/java/org/openoffice/xmerge/converter/xml/sxc/pexcel/records/formula/FormulaHelper.java
+++ /dev/null
@@ -1,153 +0,0 @@
-/************************************************************************
- *
- * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- *
- * Copyright 2000, 2010 Oracle and/or its affiliates.
- *
- * OpenOffice.org - a multi-platform office productivity suite
- *
- * This file is part of OpenOffice.org.
- *
- * OpenOffice.org is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Lesser General Public License version 3
- * only, as published by the Free Software Foundation.
- *
- * OpenOffice.org is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
- * GNU Lesser General Public License version 3 for more details
- * (a copy is included in the LICENSE file that accompanied this code).
- *
- * You should have received a copy of the GNU Lesser General Public License
- * version 3 along with OpenOffice.org.  If not, see
- * <http://www.openoffice.org/license.html>
- * for a copy of the LGPLv3 License.
- *
- ************************************************************************/
-
-package org.openoffice.xmerge.converter.xml.sxc.pexcel.records.formula;
-
-import java.io.ByteArrayOutputStream;
-import java.io.IOException;
-import java.util.Vector;
-import java.util.Enumeration;
-
-import org.openoffice.xmerge.util.Debug;
-import org.openoffice.xmerge.converter.xml.sxc.pexcel.records.Workbook;
-
-/**
- * This Helper class provides a simplified interface to conversion between PocketXL formula representation
- * and Calc formula representation.<p>
- * The class is used by {@link org.openoffice.xmerge.converter.xml.sxc.pexcel.Records.Formula}
- */
-public class FormulaHelper {
-
-    private static FormulaParser parser;
-    private static FormulaCompiler compiler;
-    private static TokenEncoder encoder;
-    private static TokenDecoder decoder;
-    private boolean rangeType = false;
-    private boolean expressionType = false;
-
-    static {
-        parser   = new FormulaParser();
-        compiler = new FormulaCompiler();
-        encoder = new TokenEncoder();
-        decoder  = new TokenDecoder();
-    }
-
-    /**
-     * Sets the workbook cache so that global data such as
-     * <code>DefinedNames</code>, <code>Boundsheets</code> can be read
-     *
-     * @param wb Wrokbook object containing all the global data
-     */
-    public void setWorkbook(Workbook wb) {
-
-        encoder.setWorkbook(wb);
-        decoder.setWorkbook(wb);
-        parser.setWorkbook(wb);
-    }
-
-    /**
-     * Convertes a string representation of a calc formula into an array of PocketXL bytes
-     * @param   formula The Formula String (e.g. 1+SUM(A1,B1))
-     *
-     * @throws  UnsupportedFunctionException    Thrown if a function in the formula is nto supported by Pocket Excel
-     * @throws  FormulaParsingException Thrown when the formula is not well formed
-     *
-     */
-    public byte[] convertCalcToPXL(String formula) throws UnsupportedFunctionException, FormulaParsingException {
-
-        Vector parseTokens = parser.parse(formula);
-        Vector rpnTokens = compiler.infix2RPN(parseTokens);
-
-        ByteArrayOutputStream bytes = null;
-        try {
-            bytes = new ByteArrayOutputStream();
-            for (Enumeration e = rpnTokens.elements(); e.hasMoreElements();) {
-                Token t = (Token)e.nextElement();
-                bytes.write(encoder.getByte(t));
-            }
-        } catch (IOException e) {
-        }
-
-        return bytes.toByteArray();
-    }
-
-    /**
-     * Converts a PocketXL byte array into a Calc function string
-     * @param   formula A byte array that contains the PocketXL bytes for a formula
-     *
-     */
-    public String convertPXLToCalc(byte[] formula) {
-
-        Vector parseTokens = decoder.getTokenVector(formula);
-        Vector infixTokens = compiler.RPN2Infix(parseTokens);
-
-        StringBuffer buff = new StringBuffer();
-        for (Enumeration e = infixTokens.elements();e.hasMoreElements();) {
-            Token t = (Token)e.nextElement();
-            buff.append(t.toString());
-            // If we are parsing a Name definition we need to know if it is of
-            // type range or expression
-            if(!t.isOperand()) {
-                expressionType = true;
-            }
-        }
-        if(!expressionType) {
-            rangeType = true;
-        }
-        return "=" + buff.toString();
-    }
-
-    /**
-     * Returns a boolean indicating whether or not the byte[] parsed is of
-     * type range. This means it contains only a cell reference and no
-     * operators. This is necessry because the syntax for range and expression
-     * types differs. This is only of interest when dealing with
-     * <code>DefinedNames</code> and not <code>Formula</code>
-     *
-     * @return a boolean true if of type range otherwise false
-     *
-     */
-     public boolean isRangeType() {
-
-        return rangeType;
-    }
-
-    /**
-     * Returns a boolean indicating whether or not the byte[] parsed is of
-     * type expression. This means it contains operators. This is necessry
-     * because the syntax for range and expression types differs. This is
-     * only of interest when dealing with <code>DefinedNames</code> and not
-     * <code>Formula</code>
-     *
-     * @return a boolean true if of type expression otherwise false
-     *
-     */
-     public boolean isExpressionType() {
-
-        return expressionType;
-    }
-}