Bug 40296

The following program throws ClassCastException at line 22. Error message states
"org.apache.poi.hssf.record.BoolErrRecord cannot be cast to
org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate". Seems like there
may be a missing break near line 232 of HSSFCell. Thanks.

import java.io.*;
import org.apache.poi.hssf.usermodel.*;

public class FormulaTest {

  public static void main (String[] args) {

    try {
      FileOutputStream out = new FileOutputStream("FormulaTest.xls");

      HSSFWorkbook workBook = new HSSFWorkbook();
      HSSFSheet workSheet = workBook.createSheet("Sheet1");
      HSSFCell cell = null;
      HSSFRow row = null;

      row = workSheet.createRow(0);
      cell = row.createCell((short)0, HSSFCell.CELL_TYPE_NUMERIC);
      cell.setCellValue(1.0);
      cell = row.createCell((short)1, HSSFCell.CELL_TYPE_NUMERIC);
      cell.setCellValue(2.0);
      cell = row.createCell((short)2, HSSFCell.CELL_TYPE_FORMULA);
      cell.setCellFormula("SUM(A1:B1)");
      workBook.write(out);
      out.close();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }
}