Examples of CellRange

Examples of org.apache.poi.hssf.record.cf.CellRange

56
57
58
59
60
61
62
63
64
65
66
67
68
69
  protected void fillFields(RecordInputStream in)
  {
    field_1_numcf = in.readShort();
    field_2_need_recalculation = in.readShort();
    field_3_enclosing_cell_range = new CellRange(in.readUShort(), in.readUShort(), in.readUShort(), in.readUShort());
    int numCellRanges = in.readShort();
    CellRange[] crs = new CellRange[numCellRanges];
    for( int i=0; i<numCellRanges; i++)
    {
      crs[i] = new CellRange(in.readUShort(),in.readUShort(),in.readUShort(),in.readUShort());
    }
    field_4_cell_ranges = crs;
  }
View Full Code Here

Examples of org.apache.poi.hssf.record.cf.CellRange

107
108
109
110
111
112
113
114
115
116
117
    if(cellRanges == null)
    {
      throw new IllegalArgumentException("cellRanges must not be null");
    }
    field_4_cell_ranges = (CellRange[]) cellRanges.clone();
    CellRange enclosingRange = null;
    for (int i = 0; i < cellRanges.length; i++)
    {
      enclosingRange = cellRanges[i].createEnclosingCellRange(enclosingRange);
    }
    field_3_enclosing_cell_range=enclosingRange;
View Full Code Here

Examples of org.apache.poi.hssf.record.cf.CellRange

161
162
163
164
165
166
167
168
169
170
171
172
173
    LittleEndian.putShort(data, 12 + offset, (short) field_3_enclosing_cell_range.getFirstColumn());
    LittleEndian.putShort(data, 14 + offset, (short) field_3_enclosing_cell_range.getLastColumn());
    LittleEndian.putShort(data, 16 + offset, (short) field_4_cell_ranges.length);
    for( int i=0 ; i!=field_4_cell_ranges.length; i++)
    {
      CellRange cr = field_4_cell_ranges[i];
      LittleEndian.putShort(data, 18 + 0 + 8 * i + offset, (short) cr.getFirstRow());
      LittleEndian.putShort(data, 18 + 2 + 8 * i + offset, (short) cr.getLastRow());
      LittleEndian.putShort(data, 18 + 4 + 8 * i + offset, (short) cr.getFirstColumn());
      LittleEndian.putShort(data, 18 + 6 + 8 * i + offset, (short) cr.getLastColumn());
    }
    return getRecordSize();
  }
View Full Code Here

Examples of org.apache.poi.hssf.record.cf.CellRange

33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
  public void testCreateCFHeaderRecord ()
  {
    CFHeaderRecord record = new CFHeaderRecord();
    CellRange[] ranges = {
      new CellRange(0,0xFFFF,5,5),
      new CellRange(0,0xFFFF,6,6),
      new CellRange(0,1,0,1),
      new CellRange(0,1,2,3),
      new CellRange(2,3,0,1),
      new CellRange(2,3,2,3),
    };
    record.setCellRanges(ranges);
    ranges = record.getCellRanges();
    assertEquals(6,ranges.length);
    CellRange enclosingCellRange = record.getEnclosingCellRange();
    assertEquals(0, enclosingCellRange.getFirstRow());
    assertEquals(65535, enclosingCellRange.getLastRow());
    assertEquals(0, enclosingCellRange.getFirstColumn());
    assertEquals(6, enclosingCellRange.getLastColumn());
    record.setNeedRecalculation(true);
    assertTrue(record.getNeedRecalculation());
    record.setNeedRecalculation(false);
    assertFalse(record.getNeedRecalculation());
  }
View Full Code Here

Examples of org.apache.poi.hssf.record.cf.CellRange

48
49
50
51
52
53
54
55
56
57
58
59
    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);
    CellRange[] cellRanges = {
        new CellRange(0,1,0,0),
        new CellRange(0,1,2,2),
    };
    header.setCellRanges(cellRanges);
    recs.add(header);
    recs.add(rule1);
    recs.add(rule2);
