/*********************************************************************
*
* 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.Assert;
import jxl.common.Logger;
import jxl.StringFormulaCell;
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 ReadStringFormulaRecord extends ReadFormulaRecord
implements StringFormulaCell
{
// the logger
private static Logger logger = Logger.getLogger(ReadFormulaRecord.class);
/**
* Constructor
*
* @param f
*/
public ReadStringFormulaRecord(FormulaData f)
{
super(f);
}
/**
* Gets the string contents for this cell.
*
* @return the cell contents
*/
public String getString()
{
return ( (StringFormulaCell) getReadFormula()).getString();
}
/**
* String 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("\"" + getContents() +"\"", w, w,
w.getSettings());
// Get the bytes for the dummy formula
try
{
parser.parse();
}
catch(FormulaException e2)
{
logger.warn(e2.getMessage());
parser = new FormulaParser("\"ERROR\"", w, w, w.getSettings());
try {parser.parse();}
catch(FormulaException e3) {Assert.verify(false);}
}
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 a string formula
data[6] = 0;
data[12] = -1;
data[13] = -1;
return data;
}
}
|