Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Range

2610
2611
2612
2613
2614
2615
2616
2617
2618
2619
2620
      }
      // update helper size first before sheet.setColumnWidth, or it will fire a SSDataEvent
      HeaderPositionHelper helper = Spreadsheet.this.getColumnPositionHelper(sheet);
      helper.setInfoValues(column, newsize, id, hidden);

      final Range rng = Ranges.range(sheet, -1, column).getColumns();
      rng.setHidden(hidden);
      if (!hidden) {
        rng.setColumnWidth(Utils.pxToFileChar256(newsize, ((Book)sheet.getWorkbook()).getDefaultCharWidth()));
      }
    }
View Full Code Here
2625
2626
2627
2628
2629
2630
2631
2632
2633
2634
2635
2636
2637
2638
        sheet = getSelectedSheet();
      } else {
        sheet = Utils.getSheetByUuid(_book, sheetId);
      }
     
      final Range rng = Ranges.range(sheet, rownum, -1).getRows();
      rng.setHidden(hidden);
      if (!hidden) {
        rng.setRowHeight(Utils.pxToPoint(newsize));
      }
      //row.setHeight((short)Utils.pxToTwip(newsize));
      HeaderPositionHelper helper = Spreadsheet.this.getRowPositionHelper(sheet);
      helper.setInfoValues(rownum, newsize, id, hidden);
    }
View Full Code Here
480
481
482
483
484
485
486
487
488
489
490
    }
  }
  private Focus _focus;
  private void deleteFocus() {
    if (_selectedSheet != null && _focus != null) {
      final Range rng = Ranges.range(_selectedSheet);
      rng.notifyDeleteFriendFocus(_focus);
      ((BookCtrl)_book).removeFocus(_focus);
      _focus = null;
    }
  }
View Full Code Here
492
493
494
495
496
497
498
499
500
    if (_selectedSheet != null) {
      if (_focus == null) {
        _focus = newFocus();
        ((BookCtrl)_book).addFocus(_focus);
      }
      final Range rng = Ranges.range(_selectedSheet);
      rng.notifyMoveFriendFocus(_focus);
    }
  }
View Full Code Here
4685
4686
4687
4688
4689
4690
4691
4692
4693
4694
4695
4696
      return true;
    }
    if (_inCallback) { //skip validation check
      return true;
    }
    final Range rng = Ranges.range(sheet, row, col);
    final DataValidation dv = rng.validate(txt);
    if (dv != null) {
      if (dv.getShowErrorBox()) {
        String errTitle = dv.getErrorBoxTitle();
        String errText = dv.getErrorBoxText();
        if (errTitle == null) {
View Full Code Here
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
        clearClipboard();
        return;
      }
     
      final Rect srcRect = _clipboard.sourceRect;
      Range rng = Utils.pasteSpecial(srcSheet,
          srcRect,
          _spreadsheet.getSelectedSheet(),
          selection.getTop(),
          selection.getLeft(),
          selection.getBottom(),
          selection.getRight(),
          pasteType,
          pasteOperation,
          skipBlank, transpose);
     
      if (_clipboard.type == Clipboard.Type.CUT) {
        Ranges
        .range(srcSheet, srcRect.getTop(), srcRect.getLeft(), srcRect.getBottom(), srcRect.getRight())
        .clearContents();
       
        clearStyleImp(srcRect, srcSheet);
       
        _clipboard = null;//clear used clipboard
        _spreadsheet.setHighlight(null);
      }
     
      if (rng != null) {
        _spreadsheet.setSelection(new Rect(rng.getColumn(), rng.getRow(),
            rng.getLastColumn(), rng.getLastRow())); 
      }
    }
  }
View Full Code Here
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
1529
              break;
            }
          }
        }
       
        Range range = Ranges.range(sheet, tRow, lCol, bRow, rCol);
        if (merged) {
          range.unMerge();
        } else {
          range.merge(false);
          doHorizontalAlignCenter(selection); 
        }
      } else {
        showProtectMessage();
      }
View Full Code Here
1830
1831
1832
1833
1834
1835
1836
1837
1838
1839
1840
1841
1842
1843
1844
1845
1846
1847
   */
  public void doFilter(Rect selection) {
    Worksheet sheet = _spreadsheet.getSelectedSheet();
    if (sheet != null && isValidSelection(selection)) {
      if (!sheet.getProtect()) {
        Range range = Ranges.range(sheet, selection.getTop(), selection.getLeft(), selection.getBottom(), selection.getRight());
        //ZSS-199
        switch (selection.getSelectionType()) {
        case Rect.SELECT_ROW:
          range.getRows().autoFilter();
          break;
        default:
          range.autoFilter();
          break;
        }
       
        clearClipboard(); 
      } else {
View Full Code Here
67
68
69
70
71
72
73
74
75
    int left = selection.getLeft();
    int right = selection.getRight();
    int top = selection.getTop();
    int btm = selection.getBottom();
   
    Range rng = Utils.getRange(sheet, top, left, btm, right);
       
    rng.autoFilter();
  }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
101
102
103
    int left = selection.getLeft();
    int right = selection.getRight();
    int top = selection.getTop();
    int btm = selection.getBottom();
   
    Range rng = Utils.getRange(sheet, top, left, btm, right);
    Range rng1 = null;
    Range rng2 = null;
    Range rng3 = null;
    boolean desc1 = false;
    boolean desc2 = false;
    boolean desc3 = false;
    int dataOption1 = 0;
    int dataOption2 = 0;
View Full Code Here
TOP

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

  • org.zkoss.zss.app.cell.CellHelper
  • org.zkoss.zss.app.MainWindowCtrl
  • org.zkoss.zss.app.PasteSpecialWindowCtrl
  • org.zkoss.zss.app.test.AutofilterComposer
  • org.zkoss.zss.app.zul.ctrl.SSWorkbookCtrl
  • org.zkoss.zss.app.zul.FormulaEditor
  • org.zkoss.zss.app.zul.Sheets
  • org.zkoss.zss.engine.fn.MathFns
  • org.zkoss.zss.engine.fn.StatFns
  • org.zkoss.zss.engine.fn.UtilFns
    • 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.