Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Worksheet

2270
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280
          orng.getTopRow(), orng.getRightCol(), orng.getBottomRow());
    }
    private void onSizeChange(SSDataEvent event) {
      //TODO shall pass the range over to the client side and let client side do it; rather than iterate each column and send multiple command
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      if (rng.isWholeColumn()) {
        final int left = rng.getLeftCol();
        final int right = rng.getRightCol();
View Full Code Here
2293
2294
2295
2296
2297
2298
2299
2300
2301
2302
        syncFriendFocusesPosition(rect.getLeft(), top, rect.getRight(), rect.getBottom());
      }
    }
    private void onBtnChange(SSDataEvent event) {
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      updateAutoFilter(sheet.getAutoFilter());
    }
View Full Code Here
2300
2301
2302
2303
2304
2305
2306
2307
2308
2309
        return;
      updateAutoFilter(sheet.getAutoFilter());
    }
    private void onDisplayGridlines(SSDataEvent event) {
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      setDisplayGridlines(event.isShow());
    }
View Full Code Here
2307
2308
2309
2310
2311
2312
2313
2314
2315
2316
        return;
      setDisplayGridlines(event.isShow());
    }
    private void onProtectSheet(SSDataEvent event) {
      final Ref rng = event.getRef();
      final Worksheet sheet = getSheet(rng);
      if (!getSelectedSheet().equals(sheet))
        return;
      setProtectSheet(event.getProtect());
    }
View Full Code Here
443
444
445
446
447
448
449
450
451
452
453
454
455
 
  /**
   * @param selection
   */
  public void doHideRow(Rect selection) {
    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        Ranges
        .range(sheet, selection.getTop(), selection.getLeft(), selection.getBottom(), selection.getRight())
        .getRows()
        .setHidden(true); 
      } else {
View Full Code Here
459
460
461
462
463
464
465
466
467
468
469
470
471
  }
  /**
   * @param selection
   */
  public void doUnhideRow(Rect selection) {
    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        Ranges
        .range(sheet, selection.getTop(), selection.getLeft(), selection.getBottom(), selection.getRight())
        .getRows()
        .setHidden(false); 
      } else {
View Full Code Here
475
476
477
478
479
480
481
482
483
484
485
486
487
  }
  /**
   * @param selection
   */
  public void doUnhideColumn(Rect selection) {
    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        Ranges
        .range(sheet, selection.getTop(), selection.getLeft(), selection.getBottom(), selection.getRight())
        .getColumns()
        .setHidden(false); 
      } else {
View Full Code Here
491
492
493
494
495
496
497
498
499
500
501
502
503
  }
  /**
   * @param selection
   */
  public void doHideColumn(Rect selection) {
    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        Ranges
        .range(sheet, selection.getTop(), selection.getLeft(), selection.getBottom(), selection.getRight())
        .getColumns()
        .setHidden(true); 
      } else {
View Full Code Here
565
566
567
568
569
570
571
572
573
574
575
576
577
  public void doInsertPicture(UploadEvent evt) {
    if (_insertPictureSelection == null) {
      return;
    }
   
    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null) {
      if (!sheet.getProtect()) {
        final Media media = evt.getMedia();
        if (media instanceof AImage) {
          AImage image = (AImage)media;
          Ranges
          .range(_spreadsheet.getSelectedSheet())
View Full Code Here
608
609
610
611
612
613
614
615
616
617
618
619
620
  public void doBeforeInsertPicture(Rect selection) {
    _insertPictureSelection = selection;
  }
 
  protected void setVerticalAlign(final short alignment, Rect selection) {
    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        Utils.visitCells(sheet, selection, new CellVisitor(){
          @Override
          public void handle(CellVisitorContext context) {
            final short srcAlign = context.getVerticalAlignment();
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.