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

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

406
407
408
409
410
411
412
        sb.append('\0'); // list delimiter is the nul char
      }
      sb.append(_explicitListValues[i]);
   
    }
    return new Ptg[] { new StringPtg(sb.toString()), };
  }
View Full Code Here
564
565
566
567
568
569
570
571
  private static void confirmStringParse(String singleQuotedValue) {
    // formula: internal quotes become double double, surround with double quotes
    String formula = '"' + singleQuotedValue.replaceAll("'", "\"\"") + '"';
    String expectedValue = singleQuotedValue.replace('\'', '"');

    StringPtg sp = (StringPtg) parseSingleToken(formula, StringPtg.class);
    assertEquals(expectedValue, sp.getValue());
  }
View Full Code Here
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
    StringPtg sp = (StringPtg) parseSingleToken(formula, StringPtg.class);
    assertEquals(expectedValue, sp.getValue());
  }
  public void testParseStringLiterals_bug28754() {

    StringPtg sp;
    try {
      sp = (StringPtg) parseSingleToken("\"test\"\"ing\"", StringPtg.class);
    } catch (RuntimeException e) {
      if(e.getMessage().startsWith("Cannot Parse")) {
        throw new AssertionFailedError("Identified bug 28754a");
      }
      throw e;
    }
    assertEquals("test\"ing", sp.getValue());

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet();
    wb.setSheetName(0, "Sheet1");
View Full Code Here
608
609
610
611
612
613
614
615
  private static void confirmStringParse(String singleQuotedValue) {
    // formula: internal quotes become double double, surround with double quotes
    String formula = '"' + singleQuotedValue.replaceAll("'", "\"\"") + '"';
    String expectedValue = singleQuotedValue.replace('\'', '"');

    StringPtg sp = (StringPtg) parseSingleToken(formula, StringPtg.class);
    assertEquals(expectedValue, sp.getValue());
  }
View Full Code Here
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
    StringPtg sp = (StringPtg) parseSingleToken(formula, StringPtg.class);
    assertEquals(expectedValue, sp.getValue());
  }
  public void testParseStringLiterals_bug28754() {

    StringPtg sp;
    try {
      sp = (StringPtg) parseSingleToken("\"test\"\"ing\"", StringPtg.class);
    } catch (RuntimeException e) {
      if(e.getMessage().startsWith("Cannot Parse")) {
        throw new AssertionFailedError("Identified bug 28754a");
      }
      throw e;
    }
    assertEquals("test\"ing", sp.getValue());

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet();
    wb.setSheetName(0, "Sheet1");
View Full Code Here
576
577
578
579
580
581
582
583
584
585
586
                Match('(');
                ParseNode inside = comparisonExpression();
                Match(')');
                return new ParseNode(ParenthesisPtg.instance, inside);
            case '"':
                return new ParseNode(new StringPtg(parseStringLiteral()));
            case '{':
                Match('{');
                ParseNode arrayNode = parseArray();
                Match('}');
                return arrayNode;
View Full Code Here
692
693
694
695
696
697
698
699
700
701
702
                Match('(');
                ParseNode inside = comparisonExpression();
                Match(')');
                return new ParseNode(ParenthesisPtg.instance, inside);
            case '"':
                return new ParseNode(new StringPtg(parseStringLiteral()));
            case '{':
                Match('{');
                ParseNode arrayNode = parseArray();
                Match('}');
                return arrayNode;
View Full Code Here
129
130
131
132
133
134
135
136
137
138
  public void testNonAlphaFormula() {
    String currencyCell = "F3";
    Ptg[] ptgs = parseFormula("\"TOTAL[\"&"+currencyCell+"&\"]\"");
    assertEquals(5, ptgs.length);
    assertTrue ("Ptg[0] is a string", (ptgs[0] instanceof StringPtg));
    StringPtg firstString = (StringPtg)ptgs[0];

    assertEquals("TOTAL[", firstString.getValue());
    //the PTG order isn't 100% correct but it still works - dmui
  }
View Full Code Here
603
604
605
606
607
608
609
610
  private static void confirmStringParse(String singleQuotedValue) {
    // formula: internal quotes become double double, surround with double quotes
    String formula = '"' + singleQuotedValue.replaceAll("'", "\"\"") + '"';
    String expectedValue = singleQuotedValue.replace('\'', '"');

    StringPtg sp = (StringPtg) parseSingleToken(formula, StringPtg.class);
    assertEquals(expectedValue, sp.getValue());
  }
View Full Code Here
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
    StringPtg sp = (StringPtg) parseSingleToken(formula, StringPtg.class);
    assertEquals(expectedValue, sp.getValue());
  }
  public void testParseStringLiterals_bug28754() {

    StringPtg sp;
    try {
      sp = (StringPtg) parseSingleToken("\"test\"\"ing\"", StringPtg.class);
    } catch (RuntimeException e) {
      if(e.getMessage().startsWith("Cannot Parse")) {
        throw new AssertionFailedError("Identified bug 28754a");
      }
      throw e;
    }
    assertEquals("test\"ing", sp.getValue());

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet();
    wb.setSheetName(0, "Sheet1");
View Full Code Here
TOP

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

  • org.apache.poi.hssf.model.TestFormulaParser
  • org.apache.poi.hssf.model.TestFormulaParserIf
  • org.apache.poi.hssf.usermodel.DVConstraint
  • 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.