Index: jakarta-poi/src/testcases/org/apache/poi/hssf/model/TestFormulaParser.java
===================================================================
RCS file: /home/cvspublic/jakarta-poi/src/testcases/org/apache/poi/hssf/model/TestFormulaParser.java,v
retrieving revision 1.15
diff -r1.15 TestFormulaParser.java
19a20,23
> import java.io.File;
> import java.io.FileInputStream;
> import java.io.FileOutputStream;
> import java.io.IOException;
42a47
> import org.apache.poi.util.TempFile;
380a386,442
>     /** bug 21923, testcase by Eric Ladner */
>     public void test3dRefs()
>         throws IOException
>     {
>         String filename = System.getProperty("HSSF.testdata.path");
> 
>         File file = TempFile.createTempFile("testSheetFormula",".xls");
>         FileOutputStream out    = new FileOutputStream(file);
>         HSSFWorkbook     wb     = new HSSFWorkbook();
>         HSSFSheet        s      = wb.createSheet("A");
>         HSSFRow          r      = null;
>         HSSFCell         c      = null;
>         r = s.createRow((short)0);
>         c = r.createCell((short)0);c.setCellValue(1);
>         c = r.createCell((short)1);c.setCellValue(2);
>         c = r.createCell((short)2);c.setCellFormula("A1+B1");
>             
>         s = wb.createSheet("B");
>         r = s.createRow((short)0);
>         c = r.createCell((short)0); c.setCellFormula("A!A1+A!B1");
>         wb.write(out);
>         out.close();
>             
>         assertTrue("file exists",file.exists());
>             
>         FileInputStream in = new FileInputStream(file);
>         wb = new HSSFWorkbook(in);
>         s = wb.getSheet("A");
>         r = s.getRow(0);
>         c = r.getCell((short)2);
>         
>         FormulaParser fp = new FormulaParser(c.getCellFormula(), null);
>         fp.parse();
> 
>         Ptg[] ptgs = fp.getRPNPtg();
> 
>         fp.toFormulaString(null, ptgs);
>         assertTrue("expected A1+B1 got: "+fp.toFormulaString(null, ptgs), ("A1+B1").equals(fp.toFormulaString(null, ptgs)));
> 
>         s = wb.getSheet("B");
>         r = s.getRow(0);
>         c = r.getCell((short)0);
>         
>         fp = new FormulaParser(c.getCellFormula(),null);
>         fp.parse();
> 
>         ptgs = fp.getRPNPtg();
> 
>         fp.toFormulaString(null, ptgs);
>         assertTrue("expected A!A1+A!B1 got: "+fp.toFormulaString(null, ptgs), ("A!A1+A!B1").equals(fp.toFormulaString(null, ptgs)));
>         
>         //assertTrue("expected: A!A1+A!B1 got: "+c.getCellFormula(), ("AVERAGE(A!A1:B1)").equals(c.getCellFormula()));
>         //c = r.getCell((short)1);
>         //assertTrue("expected: A!A1+A!B1 got: "+c.getCellFormula(), ("A!A1+A!B1").equals(c.getCellFormula()));
>         in.close();
>     }
>