Examples of FormulaRecord


Examples of org.apache.poi.hssf.record.FormulaRecord

            default:
                throw typeMismatch(CELL_TYPE_NUMERIC, _cellType, false);
            case CELL_TYPE_FORMULA:
                break;
        }
        FormulaRecord fr = ((FormulaRecordAggregate)_record).getFormulaRecord();
        checkFormulaCachedValueType(CELL_TYPE_NUMERIC, fr);
        return fr.getValue();
    }
View Full Code Here

Examples of org.zkoss.poi.hssf.record.FormulaRecord

  private static void setHSSFCellPtgs(HSSFCell cell, Ptg[] ptgs) {
      //tricky! must be after the dummyCell construction or the under aggregate record will not
      //be consistent in sheet and cell
        cell.setCellType(Cell.CELL_TYPE_FORMULA);
      FormulaRecordAggregate agg = (FormulaRecordAggregate) new HSSFCellHelper((HSSFCell)cell).getCellValueRecord();
      FormulaRecord frec = agg.getFormulaRecord();
      frec.setOptions((short) 2);
      frec.setValue(0);

      //only set to default if there is no extended format index already set
      if (agg.getXFIndex() == (short)0) {
        agg.setXFIndex((short) 0x0f);
      }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.