/*********************************************************************
*
* Copyright (C) 2004 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.write.biff;
import java.text.NumberFormat;
import jxl.common.Logger;
import jxl.NumberFormulaCell;
import jxl.biff.DoubleHelper;
import jxl.biff.FormulaData;
import jxl.biff.IntegerHelper;
import jxl.biff.formula.FormulaException;
import jxl.biff.formula.FormulaParser;
/**
* Class for read number formula records
*/
class ReadNumberFormulaRecord extends ReadFormulaRecord
implements NumberFormulaCell
{
// The logger
private static Logger logger = Logger.getLogger(ReadNumberFormulaRecord.class);
/**
* Constructor
*
* @param f
*/
public ReadNumberFormulaRecord(FormulaData f)
{
super(f);
}
/**
* Gets the double contents for this cell.
*
* @return the cell contents
*/
public double getValue()
{
return ( (NumberFormulaCell) getReadFormula()).getValue();
}
/**
* Gets the NumberFormat used to format this cell. This is the java
* equivalent of the Excel format
*
* @return the NumberFormat used to format the cell
*/
public NumberFormat getNumberFormat()
{
return ( (NumberFormulaCell) getReadFormula()).getNumberFormat();
}
/**
* Error formula specific exception handling. Can't really create
* a formula (as it will look for a cell of that name, so just
* create a STRING record containing the contents
*
* @return the bodged data
*/
protected byte[] handleFormulaException()
{
byte[] expressiondata = null;
byte[] celldata = super.getCellData();
// Generate an appropriate dummy formula
WritableWorkbookImpl w = getSheet().getWorkbook();
FormulaParser parser = new FormulaParser(Double.toString(getValue()), w, w,
w.getSettings());
// Get the bytes for the dummy formula
try
{
parser.parse();
}
catch(FormulaException e2)
{
logger.warn(e2.getMessage());
}
byte[] formulaBytes = parser.getBytes();
expressiondata = new byte[formulaBytes.length + 16];
IntegerHelper.getTwoBytes(formulaBytes.length, expressiondata, 14);
System.arraycopy(formulaBytes, 0, expressiondata, 16,
formulaBytes.length);
// Set the recalculate on load bit
expressiondata[8] |= 0x02;
byte[] data = new byte[celldata.length +
expressiondata.length];
System.arraycopy(celldata, 0, data, 0, celldata.length);
System.arraycopy(expressiondata, 0, data,
celldata.length, expressiondata.length);
// Store the value in the formula
DoubleHelper.getIEEEBytes(getValue(), data, 6);
return data;
}
}
|