Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Book

2400
2401
2402
2403
2404
2405
2406
2407
2408
2409
2410
2411
2412
2413
2414
2415
2416
2417
2418
2419
2420
2421
  @Override
  public void deleteSheet() {
    synchronized (_sheet.getBook()) {
      Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final Book book = _sheet.getBook();
        if (book != null) {
          final int index = book.getSheetIndex(_sheet);
          if (index != -1) {
            final int sheetCount = book.getNumberOfSheets();
            if (sheetCount == 1) {
              Messagebox.show("A workbook must contain at least one visible worksheet");
            }
            final String delSheetName = _sheet.getSheetName(); //must getName before remove
            book.removeSheetAt(index);
            final int newIndex =  index < (sheetCount - 1) ? index : (index - 1);
            final String newSheetName = book.getSheetName(newIndex);
            BookHelper.notifyDeleteSheet(ref, new Object[] {delSheetName, newSheetName});
          }
        }
      }
    }
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
  private void myAddDependency(CellRefImpl srcRef, String refBookname,
    String refSheetname, String refLastSheetName, int tRow, int lCol, int bRow, int rCol) {
    if ("#REF".equals(refSheetname) || "#REF".equals(refLastSheetName)) { //handle refer to deleted sheet
      return;
    }
    final Book targetBook = BookHelper.getBook(_book, refBookname);
    if (targetBook == null) {
      throw new UiException("cannot find the named book, have you add it in the Books:"+ refBookname);
    }
    final RefBook targetRefBook = BookHelper.getOrCreateRefBook(targetBook);
   
    final int s1 = targetBook.getSheetIndex(refSheetname);
    final int s2 = targetBook.getSheetIndex(refLastSheetName);
    final int sheetIndex1 = Math.min(s1, s2);
    final int sheetIndex2 = Math.max(s1, s2);
    for(int j = sheetIndex1; j <= sheetIndex2; ++j) {
      final String sheetname = targetBook.getSheetName(j);
      final RefSheet targetRefSheet = targetRefBook.getOrCreateRefSheet(sheetname);
      DependencyTrackerHelper.addDependency(srcRef, targetRefSheet, tRow, lCol, bRow, rCol);
    }
  }
View Full Code Here
416
417
418
419
420
421
422
423
424
425
426
        Importer importer = _importer;
        if (importer == null) {
          importer = new ExcelImporter();
        }

        Book book = null;
        if (importer instanceof ExcelImporter) {
          URL url = null;
         
          if (_src.startsWith("/")) {// try to load by application
            // context.
View Full Code Here
578
579
580
581
582
583
584
585
586
    //setRowfreeze(-1);
    //setColumnfreeze(-1);
    //setBook(null);
    _importer = new ExcelImporter();
    _src=src;
    final Book book = ((ExcelImporter)_importer).imports(is, src);
    initBook(book);
    invalidate();
  }
View Full Code Here
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
  /**
   * Gets the selected sheet, the default selected sheet is first sheet.
   * @return #{@link Worksheet}
   */
  public Worksheet getSelectedSheet() {
    final Book book = getBook();
    if (book == null) {
      return null;
    }
    if (_selectedSheet == null) {
      if (_selectedSheetId == null) {
        if (book.getNumberOfSheets() == 0)
          throw new UiException("sheet size of given book is zero");
        _selectedSheet = (Worksheet) book.getSheetAt(0);
        _selectedSheetId = Utils.getSheetUuid(_selectedSheet);
      } else {
        _selectedSheet = Utils.getSheetByUuid(_book, _selectedSheetId);
        if (_selectedSheet == null) {
          throw new UiException("can not find sheet by id : "  + _selectedSheetId);
View Full Code Here
610
611
612
613
614
615
616
617
    }
    return _selectedSheet;
  }

  public Worksheet getSheet(int index){
    final Book book = getBook();
    return book != null ? (Worksheet)book.getSheetAt(index) : null;
  }
View Full Code Here
615
616
617
618
619
620
621
622
    final Book book = getBook();
    return book != null ? (Worksheet)book.getSheetAt(index) : null;
  }
 
  public int indexOfSheet(Worksheet sheet){
    final Book book = getBook();
    return book != null ? book.getSheetIndex(sheet) : -1;
  }
View Full Code Here
658
659
660
661
662
663
664
665
666
667
668
   * it will change the spreadsheet src name as src
   * and book name as src => will not reload the book
   * @param src
   */
  public void setSrcName(String src) {
    /**
     * TODO model integration
     */
    /*
    BookImpl book = (BookImpl) this.getBook();
    if (book != null)
View Full Code Here
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
    doSheetSelected(_selectedSheet);
    invalidate();
  }
 
  private void setSelectedSheetImpl(String name) {
    final Book book = getBook();
    if (book == null) {
      return;
    }
   
    //Note. check whether if the sheet has remove or not
    if (_selectedSheet != null && book.getSheetIndex(_selectedSheet) == -1) {
      doSheetClean(_selectedSheet);
      _selectedSheet = null;
      _selectedSheetId = null;
      _selectedSheetName = null;
    }

    if (_selectedSheet == null || !_selectedSheet.getSheetName().equals(name)) {
      Worksheet sheet = book.getWorksheet(name);
      if (sheet == null) {
        throw new UiException("No such sheet : " + name);
      }

      if (_selectedSheet != null)
View Full Code Here
2122
2123
2124
2125
2126
2127
2128
2129
2130
2131
2132
2133
2134
2135
2136
2137
2138
2139
   
    return new ChangeInfo(last, all, changeMerges);
  }
 
  private static ChangeInfo insertXSSFColumns(Worksheet sheet, int startCol, int num, int copyOrigin) {
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.insertColumns(startCol, num);
    final List<CellRangeAddress[]> shiftedRanges = ((XSSFSheetImpl)sheet).shiftColumnsOnly(startCol, -1, num, true, false, true, false, copyOrigin);
    final List<MergeChange> changeMerges = prepareChangeMerges(refSheet, shiftedRanges);
    final Set<Ref> last = refs[0];
    final Set<Ref> all = refs[1];
    final int maxrow = book.getSpreadsheetVersion().getLastRowIndex();
    final int maxcol = book.getSpreadsheetVersion().getLastColumnIndex();
    shiftFormulas(all, sheet, 0, maxrow, 0, startCol, maxcol, num);
   
    return new ChangeInfo(last, all, changeMerges);
  }
View Full Code Here
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
    • Copyright © 2018 www.massapicom. 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.