Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Worksheet

1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
        final RefBook refBook = refSheet.getOwnerBook();
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final int bRow = ref.getBottomRow();
        final int rCol = ref.getRightCol();
        final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
        final ChangeInfo info = BookHelper.moveRange(sheet, tRow, lCol, bRow, rCol, nRow, nCol);
        notifyMergeChange(refBook, info, ref, SSDataEvent.ON_CONTENTS_CHANGE, SSDataEvent.MOVE_NO);
      }
    }
  }
View Full Code Here
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
          final RefSheet refSheet = ref.getOwnerSheet();
          final int tRow = ref.getTopRow();
          final int lCol = ref.getLeftCol();
          final int bRow = ref.getBottomRow();
          final int rCol = ref.getRightCol();
          final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
          final Set<Ref> refs = BookHelper.setCellStyle(sheet, tRow, lCol, bRow, rCol, style);
          all.addAll(refs);
        }
        if (!all.isEmpty()) {
          final Book book = (Book) _sheet.getWorkbook();
View Full Code Here
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
        final RefSheet refSheet = ref.getOwnerSheet();
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final int bRow = ref.getBottomRow();
        final int rCol = ref.getRightCol();
        final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
        clearContents(sheet, tRow, lCol, bRow, rCol);
      }
    }
  }
View Full Code Here
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
      if (_refs != null && !_refs.isEmpty()) {
        final Set<Ref> all = new HashSet<Ref>();
        for (Ref ref : _refs) {
          if (ref.isWholeRow()) {
            final RefSheet refSheet = ref.getOwnerSheet();
            final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
            final int tRow = ref.getTopRow();
            final int bRow = ref.getBottomRow();
            final Set<Ref> refs = BookHelper.setRowsHidden(sheet, tRow, bRow, hidden);
            all.addAll(refs);
          } else if (ref.isWholeColumn()) {
            final RefSheet refSheet = ref.getOwnerSheet();
            final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
            final int lCol = ref.getLeftCol();
            final int rCol = ref.getRightCol();
            final Set<Ref> refs = BookHelper.setColumnsHidden(sheet, lCol, rCol, hidden);
            all.addAll(refs);
          }
View Full Code Here
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
 
  @Override
  public void setDisplayGridlines(boolean show) {
    synchronized (_sheet) {
      final Ref ref = getRefs().iterator().next();
      final Worksheet sheet = BookHelper.getSheet(_sheet, ref.getOwnerSheet());
      final Set<Ref> all = new HashSet<Ref>();
      final boolean old = sheet.isDisplayGridlines();
      if (old != show) {
        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
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
1470
1471
1472
 
  @Override
  public void protectSheet(String password) {
    synchronized (_sheet) {
      final Ref ref = getRefs().iterator().next();
      final Worksheet sheet = BookHelper.getSheet(_sheet, ref.getOwnerSheet());
      final Set<Ref> all = new HashSet<Ref>();
      final boolean oldProtected = sheet.getProtect();
      if (oldProtected && password == null) {
        sheet.protectSheet(null);
        all.add(ref);
      } 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
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
  }
 
  @Override
  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
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
  }
 
  @Override
  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
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
 
  @Override
  public Range getDependents() {
    synchronized (_sheet) {
      final Ref ref = getRefs().iterator().next();
      final Worksheet sheet = BookHelper.getSheet(_sheet, ref.getOwnerSheet());
      final int row = ref.getTopRow();
      final int col = ref.getLeftCol();
      final RefSheet refSheet = ref.getOwnerSheet();
      Set<Ref> refs = ((RefSheetImpl)refSheet).getAllDependents(row, col);
      return refs != null && !refs.isEmpty() ?
View Full Code Here
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
 
  @Override
  public Range getDirectDependents() {
    synchronized (_sheet) {
      final Ref ref = getRefs().iterator().next();
      final Worksheet sheet = BookHelper.getSheet(_sheet, ref.getOwnerSheet());
      final int row = ref.getTopRow();
      final int col = ref.getLeftCol();
      final RefSheet refSheet = ref.getOwnerSheet();
      Set<Ref> refs = ((RefSheetImpl)refSheet).getDirectDependents(row, col);
      return refs != null && !refs.isEmpty() ?
View Full Code Here
TOP

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

  • org.zkoss.zss.app.CustomSortWindowCtrl$SortAlgorithm
  • org.zkoss.zss.app.FormatProtectionHelper
  • org.zkoss.zss.app.MainWindowCtrl
  • org.zkoss.zss.app.MultiSpreadsheetWindow
  • org.zkoss.zss.app.PasteSpecialWindowCtrl
  • org.zkoss.zss.app.sort.CustomSortWindowCtrl$SortAlgorithm
  • org.zkoss.zss.app.zul.ctrl.SSRectCellStyle
  • org.zkoss.zss.app.zul.ctrl.SSWorkbookCtrl
  • org.zkoss.zss.app.zul.FormulaEditor
  • org.zkoss.zss.demo.MainWindow
    • 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.