Package org.apache.poi.hssf.record

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

90
91
92
93
94
95
96
97
   * 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 = _sheet.getWorkbook();
    CFRuleRecord rr = CFRuleRecord.create(_sheet, formula);
    return new HSSFConditionalFormattingRule(wb, rr);
  }
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
    {
      buffer.append(header.toString());
    }
    for(int i=0; i<rules.size(); i++)
    {
      CFRuleRecord cfRule = (CFRuleRecord)rules.get(i);
      buffer.append(cfRule.toString());
    }
    buffer.append("[/CF]\n");
    return buffer.toString();
  }
View Full Code Here
170
171
172
173
174
175
176
177
178
  }

  public void visitContainedRecords(RecordVisitor rv) {
    rv.visitRecord(header);
    for(int i=0; i<rules.size(); i++) {
      CFRuleRecord rule = (CFRuleRecord)rules.get(i);
      rv.visitRecord(rule);
    }
  }
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
      temp.toArray(newRanges);
      header.setCellRanges(newRanges);
    }
   
    for(int i=0; i<rules.size(); i++) {
      CFRuleRecord rule = (CFRuleRecord)rules.get(i);
      Ptg[] ptgs;
      ptgs = rule.getParsedExpression1();
      if (ptgs != null && shifter.adjustFormula(ptgs, currentExternSheetIx)) {
        rule.setParsedExpression1(ptgs);
      }
      ptgs = rule.getParsedExpression2();
      if (ptgs != null && shifter.adjustFormula(ptgs, currentExternSheetIx)) {
        rule.setParsedExpression2(ptgs);
      }
    }
    return true;
  }
View Full Code Here
144
145
146
147
148
149
150
151
  /**
   * @return the Conditional Formatting rule at position idx.
   */
  public HSSFConditionalFormattingRule getRule(int idx)
  {
    CFRuleRecord ruleRecord = cfAggregate.getRule(idx);
    return new HSSFConditionalFormattingRule(_workbook, ruleRecord);
  }
View Full Code Here
65
66
67
68
69
70
71
72
      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
78
79
80
81
82
83
84
85
   * 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
159
160
161
162
163
164
165
166
167
168
169
    {
      buffer.append(header.toString());
    }
    for(int i=0; i<rules.size(); i++)
    {
      CFRuleRecord cfRule = (CFRuleRecord)rules.get(i);
      buffer.append(cfRule.toString());
    }
    buffer.append("[/CF]\n");
    return buffer.toString();
  }
View Full Code Here
169
170
171
172
173
174
175
176
177
  }

  public void visitContainedRecords(RecordVisitor rv) {
    rv.visitRecord(header);
    for(int i=0; i<rules.size(); i++) {
      CFRuleRecord rule = (CFRuleRecord)rules.get(i);
      rv.visitRecord(rule);
    }
  }
View Full Code Here
135
136
137
138
139
140
141
142
  /**
   * @return the Conditional Formatting rule at position idx.
   */
  public HSSFConditionalFormattingRule getRule(int idx)
  {
    CFRuleRecord ruleRecord = cfAggregate.getRule(idx);
    return new HSSFConditionalFormattingRule(_workbook, ruleRecord);
  }
View Full Code Here
TOP

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

  • 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.