Package org.apache.poi.hssf.record

Examples of org.apache.poi.hssf.record.CFRuleRecord$ComparisonOperator

46
47
48
49
50
51
52
53
54
55
56
57
58
  public void testCFRecordsAggregate()
  {
    HSSFWorkbook workbook = new HSSFWorkbook();
    List recs = new ArrayList();
    CFHeaderRecord header = new CFHeaderRecord();
    CFRuleRecord rule1 = CFRuleRecord.create(workbook, "7");
    CFRuleRecord rule2 = CFRuleRecord.create(workbook, ComparisonOperator.BETWEEN, "2", "5");
    CFRuleRecord rule3 = CFRuleRecord.create(workbook, ComparisonOperator.GE, "100", null);
    header.setNumberOfConditionalFormats(3);
    CellRangeAddress[] cellRanges = {
        new CellRangeAddress(0,1,0,0),
        new CellRangeAddress(0,1,2,2),
    };
View Full Code Here
66
67
68
69
70
71
72
73
      byte comparisonOperation,
      String formula1,
      String formula2) {

    HSSFWorkbook wb = _workbook;
    CFRuleRecord rr = CFRuleRecord.create(wb, comparisonOperation, formula1, formula2);
    return new HSSFConditionalFormattingRule(wb, rr);
  }
View Full Code Here
79
80
81
82
83
84
85
86
   * TODO - formulas containing cell references are currently not parsed properly
   * @param formula - formula for the valued, compared with the cell
   */
  public HSSFConditionalFormattingRule createConditionalFormattingRule(String formula) {
    HSSFWorkbook wb = _workbook;
    CFRuleRecord rr = CFRuleRecord.create(wb, formula);
    return new HSSFConditionalFormattingRule(wb, rr);
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.CFRuleRecord$ComparisonOperator

  • org.apache.poi.hssf.record.aggregates.CFRecordsAggregate
  • org.apache.poi.hssf.record.aggregates.TestCFRecordsAggregate
  • org.apache.poi.hssf.record.cf.BorderFormatting
  • org.apache.poi.hssf.record.cf.FontFormatting
  • org.apache.poi.hssf.record.cf.PatternFormatting
  • org.apache.poi.hssf.usermodel.HSSFConditionalFormatting
  • org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
  • java.util.Stack
    • 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.