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

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

704
705
706
707
708
709
710
711
712
713
    LinkedDataRecord r = new LinkedDataRecord();
    r.setLinkType( LinkedDataRecord.LINK_TYPE_CATEGORIES );
    r.setReferenceType( LinkedDataRecord.REFERENCE_TYPE_WORKSHEET );
    r.setCustomNumberFormat( false );
    r.setIndexNumberFmtRecord( (short) 0 );
    Area3DPtg p = new Area3DPtg(0, 31, 1, 1,
            false, false, false, false, 0);
    r.setFormulaOfLink(new Ptg[] { p, });
    return r;
  }
View Full Code Here
717
718
719
720
721
722
723
724
725
726
    LinkedDataRecord r = new LinkedDataRecord();
    r.setLinkType( LinkedDataRecord.LINK_TYPE_VALUES );
    r.setReferenceType( LinkedDataRecord.REFERENCE_TYPE_WORKSHEET );
    r.setCustomNumberFormat( false );
    r.setIndexNumberFmtRecord( (short) 0 );
    Area3DPtg p = new Area3DPtg(0, 31, 0, 0,
        false, false, false, false, 0);
    r.setFormulaOfLink(new Ptg[] { p, });
    return r;
  }
View Full Code Here
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
            memFuncPtg.setLenRefSubexpression(23);
            ptgs.add(memFuncPtg);
        }
        if (startColumn >= 0)
        {
            Area3DPtg area3DPtg1 = new Area3DPtg();
            area3DPtg1.setExternSheetIndex(externSheetIndex);
            area3DPtg1.setFirstColumn((short)startColumn);
            area3DPtg1.setLastColumn((short)endColumn);
            area3DPtg1.setFirstRow((short)0);
            area3DPtg1.setLastRow((short)0xFFFF);
            ptgs.add(area3DPtg1);
        }
        if (startRow >= 0)
        {
            Area3DPtg area3DPtg2 = new Area3DPtg();
            area3DPtg2.setExternSheetIndex(externSheetIndex);
            area3DPtg2.setFirstColumn((short)0);
            area3DPtg2.setLastColumn((short)0x00FF);
            area3DPtg2.setFirstRow((short)startRow);
            area3DPtg2.setLastRow((short)endRow);
            ptgs.add(area3DPtg2);
        }
        if (settingRowAndColumn)
        {
            UnionPtg unionPtg = new UnionPtg();
View Full Code Here
632
633
634
635
636
637
638
639
640
641
        }

    }

    private Ptg createNewPtg(){
        Ptg ptg = new Area3DPtg();
        field_13_name_definition.push(ptg);

        return ptg;
    }
View Full Code Here
684
685
686
687
688
689
690
691
692
693
694
        } else if (oldPtg.getClass() == Ref3DPtg.class){
            externSheetIndex =  ((Ref3DPtg) oldPtg).getExternSheetIndex();
        }

        if (ra.hasRange()) {
            ptg = new Area3DPtg();
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetIndex);
            ((Area3DPtg) ptg).setArea(ref);
            this.setDefinitionTextLength((short)ptg.getSize());
        } else {
            ptg = new Ref3DPtg();
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
        Ptg[] def =nr.getNameDefinition();
        assertEquals(4, def.length);

        MemFuncPtg ptgA = (MemFuncPtg)def[0];
        Area3DPtg ptgB = (Area3DPtg)def[1];
        Area3DPtg ptgC = (Area3DPtg)def[2];
        UnionPtg ptgD = (UnionPtg)def[3];
        assertEquals("", ptgA.toFormulaString());
        assertEquals(refA, ptgB.toFormulaString(eb));
        assertEquals(refB, ptgC.toFormulaString(eb));
        assertEquals(",", ptgD.toFormulaString());

        assertEquals(ref, HSSFFormulaParser.toFormulaString(wb, nr.getNameDefinition()));

        // Check the high level definition
View Full Code Here
704
705
706
707
708
709
710
711
712
713
    LinkedDataRecord r = new LinkedDataRecord();
    r.setLinkType( LinkedDataRecord.LINK_TYPE_CATEGORIES );
    r.setReferenceType( LinkedDataRecord.REFERENCE_TYPE_WORKSHEET );
    r.setCustomNumberFormat( false );
    r.setIndexNumberFmtRecord( (short) 0 );
    Area3DPtg p = new Area3DPtg(0, 31, 1, 1,
            false, false, false, false, 0);
    r.setFormulaOfLink(new Ptg[] { p, });
    return r;
  }
View Full Code Here
717
718
719
720
721
722
723
724
725
726
    LinkedDataRecord r = new LinkedDataRecord();
    r.setLinkType( LinkedDataRecord.LINK_TYPE_VALUES );
    r.setReferenceType( LinkedDataRecord.REFERENCE_TYPE_WORKSHEET );
    r.setCustomNumberFormat( false );
    r.setIndexNumberFmtRecord( (short) 0 );
    Area3DPtg p = new Area3DPtg(0, 31, 0, 0,
        false, false, false, false, 0);
    r.setFormulaOfLink(new Ptg[] { p, });
    return r;
  }
View Full Code Here
479
480
481
482
483
484
485
486
487
488
489
      Ref3DPtg refPtg = (Ref3DPtg) ptg;
      SheetRefEvaluator sre = ec.createExternSheetRefEvaluator(refPtg);
      return new LazyRefEval(refPtg, sre);
    }
    if (ptg instanceof Area3DPtg) {
      Area3DPtg aptg = (Area3DPtg) ptg;
      SheetRefEvaluator sre = ec.createExternSheetRefEvaluator(aptg);
      return new LazyAreaEval(aptg, sre);
    }
    SheetRefEvaluator sre = ec.getRefEvaluatorForCurrentSheet();
    if (ptg instanceof RefPtg) {
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
174
175
        assertEquals( LinkedDataRecord.REFERENCE_TYPE_WORKSHEET, record.getReferenceType());
        assertEquals( 0, record.getOptions());
        assertEquals( false, record.isCustomNumberFormat() );
        assertEquals( 0, record.getIndexNumberFmtRecord());

        Area3DPtg ptgExpected = new Area3DPtg(0, 7936, 0, 0,
                false, false, false, false, 0);
       
        Ptg ptgActual = record.getFormulaOfLink()[0];
        assertEquals(ptgExpected.toString(),  ptgActual.toString());

        assertEquals( data.length + 4, record.getRecordSize() );
    }
View Full Code Here
TOP

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

  • org.apache.poi.hssf.record.chart.TestLinkedDataRecord
  • org.apache.poi.hssf.record.EmbeddedObjectRefSubRecord
  • org.apache.poi.hssf.record.formula.eval.TestAreaEval
  • org.apache.poi.hssf.record.formula.functions.Offset
  • org.apache.poi.hssf.record.NameRecord
  • org.apache.poi.hssf.record.SubRecord$LbsDataSubRecord
  • org.apache.poi.hssf.record.TestLinkedDataRecord
  • org.apache.poi.hssf.usermodel.HSSFChart
  • org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator
  • org.apache.poi.hssf.usermodel.HSSFSheet
    • 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.