ezcelldemo.java

用Java写的报表.功能如下: 0.内建网络打印,网络预览功能！ 1.文件操作。包括url 指定的文件。 2.全功能打印支持。包括打印预览。 3.Undo 和 redo。 4.合并单元格。 5.Cel

            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatBackBrush() {
        ZBrushChooser chooser = ZBrushChooser.getSharedInstance(this);

        if (chooser.show(cellBean.getActiveCell().getBackBrush()) == JOptionPane.OK_OPTION) {
            try {
                cellBean.setSelectionBackBrush(null, null, chooser.getSelectedBrush());
            } catch (Exception ex) {
                alert(ex.getMessage());
            }
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatBackColor(ActionEvent e) {
        Color color = (Color) ((JComboBox) e.getSource()).getSelectedItem();

        if (color != null) {
            ZBrush brush = new ZColorBrush(color);

            try {
                cellBean.setSelectionBackBrush(null, null, brush);
            } catch (Exception ex) {
                alert(ex.getMessage());
            }
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatBorder() {
        try {
            ZBorderChooser chooser = ZBorderChooser.getSharedInstance(this);

            if (chooser.showDialog() != JOptionPane.OK_OPTION) {
                return;
            }

            cellBean.setSelectionBorders(null, null, chooser.getPens());
        } catch (Exception e) {
            alert(e.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatColsWidth() {
        ZResizeDialog chooser = ZResizeDialog.getSharedInstance(this);

        if (chooser.showWidth(cellBean.getActiveCell().getWidth()) == JOptionPane.OK_OPTION) {
            try {
                cellBean.setSelectionWidth(null, null, chooser.getSelectedSize());
            } catch (Exception ex) {
                alert(ex.getMessage());
            }
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatFont() {
        ZFontChooser chooser = ZFontChooser.getSharedInstace(this);

        if (chooser.show(cellBean.getActiveCell().getFont()) == JOptionPane.OK_OPTION) {
            try {
                cellBean.setSelectionFont(null, null, chooser.getSelectedFont());
            } catch (Exception ex) {
                alert(ex.getMessage());
            }
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatFontBold(ActionEvent e) {
        JToggleButton button = (JToggleButton) e.getSource();

        try {
            cellBean.setSelectionFontBold(null, null, button.isSelected());
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatFontItalic(ActionEvent e) {
        JToggleButton button = (JToggleButton) e.getSource();

        try {
            cellBean.setSelectionFontItalic(null, null, button.isSelected());
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatFontName(ActionEvent e) {
        JComboBox fn = (JComboBox) e.getSource();

        try {
            cellBean.setSelectionFontName(null, null, fn.getSelectedItem().toString());
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatFontOutline(ActionEvent e) {
        JToggleButton button = (JToggleButton) e.getSource();

        try {
            cellBean.setSelectionFontOutline(null, null, button.isSelected());
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatFontPlain(ActionEvent e) {
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatFontSize(ActionEvent e) {
        int fontSize = 0;
        JComboBox fs = (JComboBox) e.getSource();

        try {
            fontSize = Integer.parseInt(fs.getSelectedItem().toString());
            cellBean.setSelectionFontSize(null, null, fontSize);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatMerge(ActionEvent e) {
        try {
            AbstractButton button = (AbstractButton) e.getSource();
            cellBean.mergeSelection(null, null, button.isSelected());
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatNumberFormat(ActionEvent e) {
        try {
            String format;

            if (e.getSource() == ahs[FORMAT_NUMBER_FORMAT].getValue("BUTTON")) {
                if (((JComboBox) e.getSource()).getSelectedIndex() > 0) {
                    format = (String) ((JComboBox) e.getSource()).getSelectedItem();
                } else {
                    format = "";
                }
            } else {
                format = JOptionPane.showInputDialog("Format:");
            }

            if (format != null) {
                cellBean.setSelectionFormat(null, null, format);
            }
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatRowsHeight() {
        ZResizeDialog chooser = ZResizeDialog.getSharedInstance(this);

        if (chooser.showHeight(cellBean.getActiveCell().getHeight()) == JOptionPane.OK_OPTION) {
            try {
                cellBean.setSelectionHeight(null, null, chooser.getSelectedSize());
            } catch (Exception ex) {
                alert(ex.getMessage());
            }
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onFormatTextBrush() {
        ZBrushChooser chooser = ZBrushChooser.getSharedInstance(this);

        if (chooser.show(cellBean.getActiveCell().getTextBrush()) == JOptionPane.OK_OPTION) {
            try {
                cellBean.setSelectionTextBrush(null, null, chooser.getSelectedBrush());
            } catch (Exception ex) {
                alert(ex.getMessage());
            }
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatTextColor(ActionEvent e) {
        Color color = (Color) ((JComboBox) e.getSource()).getSelectedItem();

        if (color != null) {
            ZBrush brush = new ZColorBrush(color);

            try {
                cellBean.setSelectionTextBrush(null, null, brush);
            } catch (Exception ex) {
                alert(ex.getMessage());
            }
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onFormatWordWrap(ActionEvent e) {
        try {
            AbstractButton button = (AbstractButton) e.getSource();
            cellBean.setSelectionWordWrap(null, null, button.isSelected());
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onLockup() {
        try {
            cellBean.setSelectionReadOnly(null, null, true);
        } catch (Exception ex) {
            alert(ex.getMessage());
        }
    }

    /**
     * DOCUMENT ME!
     */
    private void onSearchFind() {
        cellBean.find(this);
    }

    /**
     * DOCUMENT ME!
     */
    private void onSearchFindNext() {
        //cellBean.replace();
    }

    /**
     * DOCUMENT ME!
     */
    private void onSearchGoto() {
        cellBean.searchGoto(this);
    }

    /**
     * DOCUMENT ME!
     */
    private void onSearchReplace() {
        cellBean.replace(this);
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onViewPage(ActionEvent e) {
        if (((AbstractButton) e.getSource()).isSelected()) {
            cellBean.startEditPage();
        } else {
            cellBean.endEditPage();
        }
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onViewToggleGridX(ActionEvent e) {
        cellBean.setGridXVisible(((JMenuItem) (e.getSource())).isSelected());
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onViewToggleGridY(ActionEvent e) {
        cellBean.setGridYVisible(((JMenuItem) (e.getSource())).isSelected());
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onViewToggleLeftHeader(ActionEvent e) {
        cellBean.setLeftHeaderVisible(((JMenuItem) (e.getSource())).isSelected());
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onViewToggleScrollBar(ActionEvent e) {
        cellBean.setScrollbarVisible(((JMenuItem) (e.getSource())).isSelected());
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onViewToggleSelection(ActionEvent e) {
        cellBean.setSelectionVisible(((JMenuItem) (e.getSource())).isSelected());
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onViewToggleToolbar(ActionEvent e) {
        JMenuItem item = (JMenuItem) e.getSource();

        if (item.isSelected() && !contain(toolpane)) {
            getContentPane().add(toolpane, BorderLayout.NORTH);
        } else {
            remove(toolpane);
        }

        this.getContentPane().validate();
    }

    /**
     * DOCUMENT ME!
     *
     * @param e DOCUMENT ME!
     */
    private void onViewToggleTopHeader(ActionEvent e) {
        cellBean.setTopHeaderVisible(((JMenuItem) (e.getSource())).isSelected());