Examples of RefSheet


Examples of org.zkoss.zss.engine.RefSheet

  }
 
 
  @Override
  public RefSheet getOrCreateRefSheet(String sheetname) {
    RefSheet sheet = _sheets.get(sheetname);
    if (sheet == null) {
      sheet = new RefSheetImpl(this, sheetname);
      _sheets.put(sheetname, sheet);
    }
    return sheet;
View Full Code Here

Examples of org.zkoss.zss.engine.RefSheet

    return _sheets.remove(sheetname);
  }

  @Override
  public void setSheetName(String oldsheetname, String newsheetname) {
    final RefSheet sheet = _sheets.remove(oldsheetname);
    if (sheet != null) {
      ((RefSheetImpl)sheet).setSheetName(newsheetname);
      _sheets.put(newsheetname, sheet);
    }
  }
View Full Code Here

Examples of org.zkoss.zss.engine.RefSheet

      for(Ref ref : _refs) {
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final int bRow = ref.getBottomRow();
        final int rCol = ref.getRightCol();
        final RefSheet refSheet = ref.getOwnerSheet();
       
        for(int row = tRow; row <= bRow; ++row) {
          for (int col = lCol; col <= rCol; ++col) {
            Set<Ref>[] refs = setCellValue(row, col, refSheet, value);
            if (refs != null) {
View Full Code Here

Examples of org.zkoss.zss.engine.RefSheet

    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

Examples of org.zkoss.zss.engine.RefSheet

    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 AreaRefImpl(tRow, lCol, bRow, rCol, refSht));
    }
  }
View Full Code Here

Examples of org.zkoss.zss.engine.RefSheet

    synchronized(_sheet) {
      Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final RefSheet refSheet = ref.getOwnerSheet();
        final Cell cell = getCell(tRow, lCol, refSheet);
        if (cell != null)
          return BookHelper.getHyperlink(cell);
      }
      return null;
View Full Code Here

Examples of org.zkoss.zss.engine.RefSheet

    synchronized(_sheet) {
      Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final RefSheet refSheet = ref.getOwnerSheet();
        final Cell cell = getCell(tRow, lCol, refSheet);
        if (cell != null)
          return BookHelper.getText(cell);
      }
      return null;
View Full Code Here

Examples of org.zkoss.zss.engine.RefSheet

    synchronized(_sheet) {
      Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final RefSheet refSheet = ref.getOwnerSheet();
        final Cell cell = getCell(tRow, lCol, refSheet);
        if (cell != null)
          return BookHelper.getFormatText(cell);
      }
      return null;
View Full Code Here

Examples of org.zkoss.zss.engine.RefSheet

    synchronized(_sheet) {
      Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final RefSheet refSheet = ref.getOwnerSheet();
        final Cell cell = getCell(tRow, lCol, refSheet);
        if (cell != null) {
          return BookHelper.getRichEditText(cell);
        }
      }
View Full Code Here

Examples of org.zkoss.zss.engine.RefSheet

    synchronized(_sheet) {
      Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final RefSheet refSheet = ref.getOwnerSheet();
        final Cell cell = getCell(tRow, lCol, refSheet);
        if (cell != null) {
          return BookHelper.getEditText(cell);
        }
      }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.