Examples of org.apache.poi.hssf.record.TableRecord

org.apache.poi.hssf.record.TableRecord
DATATABLE (0x0236)
TableRecord - The record specifies a data table. This record is preceded by a single Formula record that defines the first cell in the data table, which should only contain a single Ptg, {@link TblPtg}. See p536 of the June 08 binary docs

    int row = firstCell.getRow();
    int column = firstCell.getCol();
    boolean isTopLeft = agg.getRow() == row && agg.getColumn() == column;
    if (isTopLeft) {
      for (int i = 0; i < _tableRecords.length; i++) {
        TableRecord tr = _tableRecords[i];
        if (tr.isFirstCell(row, column)) {
          return tr;
        }
      }
      for (int i = 0; i < _arrayRecords.length; i++) {
        ArrayRecord ar = _arrayRecords[i];

View Full Code Here

    // Since arrays and tables cannot be sparse (all cells in range participate)
    // The first cell will be the top left in the range.  So we can match the
    // ARRAY/TABLE record directly.


    for (int i = 0; i < _tableRecords.length; i++) {
      TableRecord tr = _tableRecords[i];
      if (tr.isFirstCell(row, column)) {
        return tr;
      }
    }
    for (int i = 0; i < _arrayRecords.length; i++) {
      ArrayRecord ar = _arrayRecords[i];

View Full Code Here

   */
  public SharedValueRecordBase getRecordForFirstCell(FormulaRecord formulaRecord) {
    int row = formulaRecord.getRow();
    int column = formulaRecord.getColumn();
    for (int i = 0; i < _tableRecords.length; i++) {
      TableRecord tr = _tableRecords[i];
      if (tr.isFirstCell(row, column)) {
        return tr;
      }
    }
    for (int i = 0; i < _arrayRecords.length; i++) {
      ArrayRecord ar = _arrayRecords[i];

View Full Code Here

TOP

Related Classes of org.apache.poi.hssf.record.TableRecord

org.apache.poi.hssf.record.aggregates.SharedValueManager

org.apache.poi.hssf.util.CellReference

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.