Package org.apache.poi.hssf.record

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

97
98
99
100
101
102
103
104
105
106
107
108
109
        iterator = valueRecord.getIterator();
        assertTrue( iterator.hasNext() );
    }

    public void testRemoveCell() {
        BlankRecord blankRecord1 = newBlankRecord();
        valueRecord.insertCell( blankRecord1 );
        BlankRecord blankRecord2 = newBlankRecord();
        valueRecord.removeCell( blankRecord2 );
        Iterator iterator = valueRecord.getIterator();
        assertFalse( iterator.hasNext() );

        // removing an already empty cell just falls through
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
        valueRecord.removeCell( blankRecord2 );
    }

    public void testGetPhysicalNumberOfCells() {
        assertEquals(0, valueRecord.getPhysicalNumberOfCells());
        BlankRecord blankRecord1 = newBlankRecord();
        valueRecord.insertCell( blankRecord1 );
        assertEquals(1, valueRecord.getPhysicalNumberOfCells());
        valueRecord.removeCell( blankRecord1 );
        assertEquals(0, valueRecord.getPhysicalNumberOfCells());
    }
View Full Code Here
172
173
174
175
176
177
178
179
180
181
        return newBlankRecord( 2, 2 );
    }

    private static BlankRecord newBlankRecord( int col, int row)
    {
        BlankRecord blankRecord = new BlankRecord();
        blankRecord.setRow( row );
        blankRecord.setColumn( (short) col );
        return blankRecord;
    }
View Full Code Here
473
474
475
476
477
478
479
480
481
482
483
484
485
        Sheet sheet = Sheet.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
166
167
168
169
170
171
172
173
174
175
176
177
178
179
    case SSTRecord.sid:
      sstRecord = (SSTRecord) record;
      break;

    case BlankRecord.sid:
      BlankRecord brec = (BlankRecord) record;

      thisRow = brec.getRow();
      thisColumn = brec.getColumn();
      thisStr = "";
      break;
    case BoolErrRecord.sid:
      BoolErrRecord berec = (BoolErrRecord) record;
View Full Code Here
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
                }
                _record = lrec;
                break;

            case CELL_TYPE_BLANK :
                BlankRecord brec = null;

                if (cellType != _cellType)
                {
                    brec = new BlankRecord();
                }
                else
                {
                    brec = ( BlankRecord ) _record;
                }
                brec.setColumn(col);

                // During construction the cellStyle may be null for a Blank cell.
                brec.setXFIndex(styleIndex);
                brec.setRow(row);
                _record = brec;
                break;

            case CELL_TYPE_BOOLEAN :
                BoolErrRecord boolRec = null;
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
  }

  private static List<Record> testData() {
    List<Record> records = new ArrayList<Record>();
    FormulaRecord formulaRecord = new FormulaRecord();
    BlankRecord blankRecord = new BlankRecord();
    formulaRecord.setRow(1);
    formulaRecord.setColumn((short) 1);
    blankRecord.setRow(2);
    blankRecord.setColumn((short) 2);
    records.add(formulaRecord);
    records.add(blankRecord);
    records.add(new WindowTwoRecord());
    return records;
  }
View Full Code Here
98
99
100
101
102
103
104
105
106
107
    @SuppressWarnings("deprecation") // uses deprecated {@link ValueRecordsAggregate#getValueRecords()}
  public void testInsertCell() {
    CellValueRecordInterface[] cvrs = valueRecord.getValueRecords();
    assertEquals(0, cvrs.length);

    BlankRecord blankRecord = newBlankRecord();
    valueRecord.insertCell( blankRecord );
    cvrs = valueRecord.getValueRecords();
    assertEquals(1, cvrs.length);
  }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
118
    assertEquals(1, cvrs.length);
  }

    @SuppressWarnings("deprecation") // uses deprecated {@link ValueRecordsAggregate#getValueRecords()}
  public void testRemoveCell() {
    BlankRecord blankRecord1 = newBlankRecord();
    valueRecord.insertCell( blankRecord1 );
    BlankRecord blankRecord2 = newBlankRecord();
    valueRecord.removeCell( blankRecord2 );
    CellValueRecordInterface[] cvrs = valueRecord.getValueRecords();
    assertEquals(0, cvrs.length);

    // removing an already empty cell just falls through
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
    valueRecord.removeCell( blankRecord2 );
  }

  public void testGetPhysicalNumberOfCells() {
    assertEquals(0, valueRecord.getPhysicalNumberOfCells());
    BlankRecord blankRecord1 = newBlankRecord();
    valueRecord.insertCell( blankRecord1 );
    assertEquals(1, valueRecord.getPhysicalNumberOfCells());
    valueRecord.removeCell( blankRecord1 );
    assertEquals(0, valueRecord.getPhysicalNumberOfCells());
  }
View Full Code Here
TOP

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

  • com.common.platform.excel.parser.HSSFParser
  • evolaris.framework.sys.business.XLS2CSVmra
  • org.apache.poi.hssf.eventmodel.EventRecordFactory
  • org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra
  • org.apache.poi.hssf.eventusermodel.MissingRecordAwareHSSFListener
  • org.apache.poi.hssf.model.TestSheet
  • org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate
  • org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate
  • org.apache.poi.hssf.usermodel.HSSFCell
  • org.apache.poi.hssf.usermodel.TestHSSFRow
    • 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.