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

                (( LabelSSTRecord ) record).setRow(row);
                (( LabelSSTRecord ) record).setXFIndex(( short ) 0);
                break;


            case CELL_TYPE_BLANK :
                record = new BlankRecord();
                (( BlankRecord ) record).setColumn(col);
                (( BlankRecord ) record).setRow(row);
                (( BlankRecord ) record).setXFIndex(( short ) 0);
                break;

View Full Code Here

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

                }
                record = lrec;
                break;


            case CELL_TYPE_BLANK :
                BlankRecord brec = null;


                if (cellType != this.cellType)
                {
                    brec = new BlankRecord();
                }
                else
                {
                    brec = ( BlankRecord ) record;
                }
                brec.setColumn(getCellNum());


                // During construction the cellStyle may be null for a Blank cell.
                if (cellStyle != null)
                {
                    brec.setXFIndex(( short ) cellStyle.getIndex());
                }
                else
                {
                    brec.setXFIndex(( short ) 0);
                }
                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

                (( LabelSSTRecord ) record).setRow(row);
                (( LabelSSTRecord ) record).setXFIndex(( short ) 0);
                break;


            case CELL_TYPE_BLANK :
                record = new BlankRecord();
                (( BlankRecord ) record).setColumn(col);
                (( BlankRecord ) record).setRow(row);
                (( BlankRecord ) record).setXFIndex(( short ) 0);
                break;

View Full Code Here

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

                }
                record = lrec;
                break;


            case CELL_TYPE_BLANK :
                BlankRecord brec = null;


                if (cellType != this.cellType)
                {
                    brec = new BlankRecord();
                }
                else
                {
                    brec = ( BlankRecord ) record;
                }
                brec.setColumn(getCellNum());


                // During construction the cellStyle may be null for a Blank cell.
                if (cellStyle != null)
                {
                    brec.setXFIndex(( short ) cellStyle.getIndex());
                }
                else
                {
                    brec.setXFIndex(( short ) 0);
                }
                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

                (( LabelSSTRecord ) record).setRow(row);
                (( LabelSSTRecord ) record).setXFIndex(( short ) 0);
                break;


            case CELL_TYPE_BLANK :
                record = new BlankRecord();
                (( BlankRecord ) record).setColumn(col);
                (( BlankRecord ) record).setRow(row);
                (( BlankRecord ) record).setXFIndex(( short ) 0);
                break;

View Full Code Here

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

                }
                record = lrec;
                break;


            case CELL_TYPE_BLANK :
                BlankRecord brec = null;


                if (cellType != this.cellType)
                {
                    brec = new BlankRecord();
                }
                else
                {
                    brec = ( BlankRecord ) record;
                }
                brec.setColumn(getCellNum());


                // During construction the cellStyle may be null for a Blank cell.
                if (cellStyle != null)
                {
                    brec.setXFIndex(( short ) cellStyle.getIndex());
                }
                else
                {
                    brec.setXFIndex(( short ) 0);
                }
                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

  }


  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

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

    @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

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

    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

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

    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

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.