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

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

668
669
670
671
672
673
674
675
676
677
678
679
                if (ptg instanceof Area3DPtg) {
                    Area3DPtg a3p = (Area3DPtg) ((OperandPtg) ptg).copy();
                    a3p.setExternSheetIndex(newExtSheetIx);
                    ptgs[i] = a3p;
                } else if (ptg instanceof Ref3DPtg) {
                    Ref3DPtg r3p = (Ref3DPtg) ((OperandPtg) ptg).copy();
                    r3p.setExternSheetIndex(newExtSheetIx);
                    ptgs[i] = r3p;
                }
            }
            NameRecord newNameRecord = workbook.createBuiltInName(NameRecord.BUILTIN_FILTER_DB, newSheetIndex+1);
            newNameRecord.setNameDefinition(ptgs);
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
119
120
    //  all the ptgs give back the right things
    Ptg[] ptgs = fRecs[0].getParsedExpression();
    assertEquals(1, ptgs.length);
    assertTrue(ptgs[0] instanceof Ref3DPtg);

    Ref3DPtg ptg = (Ref3DPtg)ptgs[0];
    HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(stubHSSF);
    assertEquals("Sheet1!A1", ptg.toFormulaString(book));


    // Now check we get the right formula back for
    //  a few sample ones
    FormulaRecord fr;
View Full Code Here
317
318
319
320
321
322
323
324
325
326
327
                    return new Area3DPtg(first+":"+third,externIdx);
                }
                return new Area3DPtg(first+":"+second,externIdx);
            }
            return new Ref3DPtg(first, externIdx);
        }
        if (name.equalsIgnoreCase("TRUE") || name.equalsIgnoreCase("FALSE")) {
            return new BoolPtg(name.toUpperCase());
        }
View Full Code Here
318
319
320
321
322
323
324
325
326
327
328
329
    }
    if (ptg instanceof AreaPtg) {
      return new LazyAreaEval(((AreaPtg) ptg), sheet, ce);
    }
    if (ptg instanceof Ref3DPtg) {
      Ref3DPtg refPtg = (Ref3DPtg) ptg;
      Sheet xsheet = getOtherSheet(refPtg.getExternSheetIndex());
      return new LazyRefEval(refPtg, xsheet, ce);
    }
    if (ptg instanceof Area3DPtg) {
      Area3DPtg a3dp = (Area3DPtg) ptg;
      Sheet xsheet = getOtherSheet(a3dp.getExternSheetIndex());
View Full Code Here
752
753
754
755
756
757
758
759
760
761
762
763
               
                if (ptg instanceof Area3DPtg) {
                    Area3DPtg a3p = (Area3DPtg) ptg;
                    a3p.setExternSheetIndex(newExtSheetIx);
                } else if (ptg instanceof Ref3DPtg) {
                    Ref3DPtg r3p = (Ref3DPtg) ptg;
                    r3p.setExternSheetIndex(newExtSheetIx);
                }
                ptgs[i] = ptg;
            }
            NameRecord newNameRecord = workbook.createBuiltInName(NameRecord.BUILTIN_FILTER_DB, newSheetIndex+1);
            newNameRecord.setNameDefinition(ptgs);
View Full Code Here
535
536
537
538
539
540
541
542
543
544
545
      if(refs.length > 1) {
        Ptg ptg = UnionPtg.instance;
        temp.add(ptg);
      }
    } else {
      Ref3DPtg ptg = new Ref3DPtg(ra.getFromCell(), externSheetIndex);
      temp.add(ptg);
    }
    Ptg[] ptgs = new Ptg[temp.size()];
    temp.toArray(ptgs);
    field_13_name_definition = ptgs;
View Full Code Here
691
692
693
694
695
696
697
698
699
700
701
            ptg = new Area3DPtg();
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Area3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)ptg.getSize());
        } else {
            ptg = new Ref3DPtg();
            ((Ref3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Ref3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)ptg.getSize());
        }
View Full Code Here
431
432
433
434
435
436
437
438
439
440
441
    if (ptg instanceof AreaErrPtg ||ptg instanceof RefErrorPtg
        || ptg instanceof DeletedArea3DPtg || ptg instanceof DeletedRef3DPtg) {
        return ErrorEval.REF_INVALID;
    }
    if (ptg instanceof Ref3DPtg) {
      Ref3DPtg refPtg = (Ref3DPtg) ptg;
      SheetRefEvaluator sre = createExternSheetRefEvaluator(tracker, refPtg);
      return new LazyRefEval(refPtg, sre);
    }
    if (ptg instanceof Area3DPtg) {
      Area3DPtg aptg = (Area3DPtg) ptg;
View Full Code Here
351
352
353
354
355
356
357
358
359
360
361
362
363
364
            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(),
                    refA.isRowRelative(), refB.isRowRelative(), refA.isColRelative(), refB.isColRelative(),
                    refA.getExternSheetIndex());
        }
        // Note - other operand types (like AreaPtg) which probably can't evaluate
        // do not cause validation errors at parse time
        return null;
    }
View Full Code Here
377
378
379
380
381
382
383
384
385
386
387
                String thirdIden = parseUnquotedIdentifier();
                return new Area3DPtg(secondIden + ":" + thirdIden, externIdx);
            }
            AreaReference areaRef = parseArea(secondIden);
            if (areaRef == null) {
                return new Ref3DPtg(secondIden, externIdx);
            }
            // will happen if dots are used instead of colon
            return new Area3DPtg(areaRef.formatAsString(), externIdx);
        }
View Full Code Here
TOP

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

  • org.apache.poi.hssf.eventusermodel.TestEventWorkbookBuilder
  • org.apache.poi.hssf.record.EmbeddedObjectRefSubRecord
  • org.apache.poi.hssf.record.NameRecord
  • org.apache.poi.hssf.record.SubRecord$LbsDataSubRecord
  • org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
  • org.apache.poi.hssf.usermodel.HSSFWorkbook
  • org.apache.poi.hssf.util.CellReference
  • org.apache.poi.hssf.util.RangeAddress
  • org.apache.poi.hssf.util.SheetReferences
  • org.apache.poi.ss.formula.FormulaParser
    • 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.