Examples with ExpPtg org.apache.poi.ss.formula.ptg.ExpPtg used on opensource projects

Example 1 with ExpPtg

use of org.apache.poi.ss.formula.ptg.ExpPtg in project poi by apache.

the class FormulaRecordAggregate method handleMissingSharedFormulaRecord.

/**
	 * Sometimes the shared formula flag "seems" to be erroneously set (because the corresponding
	 * {@link SharedFormulaRecord} does not exist). Normally this would leave no way of determining
	 * the {@link Ptg} tokens for the formula.  However as it turns out in these
	 * cases, Excel encodes the unshared {@link Ptg} tokens in the right place (inside the {@link
	 * FormulaRecord}).  So the the only thing that needs to be done is to ignore the erroneous
	 * shared formula flag.<br/>
	 *
	 * This method may also be used for setting breakpoints to help diagnose issues regarding the
	 * abnormally-set 'shared formula' flags.
	 * (see TestValueRecordsAggregate.testSpuriousSharedFormulaFlag()).<p/>
	 */
private static void handleMissingSharedFormulaRecord(FormulaRecord formula) {
    // make sure 'unshared' formula is actually available
    Ptg firstToken = formula.getParsedExpression()[0];
    if (firstToken instanceof ExpPtg) {
        throw new RecordFormatException("SharedFormulaRecord not found for FormulaRecord with (isSharedFormula=true)");
    }
    // could log an info message here since this is a fairly unusual occurrence.
    // no point leaving the flag erroneously set
    formula.setSharedFormula(false);
}

Example 2 with ExpPtg

use of org.apache.poi.ss.formula.ptg.ExpPtg in project poi by apache.

the class FormulaViewer method listFormula.

private void listFormula(FormulaRecord record) {
    String sep = "~";
    Ptg[] tokens = record.getParsedExpression();
    Ptg token;
    int numptgs = tokens.length;
    String numArg;
    token = tokens[numptgs - 1];
    if (token instanceof FuncPtg) {
        numArg = String.valueOf(numptgs - 1);
    } else {
        numArg = String.valueOf(-1);
    }
    StringBuilder buf = new StringBuilder();
    if (token instanceof ExpPtg)
        return;
    buf.append(token.toFormulaString());
    buf.append(sep);
    switch(token.getPtgClass()) {
        case Ptg.CLASS_REF:
            buf.append("REF");
            break;
        case Ptg.CLASS_VALUE:
            buf.append("VALUE");
            break;
        case Ptg.CLASS_ARRAY:
            buf.append("ARRAY");
            break;
        default:
            throwInvalidRVAToken(token);
    }
    buf.append(sep);
    if (numptgs > 1) {
        token = tokens[numptgs - 2];
        switch(token.getPtgClass()) {
            case Ptg.CLASS_REF:
                buf.append("REF");
                break;
            case Ptg.CLASS_VALUE:
                buf.append("VALUE");
                break;
            case Ptg.CLASS_ARRAY:
                buf.append("ARRAY");
                break;
            default:
                throwInvalidRVAToken(token);
        }
    } else {
        buf.append("VALUE");
    }
    buf.append(sep);
    buf.append(numArg);
    System.out.println(buf);
}

Example 3 with ExpPtg

use of org.apache.poi.ss.formula.ptg.ExpPtg in project poi by apache.

the class TestFormulaRecordAggregate method testArrayFormulas.

public void testArrayFormulas() {
    int rownum = 4;
    int colnum = 4;
    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);
    assertTrue(agg.isPartOfArrayFormula());
    assertEquals("E5", agg.getArrayFormulaRange().formatAsString());
    Ptg[] ptg = agg.getFormulaTokens();
    String fmlaSer = FormulaRenderer.toFormulaString(null, ptg);
    assertEquals(formula, fmlaSer);
    agg.removeArrayFormula(rownum, colnum);
    assertFalse(agg.isPartOfArrayFormula());
}

Example 4 with ExpPtg

use of org.apache.poi.ss.formula.ptg.ExpPtg in project poi by apache.

the class HSSFCell method setCellArrayFormula.

void setCellArrayFormula(CellRangeAddress range) {
    int row = _record.getRow();
    short col = _record.getColumn();
    short styleIndex = _record.getXFIndex();
    setCellType(CellType.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);
}