Examples of CellValueRecordInterface

org.apache.poi.hssf.record.CellValueRecordInterface
The cell value record interface is implemented by all classes of type Record that contain cell values. It allows the containing sheet to move through them and compare them. @author Andrew C. Oliver (acoliver at apache dot org) @see org.apache.poi.hssf.model.Sheet @see org.apache.poi.hssf.record.Record @see org.apache.poi.hssf.record.RecordFactory
org.zkoss.poi.hssf.record.CellValueRecordInterface

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

            // Copy each cell from the source row to
            //  the destination row
            for(Iterator<Cell> cells = row.cellIterator(); cells.hasNext(); ) {
                HSSFCell cell = (HSSFCell)cells.next();
                row.removeCell( cell );
                CellValueRecordInterface cellRecord = cell.getCellValueRecord();
                cellRecord.setRow( rowNum + n );
                row2Replace.createCellFromRecord( cellRecord );
                _sheet.addValueRecord( rowNum + n, cellRecord );


                HSSFHyperlink link = cell.getHyperlink();
                if(link != null){

View Full Code Here

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

        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

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

    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.CellValueRecordInterface

        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

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

            if (cell == null) {
                // Ignore empty cells
            } else if (currentSheet != null
                    && record instanceof CellValueRecordInterface) {
                // Normal cell inside a worksheet
                CellValueRecordInterface value =
                    (CellValueRecordInterface) record;
                Point point = new Point(value.getColumn(), value.getRow());
                currentSheet.put(point, cell);
            } else {
                // Cell outside the worksheets
                handler.startElement("div", "class", "outside");
                cell.render(handler);

View Full Code Here

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

        }


        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

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

    int thisRow;
    int thisColumn;
    CellValueRecordInterface[] expandedRecords = null;


    if (record instanceof CellValueRecordInterface) {
      CellValueRecordInterface valueRec = (CellValueRecordInterface) record;
      thisRow = valueRec.getRow();
      thisColumn = valueRec.getColumn();
    } else {
            if (record instanceof StringRecord){
                //it contains only cashed result of the previous FormulaRecord evaluation
                childListener.processRecord(record);
                return;

View Full Code Here

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

            if (cell == null) {
                // Ignore empty cells
            } else if (currentSheet != null
                    && record instanceof CellValueRecordInterface) {
                // Normal cell inside a worksheet
                CellValueRecordInterface value =
                    (CellValueRecordInterface) record;
                Point point = new Point(value.getColumn(), value.getRow());
                currentSheet.put(point, cell);
            } else {
                // Cell outside the worksheets
                extraTextCells.add(cell);
            }

View Full Code Here

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

            if (cell == null) {
                // Ignore empty cells
            } else if (currentSheet != null
                    && record instanceof CellValueRecordInterface) {
                // Normal cell inside a worksheet
                CellValueRecordInterface value =
                    (CellValueRecordInterface) record;
                Point point = new Point(value.getColumn(), value.getRow());
                currentSheet.put(point, cell);
            } else {
                // Cell outside the worksheets
                extraTextCells.add(cell);
            }

View Full Code Here

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

     * remove the HSSFCell from this row.
     * @param cell to remove
     */
    public void removeCell(HSSFCell cell)
    {
        CellValueRecordInterface cval = cell.getCellValueRecord();


        sheet.removeValueRecord(getRowNum(), cval);
        short column=cell.getCellNum();
        if(cell!=null && column<cells.length)
        {

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.