Examples of CellRangeAddress8Bit

Examples of org.apache.poi.hssf.util.CellRangeAddress8Bit

44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
  public void testLoad() {

    TableRecord record = new TableRecord(TestcaseRecordInputStream.create(0x236, data));

    CellRangeAddress8Bit range = record.getRange();
    assertEquals(3, range.getFirstRow());
    assertEquals(8, range.getLastRow());
    assertEquals(4, range.getFirstColumn());
    assertEquals(6, range.getLastColumn());
    assertEquals(0, record.getFlags());
    assertEquals(4, record.getRowInputRow());
    assertEquals(1, record.getColInputRow());
    assertEquals(0x4076, record.getRowInputCol());
    assertEquals(0, record.getColInputCol());
View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress8Bit

76
77
78
79
80
81
82
83
84
85
86
//          .col input row = 1
//          .row input col = 4076
//          .col input col = 0
//      [/TABLE]

    CellRangeAddress8Bit crab = new CellRangeAddress8Bit(3, 8, 4, 6);
    TableRecord record = new TableRecord(crab);
    record.setFlags((byte)0);
    record.setRowInputRow(4);
    record.setColInputRow(1);
    record.setRowInputCol(0x4076);
View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress8Bit

245
246
247
248
249
250
251
252
    }
    ArrayRecord arec = _sharedValueManager.getArrayRecord(expRef.getRow(), expRef.getCol());
    if (arec == null) {
      throw new IllegalStateException("ArrayRecord was not found for the locator " + expRef.formatAsString());
    }
    CellRangeAddress8Bit a = arec.getRange();
    return new CellRangeAddress(a.getFirstRow(), a.getLastRow(), a.getFirstColumn(),a.getLastColumn());
  }
View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress8Bit

251
252
253
254
255
256
257
258
    return new CellRangeAddress(a.getFirstRow(), a.getLastRow(), a.getFirstColumn(),a.getLastColumn());
  }

  public void setArrayFormula(CellRangeAddress r, Ptg[] ptgs) {

    ArrayRecord arr = new ArrayRecord(Formula.create(ptgs), new CellRangeAddress8Bit(r.getFirstRow(), r.getLastRow(), r.getFirstColumn(), r.getLastColumn()));
    _sharedValueManager.addArrayRecord(arr);
  }
View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress8Bit

259
260
261
262
263
264
265
266
267
268
  /**
   * Removes an array formula
   * @return the range of the array formula containing the specified cell. Never <code>null</code>
   */
  public CellRangeAddress removeArrayFormula(int rowIndex, int columnIndex) {
    CellRangeAddress8Bit a = _sharedValueManager.removeArrayFormula(rowIndex, columnIndex);
        // at this point FormulaRecordAggregate#isPartOfArrayFormula() should return false
        _formulaRecord.setParsedExpression(null);
        return new CellRangeAddress(a.getFirstRow(), a.getLastRow(), a.getFirstColumn(), a.getLastColumn());
  }
View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress8Bit

40
41
42
43
44
45
46
    private int field_5_reserved;
    private Formula field_7_parsed_expr;

    // for testing only
    public SharedFormulaRecord() {
        this(new CellRangeAddress8Bit(0,0,0,0));
    }
View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress8Bit

33
34
35
36
37
38
39
  protected SharedValueRecordBase(CellRangeAddress8Bit range) {
    _range = range;
  }

  protected SharedValueRecordBase() {
    this(new CellRangeAddress8Bit(0, 0, 0, 0));
  }
View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress8Bit

40
41
42
43
44
45
46
  /**
   * reads only the range (1 {@link CellRangeAddress8Bit}) from the stream
   */
  public SharedValueRecordBase(RecordInputStream in) {
    _range = new CellRangeAddress8Bit(in);
  }
View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress8Bit

89
90
91
92
93
94
95
96
97
98
99
  /**
   * @return <code>true</code> if (rowIx, colIx) is within the range ({@link #getRange()})
   * of this shared value object.
   */
  public final boolean isInRange(int rowIx, int colIx) {
    CellRangeAddress8Bit r = _range;
    return r.getFirstRow() <= rowIx
      && r.getLastRow() >= rowIx
      && r.getFirstColumn() <= colIx
      && r.getLastColumn() >= colIx;
  }
View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress8Bit

100
101
102
103
104
105
106
107
  /**
   * @return <code>true</code> if (rowIx, colIx) describes the first cell in this shared value
   * object's range ({@link #getRange()})
   */
  public final boolean isFirstCell(int rowIx, int colIx) {
    CellRangeAddress8Bit r = getRange();
    return r.getFirstRow() == rowIx && r.getFirstColumn() == colIx;
  }
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.