/********************************************************************* * * Copyright (C) 2002 Andrew Khan * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library 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 for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA ***************************************************************************/ package jxl.read.biff; import java.text.NumberFormat; import jxl.CellType; import jxl.DateCell; import jxl.DateFormulaCell; import jxl.biff.FormattingRecords; import jxl.biff.FormulaData; import jxl.biff.WorkbookMethods; import jxl.biff.formula.ExternalSheet; import jxl.biff.formula.FormulaException; import jxl.biff.formula.FormulaParser; /** * A date formula's last calculated value */ class DateFormulaRecord extends DateRecord implements DateCell, FormulaData, DateFormulaCell { /** * The formula as an excel string */ private String formulaString; /** * A handle to the class needed to access external sheets */ private ExternalSheet externalSheet; /** * A handle to the name table */ private WorkbookMethods nameTable; /** * The raw data */ private byte[] data; /** * Constructs this object from the raw data * * @param t the basic number formula record * @param fr the formatting records * @param es the external sheet * @param nt the name table * @param nf flag indicating whether the 1904 date system is in use * @param si the sheet */ public DateFormulaRecord(NumberFormulaRecord t, FormattingRecords fr, ExternalSheet es, WorkbookMethods nt, boolean nf, SheetImpl si) throws FormulaException { super(t, t.getXFIndex(), fr, nf, si); externalSheet = es; nameTable = nt; data = t.getFormulaData(); } /** * Returns the cell type * * @return The cell type */ public CellType getType() { return CellType.DATE_FORMULA; } /** * Gets the raw bytes for the formula. This will include the * parsed tokens array. Used when copying spreadsheets * * @return the raw record data */ public byte[] getFormulaData() throws FormulaException { if (!getSheet().getWorkbookBof().isBiff8()) { throw new FormulaException(FormulaException.BIFF8_SUPPORTED); } // Data is already the formula data, so don't do any more manipulation return data; } /** * Gets the formula as an excel string * * @return the formula as an excel string * @exception FormulaException */ public String getFormula() throws FormulaException { // Note that the standard information was lopped off by the NumberFormula // record when creating this formula if (formulaString == null) { byte[] tokens = new byte[data.length - 16]; System.arraycopy(data, 16, tokens, 0, tokens.length); FormulaParser fp = new FormulaParser (tokens, this, externalSheet, nameTable, getSheet().getWorkbook().getSettings()); fp.parse(); formulaString = fp.getFormula(); } return formulaString; } /** * Interface method which returns the value * * @return the last calculated value of the formula */ public double getValue() { return 0; } /** * Dummy implementation in order to adhere to the NumberCell interface * * @return NULL */ public NumberFormat getNumberFormat() { return null; } }