Examples of SpreadSheet

com.projity.pm.graphic.spreadsheet.SpreadSheet
org.formulacompiler.spreadsheet.Spreadsheet
Represents a spreadsheet model in memory. It can be constructed from different spreadsheet file formats, for example Excel .xls and .xml, and OpenOffice Calc (see {@link SpreadsheetCompiler#loadSpreadsheet(java.io.File)}). It serves as input to the {@link SpreadsheetToEngineCompiler} implementations and thus decouples engine compilation fromthe different spreadsheet file formats supported by AFC.
The spreadsheet model is immutable except for one thing. As a convenience, you can add custom range names to be used by {@link #getCell(String)}, {@link #getRange(String)}, and {@link #getRangeNames()}. These are never used internally to resolve formula references and do not affect the semantics of the spreadsheet model. We support this convenience so that code already written against the {@link #getCell(String)} API can transparently profit from namesextracted from a spreadsheet's layout, for instance.
The handling of additional range names is not thread-safe.
This interface is an API only. Do not implement it yourself. @see SpreadsheetLoader @see SpreadsheetBuilder @see SpreadsheetToEngineCompiler @author peo
org.jopendocument.dom.spreadsheet.SpreadSheet
org.zkoss.zss.ui.Spreadsheet
Spreadsheet is a rich ZK Component to handle EXCEL like behavior, it reads the data from a data model( {@link Book}) and interact with this model by event.
You can assign a Book by {@link #setBook(Book)} or just set the .xls file location by {@link #setSrc(String)}. You also need to set two attributes to restrict max rows and columns to show on client side by {@link #setMaxrows(int)} and {@link #setMaxcolumns(int)}.
To use Spreadsheet in .zul file, just use <spreadsheet/> tag like any other ZK Components.
An simplest example :
<spreadsheet src="/WEB-INF/xls/my.xls" maxrows="300" maxcolumns="80"
height="400px" width="90%" /> @author dennischen
pt.utl.ist.fenix.tools.util.excel.Spreadsheet

Examples of com.projity.pm.graphic.spreadsheet.SpreadSheet


  Set getActionSet(){
    Set actions=null;
    DocumentFrame df=getCurrentFrame();
    if (df!=null){
      SpreadSheet sp=df.getActiveSpreadSheet();
      actions=new HashSet();
      if (sp!=null){
        String[] a=sp.getActionList();
        if (a!=null){
          for (int i=0;i<a.length;i++) actions.add(a[i]);
        }
      }
    }

View Full Code Here

Examples of com.projity.pm.graphic.spreadsheet.SpreadSheet

  public int getScale() {
    return activeTopView==null?-1:activeTopView.getScale();
  }


  public void doOutdent() {
    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.executeAction(MenuActionConstants.ACTION_OUTDENT);
  }

View Full Code Here

Examples of com.projity.pm.graphic.spreadsheet.SpreadSheet

    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.executeAction(MenuActionConstants.ACTION_OUTDENT);
  }
  public void doExpand() {
    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.executeAction(MenuActionConstants.ACTION_EXPAND);
  }

View Full Code Here

Examples of com.projity.pm.graphic.spreadsheet.SpreadSheet

    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.executeAction(MenuActionConstants.ACTION_EXPAND);
  }
  public void doCollapse() {
    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.executeAction(MenuActionConstants.ACTION_COLLAPSE);
  }

View Full Code Here

Examples of com.projity.pm.graphic.spreadsheet.SpreadSheet

    if (ss !=null)
      ss.executeAction(MenuActionConstants.ACTION_COLLAPSE);
  }


  public void doIndent() {
    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.executeAction(MenuActionConstants.ACTION_INDENT);
  }

View Full Code Here

Examples of com.projity.pm.graphic.spreadsheet.SpreadSheet

    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.executeAction(MenuActionConstants.ACTION_INDENT);
  }
  public void doDelete() {
    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.executeAction(MenuActionConstants.ACTION_DELETE);
  }

View Full Code Here

Examples of com.projity.pm.graphic.spreadsheet.SpreadSheet

    if (ss !=null)
      ss.executeAction(MenuActionConstants.ACTION_DELETE);
  }


  public void doCut() {
    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.prepareAction(MenuActionConstants.ACTION_CUT).actionPerformed(new ActionEvent(ss,0,null));
      //NodeListTransferHandler.getCutAction(ss).actionPerformed(new ActionEvent(this,0,null));
      //ss.executeAction(SpreadSheet.CUT);
  }

View Full Code Here

Examples of com.projity.pm.graphic.spreadsheet.SpreadSheet

      ss.prepareAction(MenuActionConstants.ACTION_CUT).actionPerformed(new ActionEvent(ss,0,null));
      //NodeListTransferHandler.getCutAction(ss).actionPerformed(new ActionEvent(this,0,null));
      //ss.executeAction(SpreadSheet.CUT);
  }
  public void doCopy() {
    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.prepareAction(MenuActionConstants.ACTION_COPY).actionPerformed(new ActionEvent(ss,0,null));
      //NodeListTransferHandler.getCopyAction(ss).actionPerformed(new ActionEvent(this,0,null));
      //ss.executeAction(SpreadSheet.COPY);
  }

View Full Code Here

Examples of com.projity.pm.graphic.spreadsheet.SpreadSheet

      ss.prepareAction(MenuActionConstants.ACTION_COPY).actionPerformed(new ActionEvent(ss,0,null));
      //NodeListTransferHandler.getCopyAction(ss).actionPerformed(new ActionEvent(this,0,null));
      //ss.executeAction(SpreadSheet.COPY);
  }
  public void doPaste() {
    SpreadSheet ss = getActiveSpreadSheet();
    if (ss !=null)
      ss.prepareAction(MenuActionConstants.ACTION_PASTE).actionPerformed(new ActionEvent(ss,0,null));
      //NodeListTransferHandler.getPasteAction(ss).actionPerformed(new ActionEvent(this,0,null));
      //ss.executeAction(SpreadSheet.PASTE);
  }

View Full Code Here

Examples of com.projity.pm.graphic.spreadsheet.SpreadSheet


  /**
   * @return Returns the topSpreadSheet.
   */
  public SpreadSheet getActiveSpreadSheet() {
    SpreadSheet ss = getTopSpreadSheet();
    if (ss == null) {
      if (activeBottomView != null)
        ss = activeBottomView.getSpreadSheet();


    }

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.