Package org.apache.poi.hssf.record

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


      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


   * 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

      byte comparisonOperation,
      String formula1,
      String formula2) {

    HSSFWorkbook wb = _sheet.getWorkbook();
    CFRuleRecord rr = CFRuleRecord.create(_sheet, comparisonOperation, formula1, formula2);
    return new HSSFConditionalFormattingRule(wb, rr);
  }
View Full Code Here

    public HSSFConditionalFormattingRule createConditionalFormattingRule(
            byte comparisonOperation,
            String formula1) {

        HSSFWorkbook wb = _sheet.getWorkbook();
        CFRuleRecord rr = CFRuleRecord.create(_sheet, comparisonOperation, formula1, null);
        return new HSSFConditionalFormattingRule(wb, rr);
    }
View Full Code Here

   * 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

  /**
   * @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

      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

   *
   * @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

    {
      buffer.append(header.toString());
    }
    for(int i=0; i<rules.size(); i++)
    {
      CFRuleRecord cfRule = (CFRuleRecord)rules.get(i);
      if(cfRule!=null)
      {
        buffer.append(cfRule.toString());
      }
    }
    buffer.append("[/CF]\n");
    return buffer.toString();
  }
View Full Code Here

  /**
   * @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$ComparisonOperator

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.