Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Book

1345
1346
1347
1348
1349
1350
1351
1352
1353
          last.addAll(refs[0]);
          all.addAll(refs[1]);
        }
      }
    }
    final Book book = (Book) sheet.getWorkbook();
    all.add(new AreaRefImpl(tRow, lCol, bRow, rCol, BookHelper.getRefSheet(book, sheet)));
    BookHelper.reevaluateAndNotify(book, last, all);
  }
View Full Code Here
1422
1423
1424
1425
1426
1427
1428
1429
1430
1431
1432
            final Set<Ref> refs = BookHelper.setColumnsHidden(sheet, lCol, rCol, hidden);
            all.addAll(refs);
          }
        }
        if (!all.isEmpty()) {
          final Book book = (Book) _sheet.getWorkbook();
          BookHelper.notifySizeChanges(book, all);
        }
      }
    }
  }
View Full Code Here
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
        sheet.setDisplayGridlines(show);
        //sheet is important, row, column is not in this event
        all.add(ref);
      }
      if (!all.isEmpty()) {
        final Book book = (Book) sheet.getWorkbook();
        BookHelper.notifyGridlines(book, all, show);
      }
    }
  }
View Full Code Here
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
      } else if (oldProtected == false && password != null) {
        sheet.protectSheet(password);
        all.add(ref);
      }
      if (!all.isEmpty()) {
        final Book book = (Book) sheet.getWorkbook();
        BookHelper.notifyProtectSheet(book, all, password);
      }
    }
  }
View Full Code Here
1512
1513
1514
1515
1516
1517
1518
1519
  public Range getColumns() {
    final Ref ref = getRefs().iterator().next();
    final Worksheet sheet = BookHelper.getSheet(_sheet, ref.getOwnerSheet());
    final int col1 = ref.getLeftCol();
    final int col2 = ref.getRightCol();
    final Book book = (Book) sheet.getWorkbook();
    return new RangeImpl(0, col1, book.getSpreadsheetVersion().getLastRowIndex(), col2, sheet, sheet);
  }
View Full Code Here
1522
1523
1524
1525
1526
1527
1528
1529
  public Range getRows() {
    final Ref ref = getRefs().iterator().next();
    final Worksheet sheet = BookHelper.getSheet(_sheet, ref.getOwnerSheet());
    final int row1 = ref.getTopRow();
    final int row2 = ref.getBottomRow();
    final Book book = (Book) sheet.getWorkbook();
    return new RangeImpl(row1, 0, row2, book.getSpreadsheetVersion().getLastColumnIndex(), sheet, sheet);
  }
View Full Code Here
1627
1628
1629
1630
1631
1632
1633
1634
1635
1636
1637
  }

  private Object getValue0(Cell cell) {
    int cellType = cell.getCellType();
    if (cellType == Cell.CELL_TYPE_FORMULA) {
      final Book book = (Book)cell.getSheet().getWorkbook();
      final CellValue cv = BookHelper.evaluate(book, cell);
      return BookHelper.getValueByCellValue(cv);
    } else {
      final Object obj = BookHelper.getCellValue(cell);
      return obj instanceof RichTextString ?
View Full Code Here
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
2358
2359
2360
2361
  @Override
  public void createSheet(String name) {
    synchronized (_sheet.getBook()) {
      Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final Book book = _sheet.getBook();
        if (book != null) {
          if (Strings.isBlank(name)) {
            book.createSheet();
          } else {
            book.createSheet(name);
          }
          BookHelper.notifyCreateSheet(ref, name);
        }
      }
    }
View Full Code Here
2364
2365
2366
2367
2368
2369
2370
2371
2372
2373
2374
2375
2376
2377
2378
2379
  @Override
  public void setSheetName(String name) {
    synchronized (_sheet.getBook()) {
      Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final Book book = _sheet.getBook();
        if (book != null) {
          if (!Strings.isBlank(name)) {
            final int pos= book.getSheetIndex(_sheet);
            if (pos >= 0) {
              book.setSheetName(pos, name);
              BookHelper.notifyChangeSheetName(ref, name);
            }
          }
        }
      }
View Full Code Here
2383
2384
2385
2386
2387
2388
2389
2390
2391
2392
2393
2394
2395
2396
2397
  @Override
  public void setSheetOrder(int pos) {
    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 String name = _sheet.getSheetName();
          if (!Strings.isBlank(name)) {
            book.setSheetOrder(name, pos);
            BookHelper.notifyChangeSheetOrder(ref, name);
          }
        }
      }
    }
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.