Examples of NumberRecord

org.apache.poi.hssf.record.NumberRecord
Contains a numeric cell value.
REFERENCE: PG 334 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.NumberRecord

   */
  public void testMissingDims() {


    int rowIx = 5;
    int colIx = 6;
    NumberRecord nr = new NumberRecord();
    nr.setRow(rowIx);
    nr.setColumn((short) colIx);
    nr.setValue(3.0);


    List<Record> inRecs = new ArrayList<Record>();
    inRecs.add(BOFRecord.createSheetBOF());
    inRecs.add(new RowRecord(rowIx));
    inRecs.add(nr);

View Full Code Here

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

                frec.setXFIndex(styleIndex);
                _record = frec;
                break;


            case CELL_TYPE_NUMERIC :
                NumberRecord nrec = null;


                if (cellType != _cellType)
                {
                    nrec = new NumberRecord();
                }
                else
                {
                    nrec = ( NumberRecord ) _record;
                }
                nrec.setColumn(col);
                if (setValue)
                {
                    nrec.setValue(getNumericCellValue());
                }
                nrec.setXFIndex(styleIndex);
                nrec.setRow(row);
                _record = nrec;
                break;


            case CELL_TYPE_STRING :
                LabelSSTRecord lrec;

View Full Code Here

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

                UnicodeString unicode = sstRecord.getString(sst.getSSTIndex());
                addTextCell(record, unicode.getString());
                break;


            case NumberRecord.sid: // Contains a numeric cell value
                NumberRecord number = (NumberRecord) record;
                addCell(record, new NumberCell(number.getValue(), format));
                break;


            case RKRecord.sid: // Excel internal number record
                RKRecord rk = (RKRecord) record;
                addCell(record, new NumberCell(rk.getRKNumber(), format));

View Full Code Here

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

        NoteRecord nrec = (NoteRecord) record;
        thisRow = nrec.getRow();
        // TODO: Find object to match nrec.getShapeId()
        break;
      case NumberRecord.sid:
        NumberRecord numrec = (NumberRecord) record;
        thisRow = numrec.getRow();
        thisText = _ft.formatNumberDateCell(numrec);
        break;
      default:
        break;
      }

View Full Code Here

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

      thisColumn = nrec.getColumn();
      // TODO: Find object to match nrec.getShapeId()
      thisStr = '"' + "(TODO)" + '"';
      break;
    case NumberRecord.sid:
      NumberRecord numrec = (NumberRecord) record;


      thisRow = numrec.getRow();
      thisColumn = numrec.getColumn();


      // Format
      thisStr = formatListener.formatNumberDateCell(numrec);
      break;
    case RKRecord.sid:

View Full Code Here

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

               NoteRecord nrec = (NoteRecord) record;
               thisRow = nrec.getRow();
               // TODO: Find object to match nrec.getShapeId()
               break;
           case NumberRecord.sid:
               NumberRecord numrec = (NumberRecord) record;
               thisRow = numrec.getRow();
               thisText = _ft.formatNumberDateCell(numrec);
               break;
           default:
               break;
           }

View Full Code Here

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

                frec.setXFIndex(styleIndex);
                _record = frec;
                break;


            case CELL_TYPE_NUMERIC :
                NumberRecord nrec = null;


                if (cellType != _cellType)
                {
                    nrec = new NumberRecord();
                }
                else
                {
                    nrec = ( NumberRecord ) _record;
                }
                nrec.setColumn(col);
                if (setValue)
                {
                    nrec.setValue(getNumericCellValue());
                }
                nrec.setXFIndex(styleIndex);
                nrec.setRow(row);
                _record = nrec;
                break;


            case CELL_TYPE_STRING :
                LabelSSTRecord lrec;

View Full Code Here

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

                UnicodeString unicode = sstRecord.getString(sst.getSSTIndex());
                addTextCell(record, unicode.getString());
                break;


            case NumberRecord.sid: // Contains a numeric cell value
                NumberRecord number = (NumberRecord) record;
                addTextCell(record, formatListener.formatNumberDateCell(number));
                break;


            case RKRecord.sid: // Excel internal number record
                RKRecord rk = (RKRecord) record;

View Full Code Here

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

                UnicodeString unicode = sstRecord.getString(sst.getSSTIndex());
                addTextCell(record, unicode.getString());
                break;


            case NumberRecord.sid: // Contains a numeric cell value
                NumberRecord number = (NumberRecord) record;
                addTextCell(record, formatListener.formatNumberDateCell(number));
                break;


            case RKRecord.sid: // Excel internal number record
                RKRecord rk = (RKRecord) record;

View Full Code Here

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

     */
    public void processRecord(Record record) {
        try {
            switch (record.getSid()) {
                case NumberRecord.sid: {
                    NumberRecord numrec = (NumberRecord) record;


                    excelText.append(numrec.getValue());
                    excelText.append('\n');


                    break;
                }
                // SSTRecords store a array of unique strings used in Excel

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.