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

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


        sheet.removeValueRecord(getRowNum(), cval);
        cells.remove(new Integer(cell.getCellNum()));


        if (cell.getCellNum() == row.getLastCol())

View Full Code Here

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

     * @param cell to remove
     */


    public void removeCell(HSSFCell cell)
    {
        CellValueRecordInterface cval = cell.getCellValueRecord();


        sheet.removeValueRecord(getRowNum(), cval);
        cells.remove(new Integer(cell.getCellNum()));


        if (cell.getCellNum() == lastcell)

View Full Code Here

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

     * @param cell to remove
     */


    public void removeCell(HSSFCell cell)
    {
        CellValueRecordInterface cval = cell.getCellValueRecord();


        sheet.removeValueRecord(getRowNum(), cval);
        cells.remove(new Integer(cell.getCellNum()));


        /*

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

                Long.valueOf(timestart));
        HSSFRow lastrow = null;


        // Add every cell to its row
        for (int i = 0; i < cvals.length; i++) {
            CellValueRecordInterface cval = cvals[i];


            long cellstart = System.currentTimeMillis();
            HSSFRow hrow = lastrow;


            if (hrow == null || hrow.getRowNum() != cval.getRow()) {
                hrow = getRow( cval.getRow() );
                lastrow = hrow;
                if (hrow == null) {
                    // Some tools (like Perl module Spreadsheet::WriteExcel - bug 41187) skip the RowRecords
                    // Excel, OpenOffice.org and GoogleDocs are all OK with this, so POI should be too.
                    if (rowRecordsAlreadyPresent) {
                        // if at least one row record is present, all should be present.
                        throw new RuntimeException("Unexpected missing row when some rows already present");
                    }
                    // create the row record on the fly now.
                    RowRecord rowRec = new RowRecord(cval.getRow());
                    sheet.addRow(rowRec);
                    hrow = createRowFromRecord(rowRec);
                }
            }
            if (log.check( POILogger.DEBUG ))

View Full Code Here

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

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


        sheet.removeValueRecord(getRowNum(), cval);
        cells.remove(new Integer(cell.getCellNum()));


        if (cell.getCellNum() == row.getLastCol())

View Full Code Here

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

            createRowFromRecord(row);


            row = sheet.getNextRow();
        }
        sheet.setLoc(sloc);
        CellValueRecordInterface cval = sheet.getNextValueRecord();
        long timestart = System.currentTimeMillis();


        log.log(DEBUG, "Time at start of cell creating in HSSF sheet = ",
                new Long(timestart));
        HSSFRow lastrow = null;


        while (cval != null)
        {
            long cellstart = System.currentTimeMillis();
            HSSFRow hrow = lastrow;


            if ((lastrow == null) || (lastrow.getRowNum() != cval.getRow()))
            {
                hrow = getRow(cval.getRow());
            }
            lastrow = hrow;
            log.log(DEBUG, "record id = "+ Integer.toHexString(((Record)cval).getSid()));
            hrow.createCellFromRecord(cval);
            cval = sheet.getNextValueRecord();

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);
        cells.remove(new Integer(cell.getCellNum()));


        if (cell.getCellNum() == row.getLastCol())

View Full Code Here

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

                new Long(timestart));
        HSSFRow lastrow = null;


        // Add every cell to its row
        for (int i = 0; i < cvals.length; i++) {
            CellValueRecordInterface cval = cvals[i];


            long cellstart = System.currentTimeMillis();
            HSSFRow hrow = lastrow;


            if (hrow == null || hrow.getRowNum() != cval.getRow()) {
                hrow = getRow( cval.getRow() );
                lastrow = hrow;
                if (hrow == null) {
                    // Some tools (like Perl module Spreadsheet::WriteExcel - bug 41187) skip the RowRecords 
                    // Excel, OpenOffice.org and GoogleDocs are all OK with this, so POI should be too.
                    if (rowRecordsAlreadyPresent) {
                        // if at least one row record is present, all should be present.
                        throw new RuntimeException("Unexpected missing row when some rows already present");
                    }
                    // create the row record on the fly now.
                    RowRecord rowRec = new RowRecord(cval.getRow());
                    sheet.addRow(rowRec);
                    hrow = createRowFromRecord(rowRec);
                }
            }
            if (log.check( POILogger.DEBUG ))

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.