Examples of BlankRecord

org.apache.poi.hssf.record.BlankRecord
Title: Blank cell record
Description: Represents a column in a row with no value but with styling.
REFERENCE: PG 287 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
@author Andrew C. Oliver (acoliver at apache dot org) @author Jason Height (jheight at chariot dot net dot au) @version 2.0-pre

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

  private static BlankRecord newBlankRecord() {
    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

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

  /**
   * Tests various manipulations of blank cells, to make sure that {@link MulBlankRecord}s
   * are use appropriately
   */
  public void testMultipleBlanks() {
    BlankRecord brA2 = newBlankRecord(0, 1);
    BlankRecord brB2 = newBlankRecord(1, 1);
    BlankRecord brC2 = newBlankRecord(2, 1);
    BlankRecord brD2 = newBlankRecord(3, 1);
    BlankRecord brE2 = newBlankRecord(4, 1);
    BlankRecord brB3 = newBlankRecord(1, 2);
    BlankRecord brC3 = newBlankRecord(2, 2);


    valueRecord.insertCell(brA2);
    valueRecord.insertCell(brB2);
    valueRecord.insertCell(brD2);
    confirmMulBlank(3, 1, 1);

View Full Code Here

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

    return lastcell;
  }


  public void addMultipleBlanks(MulBlankRecord mbr) {
    for (int j = 0; j < mbr.getNumColumns(); j++) {
      BlankRecord br = new BlankRecord();


      br.setColumn(( short ) (j + mbr.getFirstColumn()));
      br.setRow(mbr.getRow());
      br.setXFIndex(mbr.getXFAt(j));
      insertCell(br);
    }
  }

View Full Code Here

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

    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

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

        assertEquals(1, dimensions.getLastCol());
        assertEquals(1, dimensions.getLastRow());


        CellValueRecordInterface cvr;


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


        assertEquals(0, dimensions.getFirstCol());
        assertEquals(0, dimensions.getFirstRow());
        assertEquals(1, dimensions.getLastCol());
        assertEquals(1, dimensions.getLastRow());


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


        assertEquals(0, dimensions.getFirstCol());

View Full Code Here

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

        HSSFSheet sheet = workbook.createSheet("Sheet1");
        RowRecord rowRec = new RowRecord(ROW_IX);
        rowRec.setFirstCol((short)2);
        rowRec.setLastCol((short)5);


        BlankRecord br = new BlankRecord();
        br.setRow(ROW_IX);
    br.setColumn((short)COL_IX);


        sheet.getSheet().addValueRecord(ROW_IX, br);
        HSSFRow row = new HSSFRow(workbook, sheet, rowRec);
        HSSFCell cell = row.createCellFromRecord(br);

View Full Code Here

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

                }
                _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

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

    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

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

      ExtendedFormatRecord xr = (ExtendedFormatRecord) record;
      xfRecords.add(xr);
      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

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

    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

0 1 2 3 4 5

TOP

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.