Package org.apache.poi.hssf.record

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

303
304
305
306
307
308
309
310
311
312
313
            if (currentSheet == null) {
                // Ignore cells outside sheets
            } else if (cell == null) {
                // Ignore empty cells
            } else if (record instanceof CellValueRecordInterface) {
                CellValueRecordInterface value =
                    (CellValueRecordInterface) record;
                Point point = new Point(value.getColumn(), value.getRow());
                currentSheet.put(point, cell);
            }
        }
View Full Code Here
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
        confirmCachedValue("70164", nc2);
        confirmCachedValue("90210", nc3);

        CellValueRecordInterface[] cvrs = ns.getSheet().getValueRecords();
        for (int i = 0; i < cvrs.length; i++) {
            CellValueRecordInterface cvr = cvrs[i];
            if(cvr instanceof FormulaRecordAggregate) {
                FormulaRecordAggregate fr = (FormulaRecordAggregate)cvr;

                if(i == 0) {
                    assertEquals(70164.0, fr.getFormulaRecord().getValue(), 0.0001);
View Full Code Here
482
483
484
485
486
487
488
489
490
491
492
493
494
    InternalSheet sheet = InternalSheet.createSheet();

    RowRecord rr = new RowRecord(5);
    sheet.addRow(rr);

    CellValueRecordInterface cvr = new BlankRecord();
    cvr.setColumn((short)0);
    cvr.setRow(5);
    sheet.addValueRecord(5, cvr);


    int dbCellRecordPos = getDbCellRecordPos(sheet);
    if (dbCellRecordPos == 252) {
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
78
    int thisRow;
    int thisColumn;
    CellValueRecordInterface[] expandedRecords = null;

    if (record instanceof CellValueRecordInterface) {
      CellValueRecordInterface valueRec = (CellValueRecordInterface) record;
      thisRow = valueRec.getRow();
      thisColumn = valueRec.getColumn();
    } else {
      thisRow = -1;
      thisColumn = -1;

      switch (record.getSid()) {
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
     
      // Now check we can turn all the numeric
      //  cells into strings without error
      for(int i=0; i<mockListen._records.size(); i++) {
        Record r = (Record)mockListen._records.get(i);
        CellValueRecordInterface cvr = null;
       
        if(r instanceof NumberRecord) {
          cvr = (CellValueRecordInterface)r;
        }
        if(r instanceof FormulaRecord) {
View Full Code Here
261
262
263
264
265
266
267
268
269
270
271
   * starting from startIx.
   */
  private static int countBlanks(CellValueRecordInterface[] rowCellValues, int startIx) {
    int i = startIx;
    while(i < rowCellValues.length) {
      CellValueRecordInterface cvr = rowCellValues[i];
      if (!(cvr instanceof BlankRecord)) {
        break;
      }
      i++;
    }
View Full Code Here
287
288
289
290
291
292
293
294
295
296
297
      CellValueRecordInterface[] rowCells = records[i];
      if (rowCells == null) {
        continue;
      }
      for (int j = 0; j < rowCells.length; j++) {
        CellValueRecordInterface cell = rowCells[j];
        if (cell instanceof FormulaRecordAggregate) {
          FormulaRecord fr = ((FormulaRecordAggregate)cell).getFormulaRecord();
          Ptg[] ptgs = fr.getParsedExpression(); // needs clone() inside this getter?
          if (shifter.adjustFormula(ptgs, currentExternSheetIndex)) {
            fr.setParsedExpression(ptgs);
View Full Code Here
312
313
314
315
316
317
318
319
320
321
322
      CellValueRecordInterface[] rowCells = records[rowIx];
      if (rowCells == null) {
        continue;
      }
      for (int colIx = 0; colIx < rowCells.length; colIx++) {
        CellValueRecordInterface cell = rowCells[colIx];
        if (cell != null) {
          temp.add(cell);
        }
      }
    }
View Full Code Here
63
64
65
66
67
68
69
70
71
    constructValueRecord(records);
    CellValueRecordInterface[] cvrs = valueRecord.getValueRecords();
    //Ensure that the SharedFormulaRecord has been converted
    assertEquals(1, cvrs.length);

    CellValueRecordInterface record = cvrs[0];
    assertNotNull( "Row contains a value", record );
    assertTrue( "First record is a FormulaRecordsAggregate", ( record instanceof FormulaRecordAggregate ) );
  }
View Full Code Here
168
169
170
171
172
173
174
175
176
177
178
        }

        cells[column]=null;

        if(alsoRemoveRecords) {
            CellValueRecordInterface cval = cell.getCellValueRecord();
            sheet.getSheet().removeValueRecord(getRowNum(), cval);
        }
        if (cell.getColumnIndex()+1 == row.getLastCol()) {
            row.setLastCol(calculateNewLastCellPlusOne(row.getLastCol()));
        }
View Full Code Here
TOP

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

  • org.apache.poi.hssf.eventusermodel.MissingRecordAwareHSSFListener
  • org.apache.poi.hssf.eventusermodel.TestFormatTrackingHSSFListener
  • org.apache.poi.hssf.model.TestSheet
  • org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate
  • org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate
  • org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate$ValueIterator
  • org.apache.poi.hssf.usermodel.FormulaExtractor
  • org.apache.poi.hssf.usermodel.HSSFRow
  • org.apache.poi.hssf.usermodel.HSSFSheet
  • org.apache.poi.hssf.usermodel.TestBugs
    • 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.