/*********************************************************************
*
* 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 jxl.common.Logger;
import jxl.ErrorFormulaCell;
import jxl.biff.FormulaData;
import jxl.biff.IntegerHelper;
import jxl.biff.formula.FormulaErrorCode;
import jxl.biff.formula.FormulaException;
import jxl.biff.formula.FormulaParser;
/**
* Class for read number formula records
*/
class ReadErrorFormulaRecord extends ReadFormulaRecord
implements ErrorFormulaCell
{
// The logger
private static Logger logger = Logger.getLogger(ReadErrorFormulaRecord.class);
/**
* Constructor
*
* @param f
*/
public ReadErrorFormulaRecord(FormulaData f)
{
super(f);
}
/**
* Gets the error code for this cell.
*
* @return the cell contents
*/
public int getErrorCode()
{
return ( (ErrorFormulaCell) getReadFormula()).getErrorCode();
}
/**
* 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();
int errorCode = getErrorCode();
String formulaString = null;
if (errorCode == FormulaErrorCode.DIV0.getCode())
{
formulaString = "1/0";
}
else if (errorCode == FormulaErrorCode.VALUE.getCode())
{
formulaString = "\"\"/0";
}
else if (errorCode == FormulaErrorCode.REF.getCode())
{
formulaString = "\"#REF!\"";
}
else
{
formulaString = "\"ERROR\"";
}
// Generate an appropriate dummy formula
WritableWorkbookImpl w = getSheet().getWorkbook();
FormulaParser parser = new FormulaParser(formulaString, 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);
// Set the type bits to indicate an error
data[6] = 2;
data[12] = -1;
data[13] = -1;
// Set the error code
data[8] = (byte) errorCode;
return data;
}
}
|