Package org.zkoss.zss.engine

Examples of org.zkoss.zss.engine.Ref

1451
1452
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
  }
 
  @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);
View Full Code Here
1489
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
1506
1507
1508
    return new RangeImpl(ref, _sheet);
  }

  @Override
  public long getCount() {
    final Ref ref = getRefs().iterator().next();
    final int col1 = ref.getLeftCol();
    final int col2 = ref.getRightCol();
    final int row1 = ref.getTopRow();
    final int row2 = ref.getBottomRow();
    if (ref.isWholeColumn()) {
      return (long) (col2 - col1 + 1);
    } else if (ref.isWholeRow()) {
      return (long) (row2 - row1 + 1);
    } else if (ref.isWholeSheet()) {
      return 1L;
    }
    final int ccount = col2 - col1 + 1;
    final long rcount = (long) (col2 - col1 + 1);
    return rcount * ccount;
 
View Full Code Here
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
    return rcount * ccount;
  }
 
  @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
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
    return new RangeImpl(0, col1, book.getSpreadsheetVersion().getLastRowIndex(), col2, sheet, sheet);
  }
 
  @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
1529
1530
1531
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
  }
 
  @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() ?
          new RangeImpl(refs, sheet) : Ranges.EMPTY_RANGE;
    }
  }
View Full Code Here
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
  }
 
  @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() ?
          new RangeImpl(refs, sheet) : Ranges.EMPTY_RANGE;
    }
  }
View Full Code Here
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
  }
 
  @Override
  public Range getPrecedents() {
    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 = refSheet.getAllPrecedents(row, col);
      return refs != null && !refs.isEmpty() ?
          new RangeImpl(refs, sheet) : Ranges.EMPTY_RANGE;
    }
   
View Full Code Here
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583
1584
1585
1586
  }
 
  @Override
  public Range getDirectPrecedents() {
    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 = refSheet.getDirectPrecedents(row, col);
      return refs != null && !refs.isEmpty() ?
          new RangeImpl(refs, sheet) : Ranges.EMPTY_RANGE;
    }
  }
View Full Code Here
1585
1586
1587
1588
1589
1590
1591
1592
    }
  }
 
  @Override
  public int getRow() {
    final Ref ref = getRefs().iterator().next();
    return ref.getTopRow();
  }
View Full Code Here
1591
1592
1593
1594
1595
1596
1597
1598
    return ref.getTopRow();
  }
 
  @Override
  public int getColumn() {
    final Ref ref = getRefs().iterator().next();
    return ref.getLeftCol();
  }
View Full Code Here
TOP

Related Classes of org.zkoss.zss.engine.Ref

  • org.zkoss.zss.engine.impl.AbstractRefImpl
  • org.zkoss.zss.engine.impl.DependencyTrackerHelper
  • org.zkoss.zss.engine.impl.RefBookImpl
  • org.zkoss.zss.engine.impl.RefSheetImpl
  • org.zkoss.zss.engine.impl.RefSheetTest
  • org.zkoss.zss.model.impl.Book01XlsFormulaHitTest
  • org.zkoss.zss.model.impl.BookHelper
  • org.zkoss.zss.model.impl.RangeImpl
  • org.zkoss.zss.ui.Spreadsheet$InnerDataListener
    • 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.