Package org.apache.poi.hssf.record.aggregates

Examples of org.apache.poi.hssf.record.aggregates.CFRecordsAggregate

94
95
96
97
98
99
100
101
102
   *
   * @param cf HSSFConditionalFormatting object
   * @return index of the new Conditional Formatting object
   */
  public int addConditionalFormatting( HSSFConditionalFormatting cf ) {
    CFRecordsAggregate cfraClone = cf.getCFRecordsAggregate().cloneCFAggregate();

    return _sheet.addConditionalFormatting(cfraClone);
  }
View Full Code Here
126
127
128
129
130
131
132
133
    CFRuleRecord[] rules = new CFRuleRecord[cfRules.length];
    for (int i = 0; i != cfRules.length; i++) {
      rules[i] = cfRules[i].getCfRuleRecord();
    }
    CFRecordsAggregate cfra = new CFRecordsAggregate(regions, rules);
    return _sheet.addConditionalFormatting(cfra);
  }
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
  * @param index
  *      of the Conditional Formatting object to fetch
  * @return Conditional Formatting object
  */
  public HSSFConditionalFormatting getConditionalFormattingAt(int index) {
    CFRecordsAggregate cf = _sheet.getCFRecordsAggregateAt(index);
    if (cf == null) {
      return null;
    }
    return new HSSFConditionalFormatting(_workbook, cf);
  }
View Full Code Here
108
109
110
111
112
113
114
115
116
   *
   * @param cf HSSFConditionalFormatting object
   * @return index of the new Conditional Formatting object
   */
  public int addConditionalFormatting( HSSFConditionalFormatting cf ) {
    CFRecordsAggregate cfraClone = cf.getCFRecordsAggregate().cloneCFAggregate();

    return _conditionalFormattingTable.add(cfraClone);
  }
View Full Code Here
151
152
153
154
155
156
157
158
    CFRuleRecord[] rules = new CFRuleRecord[cfRules.length];
    for (int i = 0; i != cfRules.length; i++) {
      rules[i] = cfRules[i].getCfRuleRecord();
    }
    CFRecordsAggregate cfra = new CFRecordsAggregate(regions, rules);
    return _conditionalFormattingTable.add(cfra);
  }
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
  * @param index
  *      of the Conditional Formatting object to fetch
  * @return Conditional Formatting object
  */
  public HSSFConditionalFormatting getConditionalFormattingAt(int index) {
    CFRecordsAggregate cf = _conditionalFormattingTable.get(index);
    if (cf == null) {
      return null;
    }
    return new HSSFConditionalFormatting(_sheet.getWorkbook(), cf);
  }
View Full Code Here
656
657
658
659
660
661
662
663
664
665
    public void removeConditionalFormatting(int index)
    {
        if (index >= 0 && index <= condFormatting.size()-1 )
        {
          CFRecordsAggregate cfAggregate = getCFRecordsAggregateAt(index);
          records.remove(cfAggregate);
          condFormatting.remove(index);
        }
    }
View Full Code Here
186
187
188
189
190
191
192
193
194
195
196
                retval.merged = ( MergeCellsRecord ) rec;
                retval.numMergedRegions += retval.merged.getNumAreas();
            }
            else if ( rec.getSid() == CFHeaderRecord.sid )
            {
              CFRecordsAggregate cfAgg = CFRecordsAggregate.createCFAggregate(recs, k);
              retval.condFormatting.add(cfAgg);
              rec = cfAgg;
            }
            else if ( rec.getSid() == CFRuleRecord.sid )
            {
View Full Code Here
93
94
95
96
97
98
99
100
101
   *
   * @param cf HSSFConditionalFormatting object
   * @return index of the new Conditional Formatting object
   */
  public int addConditionalFormatting( HSSFConditionalFormatting cf ) {
    CFRecordsAggregate cfraClone = cf.getCFRecordsAggregate().cloneCFAggregate();

    return _sheet.addConditionalFormatting(cfraClone);
  }
View Full Code Here
125
126
127
128
129
130
131
132
    CFRuleRecord[] rules = new CFRuleRecord[cfRules.length];
    for (int i = 0; i != cfRules.length; i++) {
      rules[i] = cfRules[i].getCfRuleRecord();
    }
    CFRecordsAggregate cfra = new CFRecordsAggregate(regions, rules);
    return _sheet.addConditionalFormatting(cfra);
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.aggregates.CFRecordsAggregate

  • org.apache.poi.hssf.model.Sheet
  • org.apache.poi.hssf.record.CFHeaderRecord
  • org.apache.poi.hssf.record.CFRuleRecord
  • org.apache.poi.hssf.record.formula.AreaPtg
  • org.apache.poi.hssf.record.formula.Ptg
  • org.apache.poi.hssf.record.Record
  • org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
  • org.apache.poi.hssf.util.CellRangeAddress
  • org.apache.poi.ss.formula.ptg.AreaPtg
  • org.apache.poi.ss.formula.ptg.Ptg
    • 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.