Package org.apache.poi.hssf.usermodel

Examples of org.apache.poi.hssf.usermodel.HSSFEvaluationWorkbook$Name

142
143
144
145
146
147
148
149
150
151
152
  }

  public void testMacroFunction() {
    // testNames.xls contains a VB function called 'myFunc'
    HSSFWorkbook w = HSSFTestDataSamples.openSampleWorkbook("testNames.xls");
    HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(w);

    Ptg[] ptg = HSSFFormulaParser.parse("myFunc()", w);
    // myFunc() actually takes 1 parameter.  Don't know if POI will ever be able to detect this problem

    // the name gets encoded as the first arg
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
  }

  public void testMacroFunction() {
    // testNames.xls contains a VB function called 'myFunc'
    HSSFWorkbook w = HSSFTestDataSamples.openSampleWorkbook("testNames.xls");
    HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(w);

    Ptg[] ptg = HSSFFormulaParser.parse("myFunc()", w);
    // myFunc() actually takes 1 parameter.  Don't know if POI will ever be able to detect this problem

    // the name gets encoded as the first arg
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
    public void testDiscontinousReference() throws Exception {
        InputStream is = HSSFTestDataSamples.openSampleFileStream("44167.xls");
        HSSFWB wb = new HSSFWB(is);
        Workbook workbook = wb.getWorkbook();
        HSSFEvaluationWorkbook eb = HSSFEvaluationWorkbook.create(wb);

        assertEquals(1, wb.getNumberOfNames());
        String sheetName = "Tabelle1";
        String rawRefA = "$C$10:$C$14";
        String rawRefB = "$C$16:$C$18";
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
  }

  public void testMacroFunction() {
    // testNames.xls contains a VB function called 'myFunc'
    HSSFWorkbook w = HSSFTestDataSamples.openSampleWorkbook("testNames.xls");
    HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(w);

    Ptg[] ptg = HSSFFormulaParser.parse("myFunc()", w);
    // myFunc() actually takes 1 parameter.  Don't know if POI will ever be able to detect this problem

    // the name gets encoded as the first arg
View Full Code Here
742
743
744
745
746
747
748
749
750
751
752
753
754
755
  public TModelList findTModel(String name, CategoryBag categoryBag,
      IdentifierBag identifierBag, FindQualifiers findQualifiers,
      int maxRows) throws RegistryException {
    FindTModel request = this.objectFactory.createFindTModel();

    Name jaxbName = this.objectFactory.createName();

    if (name != null) {
      jaxbName.setValue(name);
    }

    request.setName(jaxbName);

    if (categoryBag != null) {
View Full Code Here
486
487
488
489
490
491
492
493
494
495
496
497
    }

    private static Name getFirstName(InternationalString iname) throws JAXRException {
        for (Object o : iname.getLocalizedStrings()) {
            LocalizedString locName = (LocalizedString) o;
            Name name = objectFactory.createName();
            name.setValue(locName.getValue());
            name.setLang(locName.getLocale().getLanguage());
            return name;
        }
        return null;
    }
View Full Code Here
496
497
498
499
500
501
502
503
504
505
506
        return null;
    }
    private static void addNames(List<Name> names, InternationalString iname) throws JAXRException {
        for (Object o : iname.getLocalizedStrings()) {
            LocalizedString locName = (LocalizedString) o;
            Name name = objectFactory.createName();
            name.setValue(locName.getValue());
            name.setLang(locName.getLocale().getLanguage());
            names.add(name);
        }
    }
View Full Code Here
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
        Name[] result = new Name[namePatterns.size()];
        int currLoc = 0;
        for (Iterator i = namePatterns.iterator(); i.hasNext();)
        {
            Object obj = i.next();
            Name name = objectFactory.createName();
            if (obj instanceof String) {
                name.setValue((String)obj);
            } else if (obj instanceof LocalizedString) {
                LocalizedString ls = (LocalizedString)obj;
                name.setValue(ls.getValue());
                name.setLang(ls.getLocale().getLanguage());
            }
            result[currLoc] = name;
            currLoc++;
        }
        return result;
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
      for (String string : findQualifyers) {
        findQualifiers.getFindQualifier().add(string);
      }
      findBusiness.setFindQualifiers(findQualifiers);

      Name name = new Name();
      name.setValue(nameStr);
      findBusiness.getName().add(name);


      logger.debug("FindBusiness " + findBusiness + " sending findBusinesses request..");
      List<Business> businesses = new ArrayList<Business>();
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
    }
    assertEquals(names1.size(), names2.size());
    Iterator<Name> names1Itr = names1.iterator();
    Iterator<Name> names2Itr = names2.iterator();
    while (names1Itr.hasNext()) {
      Name name1 = names1Itr.next();
      Name name2 = names2Itr.next();
      assertEquals(name1.getLang(), name2.getLang());
      assertEquals(name1.getValue(), name2.getValue());
    }
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.usermodel.HSSFEvaluationWorkbook$Name

  • codec.asn1.ASN1ObjectIdentifier
  • codec.asn1.ASN1OpenType
  • codec.asn1.ASN1Sequence
  • codec.asn1.ASN1Set
  • codec.asn1.ASN1Type
  • codec.asn1.DEREncoder
  • codec.pkcs7.RecipientInfo
  • codec.pkcs7.SignerInfo
  • codec.util.CertificateStore$IdxKey
  • codec.x509.GeneralName
    • 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.