Examples of AreaPtg

org.apache.poi.hssf.record.formula.AreaPtg
Specifies a rectangular area of cells A1:A4 for instance. @author andy @author Jason Height (jheight at chariot dot net dot au)
org.apache.poi.ss.formula.ptg.AreaPtg
Specifies a rectangular area of cells A1:A4 for instance. @author Jason Height (jheight at chariot dot net dot au)

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

        new NumberEval(21),
        new NumberEval(25),
        new NumberEval(25),
        new NumberEval(25),
    };
    Area2DEval arg0 = new Area2DEval(new AreaPtg("C1:C6"), values);
    
    Ref2DEval criteriaArg = new Ref2DEval(new ReferencePtg("A1"), new NumberEval(25));
    Eval[] args=  { arg0, criteriaArg, };
    
    double actual = NumericFunctionInvoker.invoke(new Countif(), args);

View Full Code Here

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

    assertEquals(4, actual, 0D);
  }
  


  private static AreaEval createAreaEval(String areaRefStr, ValueEval[] values) {
    return new Area2DEval(new AreaPtg(areaRefStr), values);
  }

View Full Code Here

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

    
    // text (first) arg type is number, other args are strings with fractional digits 
    confirmMid(new NumberEval(123456), new StringEval("3.1"), new StringEval("2.9"), "34");
    
    // startPos is 1x1 area ref, numChars is cell ref
    AreaEval aeStart = new Area2DEval(new AreaPtg("A1:A1"), new ValueEval[] { new NumberEval(2), } );
    RefEval reNumChars = new Ref2DEval(new ReferencePtg("B1"), new NumberEval(3));
    confirmMid(new StringEval("galactic"), aeStart, reNumChars, "ala");


    confirmMid(new StringEval("galactic"), new NumberEval(3.1), BlankEval.INSTANCE, "");

View Full Code Here

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

    ValueEval[] values = new ValueEval[nValues];
    for (int i = 0; i < nValues; i++) {
      values[i] = ZERO;
    }
    
    return new Area2DEval(new AreaPtg(areaRefStr), values);
  }

View Full Code Here

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

    return result;
  }


  private static ValueEval createAreaEval(ValueEval[] values) {
    String refStr = "A1:A" + values.length;
    return new Area2DEval(new AreaPtg(refStr), values);
  }

View Full Code Here

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

  /**
   * Convenience method
   * @return <code>new Area2DEval(new AreaPtg(ref), values)</code>
   */
  private static AreaEval createAreaEval(String ref, ValueEval[] values) {
    return new Area2DEval(new AreaPtg(ref), values);
  }

View Full Code Here

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

    assertEquals(AreaPtg.class, ops.get(0).getClass());
    assertEquals(FuncVarPtg.class, ops.get(1).getClass());


    // Actually stored as C1 to C65536 
    //  (last row is -1 === 65535)
    AreaPtg ptg = (AreaPtg)ops.get(0);
    assertEquals(2, ptg.getFirstColumn());
    assertEquals(2, ptg.getLastColumn());
    assertEquals(0, ptg.getFirstRow());
    assertEquals(65535, ptg.getLastRow());
    assertEquals("C:C", ptg.toFormulaString(wb));


    // Will show as C:C, but won't know how many
    //  rows it covers as we don't have the sheet
    //  to hand when turning the Ptgs into a string
    assertEquals("SUM(C:C)", cellSUM.getCellFormula());

View Full Code Here

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

  public void testColumnOperand() {
    
    short firstRow = (short)8;
    short lastRow = (short)12;
    short colNum = (short)5;
    AreaPtg areaPtg = new AreaPtg(firstRow, lastRow, colNum, colNum, false, false, false, false);
    ValueEval[] values = {
        new NumberEval(27),  
        new NumberEval(29),  
        new NumberEval(35),  // value in row 10 
        new NumberEval(37),

View Full Code Here

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

      // It doesn't matter if eval is a 2D or 3D ref, because that detail is never asked of AreaEval.
      // This code only requires the value array item. 
      // anything would be ok for rowIx and colIx, but may as well get it right.
      int rowIx = refEval.getRow();
      int colIx = refEval.getColumn();
      AreaPtg ap = new AreaPtg(rowIx, rowIx, colIx, colIx, false, false, false, false);
      ValueEval value = refEval.getInnerValueEval();
      return new Area2DEval(ap, new ValueEval[] { value, });
    }
    throw EvaluationException.invalidValue();
  }

View Full Code Here

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

        }
        RefPtg refB = (RefPtg) ptgB;


        if (ptgA instanceof RefPtg) {
            RefPtg refA = (RefPtg) ptgA;
            return new AreaPtg(refA.getRow(), refB.getRow(), refA.getColumn(), refB.getColumn(),
                    refA.isRowRelative(), refB.isRowRelative(), refA.isColRelative(), refB.isColRelative());
        }
        if (ptgA instanceof Ref3DPtg) {
            Ref3DPtg refA = (Ref3DPtg) ptgA;
            return new Area3DPtg(refA.getRow(), refB.getRow(), refA.getColumn(), refB.getColumn(),

View Full Code Here

0 1 2 3 4 5

TOP

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.