View Full Code Here

Examples of org.apache.poi.hssf.record.cf.CellRange

56
57
58
59
60
61
62
63
64
65
66
67
68
69
  protected void fillFields(RecordInputStream in)
  {
    field_1_numcf = in.readShort();
    field_2_need_recalculation = in.readShort();
    field_3_enclosing_cell_range = new CellRange(in.readUShort(), in.readUShort(), in.readUShort(), in.readUShort());
    int numCellRanges = in.readShort();
    CellRange[] crs = new CellRange[numCellRanges];
    for( int i=0; i<numCellRanges; i++)
    {
      crs[i] = new CellRange(in.readUShort(),in.readUShort(),in.readUShort(),in.readUShort());
    }
    field_4_cell_ranges = crs;
  }
View Full Code Here

Examples of org.apache.poi.hssf.record.cf.CellRange

107
108
109
110
111
112
113
114
115
116
117
    if(cellRanges == null)
    {
      throw new IllegalArgumentException("cellRanges must not be null");
    }
    field_4_cell_ranges = (CellRange[]) cellRanges.clone();
    CellRange enclosingRange = null;
    for (int i = 0; i < cellRanges.length; i++)
    {
      enclosingRange = cellRanges[i].createEnclosingCellRange(enclosingRange);
    }
    field_3_enclosing_cell_range=enclosingRange;
View Full Code Here

Examples of org.apache.poi.hssf.record.cf.CellRange

161
162
163
164
165
166
167
168
169
170
171
172
173
    LittleEndian.putShort(data, 12 + offset, (short) field_3_enclosing_cell_range.getFirstColumn());
    LittleEndian.putShort(data, 14 + offset, (short) field_3_enclosing_cell_range.getLastColumn());
    LittleEndian.putShort(data, 16 + offset, (short) field_4_cell_ranges.length);
    for( int i=0 ; i!=field_4_cell_ranges.length; i++)
    {
      CellRange cr = field_4_cell_ranges[i];
      LittleEndian.putShort(data, 18 + 0 + 8 * i + offset, (short) cr.getFirstRow());
      LittleEndian.putShort(data, 18 + 2 + 8 * i + offset, (short) cr.getLastRow());
      LittleEndian.putShort(data, 18 + 4 + 8 * i + offset, (short) cr.getFirstColumn());
      LittleEndian.putShort(data, 18 + 6 + 8 * i + offset, (short) cr.getLastColumn());
    }
    return getRecordSize();
  }
View Full Code Here

Examples of org.formulacompiler.spreadsheet.internal.CellRange

142
143
144
145
146
147
148
149
150
151
152
        final String name = se.getAttributeByName( XMLConstants.Main.NAME ).getValue();
        if (!name.startsWith( DEFINED_NAME_RESERVED_PREFIX )) {
          final String cellRangeAddress = getText();
          final ExpressionParser parser = new SpreadsheetExpressionParserA1OOXML( cellRangeAddress, _spreadsheet );
          try {
            final CellRange cellRange = (CellRange) parser.rangeOrCellRefA1();
            _spreadsheet.defineModelRangeName( name, cellRange );
          }
          catch (org.formulacompiler.compiler.internal.expressions.parser.ParseException e) {
            throw new SpreadsheetException.LoadError( "Error parsing named range " + name, e );
          }
View Full Code Here

Examples of org.formulacompiler.spreadsheet.internal.CellRange

140
141
142
143
144
145
146
147
148
149
150
      final String name = expressionNodeForRange.getName();
      if (name != null) {
        _stringBuilder.append( name );
      }
      else {
        final CellRange range = expressionNodeForRange.getRange();
        _stringBuilder.append( '[' );
        RefFormatter.append( _stringBuilder, range, _baseCell );
        _stringBuilder.append( ']' );
      }
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.