Index: src/java/org/apache/poi/hssf/usermodel/HSSFCell.java =================================================================== RCS file: /home/cvspublic/jakarta-poi/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java,v retrieving revision 1.19 diff -u -r1.19 HSSFCell.java --- src/java/org/apache/poi/hssf/usermodel/HSSFCell.java 28 Nov 2002 19:32:52 -0000 1.19 +++ src/java/org/apache/poi/hssf/usermodel/HSSFCell.java 13 Dec 2002 16:55:41 -0000 @@ -706,7 +706,9 @@ FormulaRecordAggregate rec = (FormulaRecordAggregate) record; rec.getFormulaRecord().setOptions(( short ) 2); rec.getFormulaRecord().setValue(0); - rec.setXFIndex(( short ) 0x0f); + + //only set to default if there is no extended format index already set + if (rec.getXFIndex() == (short)0) rec.setXFIndex(( short ) 0x0f); FormulaParser fp = new FormulaParser(formula+";",book); fp.parse(); Ptg[] ptg = fp.getRPNPtg();