Package org.apache.poi.hssf.record.formula

Examples of org.apache.poi.hssf.record.formula.ExpPtg

1188
1189
1190
1191
1192
1193
1194
1195
1196
        short col = _record.getColumn();
        short styleIndex = _record.getXFIndex();
        setCellType(CELL_TYPE_FORMULA, false, row, col, styleIndex);

        // Billet for formula in rec
        Ptg[] ptgsForCell = {new ExpPtg(range.getFirstRow(), range.getFirstColumn())};
        FormulaRecordAggregate agg = (FormulaRecordAggregate) _record;
        agg.setParsedExpression(ptgsForCell);
    }
View Full Code Here
1180
1181
1182
1183
1184
1185
1186
1187
1188
        short col = _record.getColumn();
        short styleIndex = _record.getXFIndex();
        setCellType(CELL_TYPE_FORMULA, false, row, col, styleIndex);

        // Billet for formula in rec
        Ptg[] ptgsForCell = {new ExpPtg(range.getFirstRow(), range.getFirstColumn())};
        FormulaRecordAggregate agg = (FormulaRecordAggregate) _record;
        agg.setParsedExpression(ptgsForCell);
    }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
    FormulaRecord fr = new FormulaRecord();
    fr.setRow(rownum);
    fr.setColumn((short)colnum);

    FormulaRecordAggregate agg = new FormulaRecordAggregate(fr, null, SharedValueManager.createEmpty());
    Ptg[] ptgsForCell = {new ExpPtg(rownum, colnum)};
    agg.setParsedExpression(ptgsForCell);

    String formula = "SUM(A1:A3*B1:B3)";
    Ptg[] ptgs = HSSFFormulaParser.parse(formula, null, FormulaType.ARRAY, 0);
    agg.setArrayFormula(new CellRangeAddress(rownum, rownum, colnum, colnum), ptgs);
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.formula.ExpPtg

  • org.apache.poi.hssf.record.aggregates.TestFormulaRecordAggregate
  • org.apache.poi.hssf.usermodel.HSSFCell
  • org.apache.poi.hssf.record.RecordFormatException
    • Copyright © 2018 www.massapicom. 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.