Package org.apache.poi.hssf.record

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

246
247
248
249
250
251
252
253
254
255
256
257
        if (tr.isFirstCell(row, column)) {
          return tr;
        }
      }
      for (int i = 0; i < _arrayRecords.length; i++) {
        ArrayRecord ar = _arrayRecords[i];
        if (ar.isFirstCell(row, column)) {
          return ar;
        }
      }
    } else {
      // Since arrays and tables cannot be sparse (all cells in range participate)
View Full Code Here
253
254
255
256
257
258
259
260
261
262
263
264
      if (tr.isFirstCell(row, column)) {
        return tr;
      }
    }
    for (int i = 0; i < _arrayRecords.length; i++) {
      ArrayRecord ar = _arrayRecords[i];
      if (ar.isFirstCell(row, column)) {
        return ar;
      }
    }
    return null;
  }
View Full Code Here
189
190
191
192
193
194
195
196
197
198
    if (_sharedFormulaRecord != null) {
      return _sharedFormulaRecord.getFormulaTokens(_formulaRecord);
    }
    CellReference expRef = _formulaRecord.getFormula().getExpReference();
    if (expRef != null) {
      ArrayRecord arec = _sharedValueManager.getArrayRecord(expRef.getRow(), expRef.getCol());
      return arec.getFormulaTokens();
    }
    return _formulaRecord.getParsedExpression();
  }
View Full Code Here
229
230
231
232
233
234
235
236
  public boolean isPartOfArrayFormula() {
    if (_sharedFormulaRecord != null) {
      return false;
    }
        CellReference expRef = _formulaRecord.getFormula().getExpReference();
        ArrayRecord arec = expRef == null ? null : _sharedValueManager.getArrayRecord(expRef.getRow(), expRef.getCol());
    return arec != null;
  }
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
252
    }
    CellReference expRef = _formulaRecord.getFormula().getExpReference();
    if (expRef == null) {
      throw new IllegalStateException("not an array formula cell.");
    }
    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
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
118
119
120
121
122
123
124
125
126
127
128
129
      if (tr.isFirstCell(row, column)) {
        return tr;
      }
    }
    for (int i = 0; i < _arrayRecords.length; i++) {
      ArrayRecord ar = _arrayRecords[i];
      if (ar.isFirstCell(row, column)) {
        return ar;
      }
    }
    return null;
  }
View Full Code Here
189
190
191
192
193
194
195
196
197
198
    if (_sharedFormulaRecord != null) {
      return _sharedFormulaRecord.getFormulaTokens(_formulaRecord);
    }
    CellReference expRef = _formulaRecord.getFormula().getExpReference();
    if (expRef != null) {
      ArrayRecord arec = _sharedValueManager.getArrayRecord(expRef.getRow(), expRef.getCol());
      return arec.getFormulaTokens();
    }
    return _formulaRecord.getParsedExpression();
  }
View Full Code Here
229
230
231
232
233
234
235
236
  public boolean isPartOfArrayFormula() {
    if (_sharedFormulaRecord != null) {
      return false;
    }
        CellReference expRef = _formulaRecord.getFormula().getExpReference();
        ArrayRecord arec = expRef == null ? null : _sharedValueManager.getArrayRecord(expRef.getRow(), expRef.getCol());
    return arec != null;
  }
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
252
    }
    CellReference expRef = _formulaRecord.getFormula().getExpReference();
    if (expRef == null) {
      throw new IllegalStateException("not an array formula cell.");
    }
    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
TOP

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

  • org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
  • org.apache.poi.hssf.record.aggregates.SharedValueManager
  • org.apache.poi.hssf.record.formula.Ptg
  • 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.