case HSSFCell.CELL_TYPE_FORMULA:

  public boolean isCellEditable(int rowIndex, int columnIndex) {

    return true;

  }

  public void setValueAt(Object aValue, int rowIndex, int columnIndex) {

    if (aValue != null)

      System.out.println("SVTableModel.setValueAt. value type = "+aValue.getClass().getName());

    else System.out.println("SVTableModel.setValueAt. value type = null");

  }

      System.exit(1);

    BufferedInputStream is = new BufferedInputStream(uc.getInputStream());

import javax.swing.table.*;

import javax.swing.event.*;

  /** This field is the magic number to convert from a Character width to a

   *  java pixel width.

   *

   * When the "normal" font size in a workbook changes, this effects all

   * of the heights and widths. Unfortunately there is no way to retrieve this

   * information, hence the MAGIC number.

   *

   * This number may only work for the normal style font size of Arial size 10.

   *

   */

  private static final int magicCharFactor = 7;

  /** Reference to the woorkbook that is being displayed*/

    this.allowEdits = allowEdits;

    initialiseGui();

  }

  private void initialiseGui() {

    cellRenderer = new SVTableCellRenderer(this.wb);

    if (allowEdits)

      cellEditor = new SVTableCellEditor(this.wb);

  protected JComponent makeSheetView(HSSFSheet sheet) {

    JTable sheetView = new JTable(new SVTableModel(sheet));

    sheetView.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

    sheetView.setDefaultRenderer(HSSFCell.class, cellRenderer);

    if (allowEdits)

      sheetView.setDefaultEditor(HSSFCell.class, cellEditor);

    JTableHeader header = sheetView.getTableHeader();

    //Dont allow column reordering

    header.setReorderingAllowed(false);

    //Only allow column resizing if editing is allowed

    header.setResizingAllowed(allowEdits);

    //Set the columns the correct size

    TableColumnModel columns = sheetView.getColumnModel();

    for (int i=0; i< columns.getColumnCount(); i++) {

      TableColumn column = columns.getColumn(i);

      short width = sheet.getColumnWidth((short)i);

      //256 is because the width is in 256ths of a character

      column.setPreferredWidth(width/256*magicCharFactor);

    }

    //Set the rows to the correct size

    int rows = sheet.getPhysicalNumberOfRows();

    Insets insets = cellRenderer.getInsets();

    //Need to include the insets in the calculation of the row height to use.

    int extraHeight = insets.bottom+insets.top;

    for (int i=0; i< rows; i++) {

      HSSFRow row = sheet.getRow(i);

      if (row == null) {

        sheetView.setRowHeight(i, (int)sheet.getDefaultRowHeightInPoints()+extraHeight);

      } else {

        sheetView.setRowHeight(i, (int)row.getHeightInPoints()+extraHeight);

      }

    }

    //Add the row header to the sheet

    SVRowHeader rowHeader = new SVRowHeader(sheet, sheetView, extraHeight);

    JScrollPane scroll = new JScrollPane( sheetView );

    scroll.setRowHeaderView(rowHeader);

    return scroll;

  }

    //JMH I am only overriding this to get a picture of the time taken to paint

  protected MouseListener createTabListener() {

    return new TabListener();

  }

  /** This class defines the default MouseListener that listens to

   *  mouse events in the tabbed pane

   *

   *  The default is to popup a menu when the event occurs over a tab

   */

  private class TabListener implements MouseListener {

    public JPopupMenu popup;

    public TabListener() {

      popup = new JPopupMenu("Sheet");

      popup.add(createInsertSheetAction());

      popup.add(createDeleteSheetAction());

      popup.add(createRenameSheetAction());

    }

    protected Action createInsertSheetAction() {

      return new InsertSheetAction();

    }

    protected Action createDeleteSheetAction() {

      return new DeleteSheetAction();

    }

    protected Action createRenameSheetAction() {

      return new RenameSheetAction();

    }

    /** This method will display the popup if the mouseevent is a popup event

     *  and the event occurred over a tab

     */

    protected void checkPopup(MouseEvent e) {

      if (e.isPopupTrigger()) {

        int tab = sheetPane.getUI().tabForCoordinate(sheetPane, e.getX(), e.getY());

        if (tab != -1) {

          popup.show(sheetPane, e.getX(), e.getY());

        }

      }

    }

    public void mouseClicked(MouseEvent e) {

      checkPopup(e);

    }

    public void mousePressed(MouseEvent e) {

      checkPopup(e);

    }

    public void mouseReleased(MouseEvent e) {

      checkPopup(e);

    }

    public void mouseEntered(MouseEvent e) {}

    public void mouseExited(MouseEvent e) {}

  }

  /** This class defines the action that is performed when the sheet is renamed*/

  private class RenameSheetAction extends AbstractAction {

    public RenameSheetAction() {

      super("Rename");

    }

    public void actionPerformed(ActionEvent e) {

      int tabIndex = sheetPane.getSelectedIndex();

      if (tabIndex != -1) {

        String newSheetName = (String)JOptionPane.showInputDialog(sheetPane, "Enter a new Sheetname", "Rename Sheet", JOptionPane.QUESTION_MESSAGE);

        if (newSheetName != null) {

          wb.setSheetName(tabIndex, newSheetName);

          sheetPane.setTitleAt(tabIndex, newSheetName);

        }

      }

    }

  }

  /** This class defines the action that is performed when a sheet is inserted*/

  private class InsertSheetAction extends AbstractAction {

    public InsertSheetAction() {

      super("Insert");

    }

    public void actionPerformed(ActionEvent e) {

      //Create a new sheet then search for the sheet and make sure that the

      //sheetPane shows it.

      HSSFSheet newSheet = wb.createSheet();

      for (int i=0; i<wb.getNumberOfSheets();i++) {

        HSSFSheet sheet = wb.getSheetAt(i);

        if (newSheet == sheet) {

          sheetPane.insertTab(wb.getSheetName(i), null, makeSheetView(sheet), null, i);

        }

      }

    }

  }

  /** This class defines the action that is performed when the sheet is deleted*/

  private class DeleteSheetAction extends AbstractAction {

    public DeleteSheetAction() {

      super("Delete");

    }

    public void actionPerformed(ActionEvent e) {

      int tabIndex = sheetPane.getSelectedIndex();

      if (tabIndex != -1) {

        if (JOptionPane.showConfirmDialog(sheetPane, "Are you sure that you want to delete the selected sheet", "Delete Sheet?", JOptionPane.OK_CANCEL_OPTION) == JOptionPane.OK_OPTION) {

          wb.removeSheetAt(tabIndex);

          sheetPane.remove(tabIndex);

        }

      }

    }

  }

  public boolean isEditable() {

    return allowEdits;

  }