Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Worksheet

1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
 
  @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() ?
View Full Code Here
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583
 
  @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() ?
View Full Code Here
2600
2601
2602
2603
2604
2605
2606
2607
2608
2609
2610
2611
2612
2613
2614
2615
2616
2617
2618
2619
2620
      return new AMedia("css", "css", "text/css;charset=UTF-8",
          getSheetDefaultRules());
    }

    public void setColumnSize(String sheetId, int column, int newsize, int id, boolean hidden) {
      Worksheet sheet;
      if (getSelectedSheetId().equals(sheetId)) {
        sheet = getSelectedSheet();
      } else {
        sheet = Utils.getSheetByUuid(_book, sheetId);
      }
      // 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
2618
2619
2620
2621
2622
2623
2624
2625
2626
2627
2628
        rng.setColumnWidth(Utils.pxToFileChar256(newsize, ((Book)sheet.getWorkbook()).getDefaultCharWidth()));
      }
    }

    public void setRowSize(String sheetId, int rownum, int newsize, int id, boolean hidden) {
      Worksheet sheet;
      if (getSelectedSheetId().equals(sheetId)) {
        sheet = getSelectedSheet();
      } else {
        sheet = Utils.getSheetByUuid(_book, sheetId);
      }
View Full Code Here
2636
2637
2638
2639
2640
2641
2642
2643
2644
2645
2646
      HeaderPositionHelper helper = Spreadsheet.this.getRowPositionHelper(sheet);
      helper.setInfoValues(rownum, newsize, id, hidden);
    }

    public HeaderPositionHelper getColumnPositionHelper(String sheetId) {
      Worksheet sheet;
      if (getSelectedSheetId().equals(sheetId)) {
        sheet = getSelectedSheet();
      } else {
        sheet = Utils.getSheetByUuid(_book, sheetId);
      }
View Full Code Here
2647
2648
2649
2650
2651
2652
2653
2654
2655
2656
2657
      HeaderPositionHelper helper = Spreadsheet.this.getColumnPositionHelper(sheet);
      return helper;
    }

    public HeaderPositionHelper getRowPositionHelper(String sheetId) {
      Worksheet sheet;
      if (getSelectedSheetId().equals(sheetId)) {
        sheet = getSelectedSheet();
      } else {
        sheet = Utils.getSheetByUuid(_book, sheetId);
      }
View Full Code Here
2907
2908
2909
2910
2911
2912
2913
2914
2915
2916
2917
     * <ul>
     *   <li>hidden: default is false</li>
     * </ul>
     */
    public JSONObject getRowAttrs(int row) {
      Worksheet sheet = getSelectedSheet();
      HeaderPositionHelper helper = Spreadsheet.this.getRowPositionHelper(sheet);
      JSONObject attrs = new JSONObject();
      //row num
      attrs.put("r", row);
     
View Full Code Here
3459
3460
3461
3462
3463
3464
3465
3466
3467
3468
3469
      smartUpdate("rowSize", (Object) new Object[] { "", Utils.getSheetUuid(sheet), result}, true);
    }

    @Override
    public Boolean getLeftHeaderHiddens(int row) {
      Worksheet sheet = getSelectedSheet();
      HeaderPositionHelper rowHelper = Spreadsheet.this
          .getRowPositionHelper(sheet);
      HeaderPositionInfo info = rowHelper.getInfo(row);
      return info == null ? Boolean.FALSE : Boolean.valueOf(info.hidden);
    }
View Full Code Here
3468
3469
3470
3471
3472
3473
3474
3475
3476
3477
3478
      return info == null ? Boolean.FALSE : Boolean.valueOf(info.hidden);
    }

    @Override
    public Boolean getTopHeaderHiddens(int col) {
      Worksheet sheet = getSelectedSheet();
      HeaderPositionHelper colHelper = Spreadsheet.this
          .getColumnPositionHelper(sheet);
      HeaderPositionInfo info = colHelper.getInfo(col);
      return info == null ? Boolean.FALSE : Boolean.valueOf(info.hidden);
    }
View Full Code Here
726
727
728
729
730
731
732
733
734
735
736
      _selectedSheetId = null;
      _selectedSheetName = null;
    }

    if (_selectedSheet == null || !_selectedSheet.getSheetName().equals(name)) {
      Worksheet sheet = book.getWorksheet(name);
      if (sheet == null) {
        throw new UiException("No such sheet : " + name);
      }

      if (_selectedSheet != null)
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.