Examples of CellRangeAddress8Bit

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

46
47
48
49
50
51
52
53
        field_1_pane = 3; // pane id 3 is always present.  see OOO sec 5.75 'PANE'
        field_2_row_active_cell = activeCellRow;
        field_3_col_active_cell = activeCellCol;
        field_4_active_cell_ref_index = 0;
        field_6_refs = new CellRangeAddress8Bit[] {
            new CellRangeAddress8Bit(activeCellRow, activeCellRow, activeCellCol, activeCellCol),
        };
    }
View Full Code Here

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

59
60
61
62
63
64
65
66
        field_4_active_cell_ref_index = in.readShort();
        int field_5_num_refs    = in.readUShort();

        field_6_refs = new CellRangeAddress8Bit[field_5_num_refs];
        for (int i = 0; i < field_6_refs.length; i++) {
            field_6_refs[i] = new CellRangeAddress8Bit(in);
        }
    }
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

99
100
101
102
103
104
105
106
107
108
109
  /**
   * @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

110
111
112
113
114
115
116
117
  /**
   * @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

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

45
46
47
48
49
50
51
52
        field_1_pane = 3; // pane id 3 is always present.  see OOO sec 5.75 'PANE'
        field_2_row_active_cell = activeCellRow;
        field_3_col_active_cell = activeCellCol;
        field_4_active_cell_ref_index = 0;
        field_6_refs = new CellRangeAddress8Bit[] {
            new CellRangeAddress8Bit(activeCellRow, activeCellRow, activeCellCol, activeCellCol),
        };
    }
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.