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

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

41
42
43
44
45
46
47
48
  /**
   * Creates a dummy AreaEval
   * @param values empty (<code>null</code>) entries in this array will be converted to NumberEval.ZERO
   */
  public static AreaEval createAreaEval(String areaRefStr, ValueEval[] values) {
    AreaPtg areaPtg = new AreaPtg(areaRefStr);
    return createAreaEval(areaPtg, values);
  }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
*/
public final class TestAreaEval extends TestCase {

  public void testGetValue_bug44950() {
    // TODO - this test probably isn't testing much anymore
    AreaPtg ptg = new AreaPtg("B2:D3");
    NumberEval one = new NumberEval(1);
    ValueEval[] values = {
        one, 
        new NumberEval(2), 
        new NumberEval(3), 
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
                                     fixupRelativeColumn(formulaColumn,refNPtg.getColumn(),refNPtg.isColRelative()),
                                     refNPtg.isRowRelative(),
                                     refNPtg.isColRelative());
            } else if (ptg instanceof AreaNPtg) {
              AreaNPtg areaNPtg = (AreaNPtg)ptg;
              ptg = new AreaPtg(fixupRelativeRow(formulaRow,areaNPtg.getFirstRow(),areaNPtg.isFirstRowRelative()),
                                fixupRelativeRow(formulaRow,areaNPtg.getLastRow(),areaNPtg.isLastRowRelative()),
                                fixupRelativeColumn(formulaColumn,areaNPtg.getFirstColumn(),areaNPtg.isFirstColRelative()),
                                fixupRelativeColumn(formulaColumn,areaNPtg.getLastColumn(),areaNPtg.isLastColRelative()),
                                areaNPtg.isFirstRowRelative(),
                                areaNPtg.isLastRowRelative(),
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
    System.arraycopy(formulaRawBytes, 0, data, 4, formulaRawBytes.length);
    RecordInputStream in = new RecordInputStream(new ByteArrayInputStream(data));
    in.nextRecord();
       byte ptgSid = in.readByte();
    switch(ptgSid) {
      case AreaPtg.sid:   return new AreaPtg(in);
      case Area3DPtg.sid: return new Area3DPtg(in);
      case RefPtg.sid:  return new RefPtg(in);
      case Ref3DPtg.sid:  return new Ref3DPtg(in);
    }
    return null;
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
    assertEquals(AreaPtg.class, ops[0].getClass());
    assertEquals(FuncVarPtg.class, ops[1].getClass());

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

    // 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
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
    assertEquals(AreaPtg.class, ops[0].getClass());
    assertEquals(FuncVarPtg.class, ops[1].getClass());

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

    // 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
43
44
45
46
47
48
49
50
  /**
   * Creates a dummy AreaEval
   * @param values empty (<code>null</code>) entries in this array will be converted to NumberEval.ZERO
   */
  public static AreaEval createAreaEval(String areaRefStr, ValueEval[] values) {
    AreaPtg areaPtg = new AreaPtg(areaRefStr);
    return createAreaEval(areaPtg, values);
  }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
*/
public final class TestAreaEval extends TestCase {

  public void testGetValue_bug44950() {
    // TODO - this test probably isn't testing much anymore
    AreaPtg ptg = new AreaPtg("B2:D3");
    NumberEval one = new NumberEval(1);
    ValueEval[] values = {
        one,
        new NumberEval(2),
        new NumberEval(3),
View Full Code Here
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
    private Ptg parseNameOrReference(String name) {

        AreaReference areaRef = parseArea(name);
        if (areaRef != null) {
            // will happen if dots are used instead of colon
            return new AreaPtg(areaRef.formatAsString());
        }

        if (look == ':' || look == '.') { // this is a AreaReference
            GetChar();

            while (look == '.') { // formulas can have . or .. or ... instead of :
                GetChar();
            }

            String first = name;
            String second = parseIdentifier();
            return new AreaPtg(first+":"+second);
        }

        if (look == '!') {
            Match('!');
            String sheetName = name;
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
                                     fixupRelativeColumn(formulaColumn,refNPtg.getColumn(),refNPtg.isColRelative()),
                                     refNPtg.isRowRelative(),
                                     refNPtg.isColRelative());
            } else if (ptg instanceof AreaNPtg) {
              AreaNPtg areaNPtg = (AreaNPtg)ptg;
              ptg = new AreaPtg(fixupRelativeRow(formulaRow,areaNPtg.getFirstRow(),areaNPtg.isFirstRowRelative()),
                                fixupRelativeRow(formulaRow,areaNPtg.getLastRow(),areaNPtg.isLastRowRelative()),
                                fixupRelativeColumn(formulaColumn,areaNPtg.getFirstColumn(),areaNPtg.isFirstColRelative()),
                                fixupRelativeColumn(formulaColumn,areaNPtg.getLastColumn(),areaNPtg.isLastColRelative()),
                                areaNPtg.isFirstRowRelative(),
                                areaNPtg.isLastRowRelative(),
View Full Code Here
TOP

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

  • org.apache.poi.hssf.record.aggregates.CFRecordsAggregate
  • org.apache.poi.hssf.record.EmbeddedObjectRefSubRecord
  • org.apache.poi.hssf.record.formula.eval.TestAreaEval
  • org.apache.poi.hssf.record.formula.eval.TestUnaryPlusEval
  • org.apache.poi.hssf.record.formula.functions.EvalFactory
  • org.apache.poi.hssf.record.formula.functions.LookupUtils
  • org.apache.poi.hssf.record.formula.functions.Offset
  • org.apache.poi.hssf.record.formula.functions.TestCountFuncs
  • org.apache.poi.hssf.record.formula.functions.TestIndex
  • org.apache.poi.hssf.record.formula.functions.TestMatch
    • 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.