zsheet.java

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

/*
 * Copyright 2002 EZCell , Inc. All rights reserved.
 * Version  1.0.
 * Author   W.John
 */
package ezcell;

import java.awt.datatransfer.Transferable;
import java.util.Enumeration;
import java.util.Vector;


/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2001</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */
public interface ZSheet {
    /**
     *
     * @return
     */
    public ZBook getBook();

    /**
     *
     * @param row
     * @param col
     *
     * @return
     */
    public ZCell getCell(int row, int col);

    /**
     *
     * @param c
     *
     * @return
     */
    public int getColWidth(int c);

    /**
     *
     * @return
     */
    public int getLastCol();

    /**
     *
     * @return
     */
    public int getLastRow();

    /**
     *
     * @param seed
     *
     * @return
     */
    public ZRect getMerged(ZRect seed);

    /**
     *
     * @return
     */
    public Enumeration getParentCellsEnum();

    /**
     *
     * @return
     */
    public ZRect getPrintableCells();

    /**
     *
     * @param r
     *
     * @return
     */
    public int getRowHeight(int r);

    /**
     *
     * @param rect
     * @param value
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionBackBrush(ZRect rect, ZBrush value)
                               throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param pens
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionBorders(ZRect rect, ZPen[] pens)
                             throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param font
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionFont(ZRect rect, ZFont font)
                          throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param fontBold
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionFontBold(ZRect rect, boolean fontBold)
                              throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param fontItalic
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionFontItalic(ZRect rect, boolean fontItalic)
                                throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param fontName
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionFontName(ZRect rect, String fontName)
                              throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param fontOutline
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionFontOutline(ZRect rect, boolean fontOutline)
                                 throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param fontSize
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionFontSize(ZRect rect, int fontSize)
                              throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param format
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionFormat(ZRect rect, String format)
                            throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param height
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionHeight(ZRect rect, int height)
                            throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param value
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionHorzAlign(ZRect rect, int value)
                               throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param value
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionReadOnly(ZRect rect, boolean value)
                              throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param value
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionTextBrush(ZRect rect, ZBrush value)
                               throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param dropHelper
     *
     * @return
     */
    public Transferable getSelectionTransferable(ZRect rect, ZRect dropHelper);

    /**
     *
     * @param rect
     * @param value
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionVertAlign(ZRect rect, int value)
                               throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param width
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionWidth(ZRect rect, int width)
                           throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param value
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionWordWrap(ZRect rect, boolean value)
                              throws ZSelectionNoSupported;

    /**
     *
     * @param byrow
     *
     * @return
     */
    public Vector getSortedCells(boolean byrow);

    /**
     *
     * @param title
     */
    public void setTitle(String title);

    /**
     *
     * @return
     */
    public String getTitle();

    /**
     *
     * @param listener
     */
    public void addListener(ZSheetListener listener);

    /**
     *
     * @param rect
     *
     * @return
     *
     * @throws ZSelectionNoSupported
     */
    public ZCmdClear clearSelection(ZRect rect) throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     *
     * @return
     *
     * @throws ZSelectionNoSupported
     */
    public ZCmdFormat clearSelectionText(ZRect rect) throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     *
     * @throws ZSelectionNoSupported
     */
    public void copySelection(ZRect rect) throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     *
     * @throws ZSelectionNoSupported
     */
    public void cutSelection(ZRect rect) throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     *
     * @throws ZSelectionNoSupported
     */
    public void insertSelection(ZRect rect) throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     * @param merge
     *
     * @throws ZSelectionNoSupported
     */
    public void mergeSelection(ZRect rect, boolean merge)
                        throws ZSelectionNoSupported;

    /**
     *
     * @param rect
     *
     * @throws Exception
     */
    public void pasteIntoSelection(ZRect rect) throws Exception;

    /**
     *
     * @param rect
     *
     * @throws Exception
     */
    public void pasteTextIntoSelection(ZRect rect) throws Exception;

    /**
     *
     * @param rect
     *
     * @throws ZSelectionNoSupported
     */
    public void removeSelection(ZRect rect) throws ZSelectionNoSupported;
    public void removeRowsSelection(ZRect rect) throws ZSelectionNoSupported ;
    public void removeColsSelection(ZRect rect) throws ZSelectionNoSupported ;
}

abstract class ZAbstractSheet implements ZSheet {
    /**
     *
     * @param c
     *
     * @return
     */
    public int getColWidth(int c) {
        return (c == 0) ? 40 : 70;
    }

    /**
     *
     * @param r
     *
     * @return
     */
    public int getRowHeight(int r) {
        return 30;
    }

    /**
     *
     * @param rect
     * @param pens
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionBorders(ZRect rect, ZPen[] pens)
                             throws ZSelectionNoSupported {
    }

    /**
     *
     * @param rect
     *
     * @return
     */
    public ZCmdClear setSelectionClear(ZRect rect) {
        return null;
    }

    /**
     *
     * @param rect
     * @param fontBold
     */
    public void setSelectionFontBold(ZRect rect, boolean fontBold) {
    }

    /**
     *
     * @param rect
     * @param fontItalic
     */
    public void setSelectionFontItalic(ZRect rect, boolean fontItalic) {
    }

    /**
     *
     * @param rect
     * @param fontName
     */
    public void setSelectionFontName(ZRect rect, String fontName) {
    }

    /**
     *
     * @param rect
     * @param fontOutline
     */
    public void setSelectionFontOutline(ZRect rect, boolean fontOutline) {
    }

    /**
     *
     * @param rect
     * @param fontSize
     */
    public void setSelectionFontSize(ZRect rect, int fontSize) {
    }

    /**
     *
     * @param rect
     * @param height
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionHeight(ZRect rect, int height)
                            throws ZSelectionNoSupported {
    }

    /**
     *
     * @param rect
     * @param width
     *
     * @throws ZSelectionNoSupported
     */
    public void setSelectionWidth(ZRect rect, int width)
                           throws ZSelectionNoSupported {
    }

    /**
     *
     * @return
     */
    public String getTitle() {
        return "EZCell demo ";
    }

    /**
     *
     * @param rect
     */
    public void copySelection(ZRect rect) {
    }

    /**
     *
     * @param rect
     */
    public void cutSelection(ZRect rect) {
    }

    /**
     *
     * @param rect
     *
     * @throws ZSelectionNoSupported
     */
    public void insertSelection(ZRect rect) throws ZSelectionNoSupported {
    }

    /**
     *
     * @param rect
     * @param merge
     *
     * @throws ZSelectionNoSupported
     */
    public void mergeSelection(ZRect rect, boolean merge)
                        throws ZSelectionNoSupported {
    }

    /**
     *
     * @param rect
     */
    public void pasteTextIntoSelection(ZRect rect) {
    }

    /**
     *
     * @param rect
     *
     * @throws ZSelectionNoSupported
     */
    public void removeSelection(ZRect rect) throws ZSelectionNoSupported {
    }
}