Examples of org.zkoss.zss.model.Book

org.zkoss.zss.model.Book
Represent a spread sheet book. @author henrichen

    assertValue(1d+10d+100d +1.0E4+1.0E5+1.0E6,
        ((Number)cell.getResult()).doubleValue(), 1d);
  }


  public void testRefARange() {
    Book book = new ExcelImporter().imports(getClass().getResource("/refrange.xls"));
    String[] names = book.getNameRangeNames();
    System.out.println("names="+Objects.toString(names));
    Sheet sheet = (Sheet) book.getSheets().get(0);


    //test single column range
    for (int j = 1; j < 8; ++j) { //A1 ~ A7
      Cell cell = sheet.getCell(j-1,0);
      assertEquals(""+j, cell.getText());

View Full Code Here

      assertEquals("100", cell.getText());
    }
  }


  public void testRefARange2() {
    Book book = new ExcelImporter().imports(getClass().getResource("/namedRange.xls"));
    String[] names = book.getNameRangeNames();
    System.out.println("names="+Objects.toString(names));
    Sheet sheet = (Sheet) book.getSheets().get(0);


    {
      Cell cell = sheet.getCell(0,1); //B1
      assertEquals("10", cell.getText());
    }

View Full Code Here

    getAbacus().parseFormula(formula, newXelContext());
    _result = null;
  }
  
  private XelContext newXelContext() {
    final Book book = getSheet().getBook();
    
    //VariableResolver
    final SSMapResolver resolver = new SSMapResolver(((XelContext)book).getVariableResolver());
    final Reference ref = addRef(); //add it back whenever there is new formula
    ((Ref2d)ref).setUpdatable(true); //and of course a cell is an updatable reference

View Full Code Here

    
    return new SimpleXelContext(resolver, ((XelContext)book).getFunctionMapper());
  }
  
  private XelContext newRemoveContext() {
    final Book book = getSheet().getBook();
    
    //VariableResolver
    final SSMapResolver resolver = new SSMapResolver(((XelContext)book).getVariableResolver());
    final Reference ref = getRef();
    resolver.set("zkoss.ss.Ref", ref);

View Full Code Here

  /* (non-Javadoc)
   * @see junit.framework.TestCase#setUp()
   */
  protected void setUp() throws Exception {
    super.setUp();
    final Book book = new BookImpl("Mybook");
    _sheet = new SheetImpl(book, "Sheet1", 256, 64*1024);
    _im = ((SheetImpl)_sheet).getMatrix();
    
    _ref1 = (Ref2d)_im.addRef(_sheet, null, 1, 2, 2, 4); //B3:C5
    _ref2 = (Ref2d)_im.addRef(_sheet, null, 3, 7, 4, 10); //D8:E11

View Full Code Here

      //prepare the original Reference
      final Reference orgref = ctx != null ? 
        (Reference) ctx.getVariableResolver().resolveVariable("zkoss.ss.Ref") : null;
      final SheetImpl sheet =  orgref != null ? 
        (SheetImpl) orgref.getSheet() : null;
      final Book book = sheet != null ? 
        sheet.getBook() : (ctx instanceof Book) ? (Book) ctx : null; 


      final String[] range = parseRange(value);
      final String sheetnm1 = range[0];
      final String sheetnm2 = range[1];
      final String cell1 = range[2];
      final String cell2 = range[3];


      int[] lt = null;
      int[] rb = null;
      boolean var1 = false;
      boolean var2 = false;


      lt = parseCell(cell1);
      var1 = (lt == null);


      if (cell2 != null) {
        rb = parseCell(cell2);
        var2 = (lt == null);
      } else { //cell2 == null
        // cell1 is single col but cell2 is not available, should be a variable
        if (!var1 && lt[1] == -1) { 
          var1 = true;
        }
      }
      if (lt != null && rb != null) {
        int l = lt[0];
        int t = lt[1];
        int absl = lt[2];
        int abst = lt[3];
        
        int r = rb[0];
        int b = rb[1];
        int absr = rb[2];
        int absb = rb[3];
        
        if (l > r) {
          int tmp = l;
          l = r;
          r = tmp;
          
          tmp = absl;
          absl = absr;
          absr = tmp;
          
          lt[0] = l;
          lt[2] = absl;
          rb[0] = r; 
          rb[2] = absr;
        }
        
        if (t > b) {
          int tmp = t;
          t = b;
          b = tmp;
          
          tmp = abst;
          abst = absb;
          absb = tmp;
          
          lt[1] = t;
          lt[3] = abst;
          rb[1] = b; 
          rb[3] = absb;
        }
      }
      final SheetImpl psheet1 = (book != null && sheetnm1 != null) ? 
          (SheetImpl)book.lookupSheet(sheetnm1) : sheet;
      final SheetImpl psheet2 = (book != null && sheetnm2 != null) ?
          (SheetImpl)book.lookupSheet(sheetnm2) : sheet;
//      final SheetImpl psheet1 = sheet1 != null ? sheet1 : sheet;
//      final SheetImpl psheet2 = sheet2 != null ? sheet2 : sheet;
      final boolean abssheet = book != null && (sheetnm1 != null || sheetnm2 != null);
      
      if (cell2 != null) { //a range
        if  (var1 || var2) {
          //prepare Range operator token
          operand.setType(TokenType.OP_IN);
          operand.setValue(":"); //as a Range operator
          if (var1) {
            //lookup NameRange
            final Range rng = book.lookupNameRange(cell1);
            if (rng != null) {
              ranges.add(rng);
              operand.addOperand(new Token(rng, TokenType.OPERAND, TokenSubtype.RANGE));
            } else {
              operand.addOperand(new Token(cell1, TokenType.OPERAND, TokenSubtype.VAR));
              if (!((BookImpl)book).addVariable(cell1, orgref)) {
                throw new XelException("Illegal variable name: "+cell1);
              }
            }
          } else {
            final Token token1 = 
              new Token(cell1, TokenType.OPERAND, TokenSubtype.CELL);
            //TODO: matain ref DAG graph
            //TODO: How do we handle variable range2d?
//            final SheetImpl psheet = sheet1 != null ? sheet1 : sheet;
//            final Abacus pabacus = psheet.getBook().getAbacus();
            final int left = lt[0];
            final int top = lt[1];
            final int right = left;
            final int bottom = top;
            final boolean absleft = lt[2] != 0;
            final boolean abstop = lt[3] != 0;
            final boolean absright = absleft;
            final boolean absbottom = abstop;
            final Range rng = psheet1 == null ? RangeRefError.RANGE_REF_ERROR :
              new RangeRef(psheet1, null, left, top, right, bottom, absleft, abstop, absright, absbottom, abssheet);
            ranges.add(rng);
/*            if (orgref != null) {
              final Reference precedent = pabacus.addRef(new SimpleRef(psheet, rng, orgrow, orgcol));
              orgref.addPrecedent(precedent);
            } 
*/            token1.setValue(rng);
            operand.addOperand(token1);
          }
          
          if (var2) {
            //lookup NameRange
            final Range rng = book.lookupNameRange(cell2);
            if (rng != null) {
              ranges.add(rng);
              operand.addOperand(new Token(rng, TokenType.OPERAND, TokenSubtype.RANGE));
            } else {
              operand.addOperand(new Token(cell2, TokenType.OPERAND, TokenSubtype.VAR));
              if (!((BookImpl)book).addVariable(cell2, orgref)) {
                throw new XelException("Illegal variable name: "+cell2);
              }
            }
          } else { 
            final Token token2 = 
              new Token(cell2, TokenType.OPERAND, TokenSubtype.CELL);
            //TODO: matain ref DAG graph
            //TODO: How do we handle variable range2d?
//            final SheetImpl psheet = sheet2 != null ? sheet2 : sheet;
//            final Abacus pabacus = psheet.getBook().getAbacus();
            final int left = rb[0];
            final int top = rb[1];
            final int right = left;
            final int bottom = top;
            final boolean absleft = rb[2] != 0;
            final boolean abstop = rb[3] != 0;
            final boolean absright = absleft;
            final boolean absbottom = abstop;
            final Range rng = 
              new RangeRef(psheet2, null, left, top, right, bottom, absleft, abstop, absright, absbottom, abssheet);
            ranges.add(rng);
/*            if (orgref != null) {
              final Reference precedent = pabacus.addRef(new SimpleRef(psheet, rng, orgrow, orgcol));
              orgref.addPrecedent(precedent);
            } 
*/            token2.setValue(rng);
            operand.addOperand(token2);
          }
        } else { //a const cell or a const range
          if (sheetnm1 == null || (sheetnm2 == null || sheetnm1.equals(sheetnm2))) { //single sheet
            if (cell1.equals(cell2)) { //a cell reference
              if (lt[0] == -1 || lt[1] == -1) { //single row || single column
//                final SheetImpl psheet = sheet1 != null ? sheet1 : sheet;
//                final Abacus pabacus = psheet.getBook().getAbacus();
                final int left = lt[0];
                final int top = lt[1];
                final int right = rb[0];
                final int bottom = rb[1];
                final boolean absleft = lt[2] != 0;
                final boolean abstop = lt[3] != 0;
                final boolean absright = rb[2] != 0;
                final boolean absbottom = rb[3] != 0;
                final Range rng = psheet1 == null ? RangeRefError.RANGE_REF_ERROR :
                  new RangeRef(psheet1, null, left, top, right, bottom, absleft, abstop, absright, absbottom, abssheet);
                ranges.add(rng);
/*                if (orgref != null) {
                  final Reference precedent = pabacus.addRef(new SimpleRef(psheet, rng, orgrow, orgcol));
                  orgref.addPrecedent(precedent);
                }
*/                operand.setValue(rng);
              } else { //degrad to single cell
                operand.setSubtype(TokenSubtype.CELL);
                //TODO: maintain DAG reference
//                final SheetImpl psheet = sheet1 != null ? sheet1 : sheet;
//                final Abacus pabacus = psheet.getBook().getAbacus();
                final int left = lt[0];
                final int top = lt[1];
                final int right = left;
                final int bottom = top;
                final boolean absleft = lt[2] != 0;
                final boolean abstop = lt[3] != 0;
                final boolean absright = absleft;
                final boolean absbottom = abstop;
                final Range rng = psheet1 == null ? RangeRefError.RANGE_REF_ERROR :
                  new RangeRef(psheet1, null, left, top, right, bottom, absleft, abstop, absright, absbottom, abssheet);
                ranges.add(rng);
/*                if (orgref != null) {
                  final Reference precedent = pabacus.addRef(new SimpleRef(psheet, rng, orgrow, orgcol));
                  orgref.addPrecedent(precedent);
                } 
*/                operand.setValue(rng);
              }
            } else { //a range reference
              //TODO: maintain DAG reference
//              final SheetImpl psheet = sheet1 != null ? sheet1 : sheet;
//              final Abacus pabacus = psheet.getBook().getAbacus();
              final int left = lt[0];
              final int top = lt[1];
              final int right = rb[0];
              final int bottom = rb[1];
              final boolean absleft = lt[2] != 0;
              final boolean abstop = lt[3] != 0;
              final boolean absright = rb[2] != 0;
              final boolean absbottom = rb[3] != 0;
              final Range rng = psheet1 == null ? RangeRefError.RANGE_REF_ERROR :
                new RangeRef(psheet1, null, left, top, right, bottom, absleft, abstop, absright, absbottom, abssheet);
              ranges.add(rng);
/*              if (orgref != null) {
                final Reference precedent = pabacus.addRef(new SimpleRef(psheet, rng, orgrow, orgcol));
                orgref.addPrecedent((Reference)precedent);
              }
*/              operand.setValue(rng);
            }
          } else { //range 3d
            //TODO: maintain DAG reference
            //TODO: for each sheet between two sheet name
            final int left = lt[0];
            final int top = lt[1];
            final int right = rb[0];
            final int bottom = rb[1];
            final boolean absleft = lt[2] != 0;
            final boolean abstop = lt[3] != 0;
            final boolean absright = rb[2] != 0;
            final boolean absbottom = rb[3] != 0;
            final Range rng = (psheet1 == null || psheet2 == null) ? RangeRefError.RANGE_REF_ERROR :
              new RangeRef(psheet1, psheet2, left, top, right, bottom, absleft, abstop, absright, absbottom, abssheet);
            ranges.add(rng);
/*            if (orgref != null) {
              final Book pbook = sheet1.getBook();
              final int from = pbook.indexOfSheet(sheet1);
              final int to = pbook.indexOfSheet(sheet2);
              final Abacus pabacus = pbook.getAbacus();
              final List sheets = book.getSheets();
              for (int j=from; j <= to; ++j) {
                final SheetImpl psheet = (SheetImpl) sheets.get(j);
                final Reference precedent = pabacus.addRef(new SimpleRef(psheet, rng, orgrow, orgcol));
                orgref.addPrecedent((Reference)precedent);
              }
            }
*/            operand.setValue(rng);
          }
        }
      } else if (var1) { //single variable
        //lookup NameRange
        final Range rng = book.lookupNameRange(cell1);
        if (rng != null) {
          ranges.add(rng);
          operand.setValue(rng);
        } else {
          operand.setSubtype(TokenSubtype.VAR);

View Full Code Here

      }
    }
  }
  
  private void processSheet(String action, Map data, Worksheet sheet, Spreadsheet spreadsheet) {
    Book book = spreadsheet.getBook();
    if ("add".equals(action)) {
      String prefix = Labels.getLabel(Action.SHEET.getLabelKey());
      if (Strings.isEmpty(prefix))
        prefix = "Sheet";
      int numSheet = book.getNumberOfSheets();
      Ranges.range(sheet).createSheet(prefix + " " + (numSheet + 1));
    } else if ("delete".equals(action)) {
      int numSheet = book.getNumberOfSheets();
      if (numSheet > 1) {
        Worksheet sel = null;
        int index = book.getSheetIndex(sheet);
        if (index == numSheet - 1) {//delete last sheet, move select sheet left
          sel = book.getWorksheetAt(index - 1);
        } else { //move sheet right
          sel = book.getWorksheetAt(index + 1);
        }
        Ranges.range(sheet).deleteSheet();
        spreadsheet.setSelectedSheet(sel.getSheetName());
      }
    } else if ("rename".equals(action)) {
      String name = (String) data.get("name");
      Ranges.range(sheet).setSheetName(name);
    } else if ("protect".equals(action)) {
      boolean protect = sheet.getProtect();
      Ranges.range(sheet).protectSheet(protect ? null : "");// toggle sheet protect
    } else if ("moveLeft".equals(action)) {
      int index = book.getSheetIndex(sheet);
      if (index > 0) {
        Ranges.range(sheet).setSheetOrder(index - 1);
      }
    } else if ("moveRight".equals(action)) {
      int index = book.getSheetIndex(sheet);
      if (index < book.getNumberOfSheets() - 1) {
        Ranges.range(sheet).setSheetOrder(index + 1);
      }
    }
  }

View Full Code Here

    Worksheet sheet = ((Spreadsheet)comp).getSelectedSheet();
    if(!Utils.getSheetUuid(sheet).equals(sheetId))
      return;
    
    //TODO request shall send back maxcol/maxrow (do it in client side)
    final Book book = (Book) sheet.getWorkbook();
    final int maxcol = book.getSpreadsheetVersion().getLastColumnIndex();
    final int maxrow = book.getSpreadsheetVersion().getLastRowIndex();
    int action = (Integer) data.get("action");
    int left = (Integer) data.get("left");
    int top = (Integer) data.get("top");
    int right = action == CellSelectionEvent.SELECT_ROW ? maxcol : (Integer) data.get("right");
    int bottom = action == CellSelectionEvent.SELECT_COLUMN ? maxrow : (Integer) data.get("bottom");

View Full Code Here

    
    //freeze
    int rowfreeze = AuRequests.getInt(data, "frow", -1);
    int colfreeze = AuRequests.getInt(data, "fcol", -1);
    
    Book book = spreadsheet.getBook();
    int len = book.getNumberOfSheets();
    for (int i = 0; i < len; i++) {
      Worksheet sheet = book.getWorksheetAt(i);
      if (sheetId.equals(((SheetCtrl)sheet).getUuid())) {
        spreadsheet.setSelectedSheetDirectly(sheet.getSheetName(), cacheInClient, row, col, 
            left, top, right, bottom,
            highlightLeft, highlightTop, highlightRight, highlightBottom,
            rowfreeze, colfreeze);

View Full Code Here

    _sheet = sheet;
    initCellRef(row, col, sheet, lastSheet);
  }
  
  private void initCellRef(int row, int col, Worksheet sheet, Worksheet lastSheet) {
    final Book book  = (Book) sheet.getWorkbook();
    final int s1 = book.getSheetIndex(sheet);
    final int s2 = book.getSheetIndex(lastSheet);
    final int sb = Math.min(s1,s2);
    final int se = Math.max(s1,s2);
    for (int s = sb; s <= se; ++s) {
      final Worksheet sht = book.getWorksheetAt(s);
      final RefSheet refSht = BookHelper.getOrCreateRefBook(book).getOrCreateRefSheet(sht.getSheetName());
      addRef(new CellRefImpl(row, col, refSht));
    }
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.zkoss.zss.model.Book

org.zkoss.poi.ss.formula.DefaultDependencyTracker

org.zkoss.zss.app.cell.CellHelper

org.zkoss.zss.app.file.ExportToHtmlWindowCtrl

org.zkoss.zss.app.file.ExportToPdfWindowCtrl

org.zkoss.zss.app.file.FileHelper

org.zkoss.zss.app.link.InsertHyperlinkWindowCtrl

org.zkoss.zss.app.RangeHelper

org.zkoss.zss.app.sheet.SheetHelper

org.zkoss.zss.app.test.InvalidateSpreadsheetComposer

org.zkoss.zss.app.zul.ctrl.SSWorkbookCtrl

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.