Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Book

4898
4899
4900
4901
4902
4903
4904
4905
4906
4907
4908
4909
4910
4911
4912
4913
4914
4915
    String[] list = constraint.getExplicitListValues();
    if (list != null) {
      return list;
    }
    String txt = constraint.getFormula1();
    Book book = sheet.getBook();
    final ValueEval ve = BookHelper.evaluateFormulaValueEval(book, book.getSheetIndex(sheet), txt, true);
    if (ve instanceof AreaEval) {
      final AreaEval ae = (AreaEval) ve;
      if (ae.isColumn() || ae.isRow()) {
        Worksheet worksheet = null;
        if (ae instanceof LazyAreaEval) {
          worksheet = book.getWorksheet(((LazyAreaEval) ve).getSheetName());
        } else {
          worksheet = sheet;
        }
       
        final int rows = ae.getHeight();
View Full Code Here
4952
4953
4954
4955
4956
4957
4958
4959
4960
4961
4962
4963
4964
4965
4966
4967
4968
4969
4970
4971
4972
4973
4974
4975
4976
4977
4978
4979
4980
        }
      }
      return false;
    } else {
      String txt = constraint.getFormula1();
      Book book = sheet.getBook();
      final ValueEval ve = BookHelper.evaluateFormulaValueEval(book, book.getSheetIndex(sheet), txt, false);
      if (ve instanceof ArrayEval) {
        final ArrayEval ae = (ArrayEval) ve;
        if (ae.isColumn() || ae.isRow()) {
          final int rows = ae.getHeight();
          final int cols = ae.getWidth();
          for (int r = 0; r < rows; ++r) {
            for (int c = 0; c < cols; ++c) {
              ValueEval xve = ae.getValue(r, c);
              final CellValue candidate = book.getFormulaEvaluator().getCellValueByValueEval(xve);
              if (equalCellValue(target, candidate)) {
                return true;
              }
            }
          }
        }
      } else {
        final CellValue candidate = book.getFormulaEvaluator().getCellValueByValueEval(ve);
        if (equalCellValue(target, candidate)) {
          return true;
        }
      }
      return false;
View Full Code Here
5064
5065
5066
5067
5068
5069
5070
5071
5072
5073
5074
5075
        return null;
      }
    }
    //get new evaluated formula value
    if (cellType == Cell.CELL_TYPE_FORMULA) {
      final Book book = sheet.getBook();
      final int sheetIndex = book.getSheetIndex(sheet);
      final CellValue cv = BookHelper.evaluateFormula(book, sheetIndex, (String) value);
      value = BookHelper.getValueByCellValue(cv);
      cellType = cv.getCellType();
    }
    //start validation
View Full Code Here
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
   * @param sheet sheet to set background color
   * @param rect selection range
   * @param color color to use
   */
  public static void setBackgroundColor(Worksheet sheet, Rect rect, String color) {
    final Book book  = (Book) sheet.getWorkbook();
    final Color bsColor = BookHelper.HTMLToColor(book, color);
    for (int row = rect.getTop(); row <= rect.getBottom(); row++)
      for (int col = rect.getLeft(); col <= rect.getRight(); col++) {
        Cell cell = Utils.getOrCreateCell(sheet, row, col);
        CellStyle cs = cell.getCellStyle();
        final Color srcColor = cs.getFillForegroundColorColor();
        if (Objects.equals(srcColor, bsColor)) {
          continue;
        }
        CellStyle newCellStyle = book.createCellStyle();
        newCellStyle.cloneStyleFrom(cs);
       
        //bug#ZSS-34: cell background color does not show in excel
        //20110819, henrichen@zkoss.org: set color to a cell shall change its fillPattern to "solid" automatically
        final short patternType = cs.getFillPattern();
View Full Code Here
744
745
746
747
748
749
750
751
752
  public static void copyCell(Cell cell, Worksheet dstSheet, int dstRow, int dstCol) {
    copyCell((Worksheet)cell.getSheet(), cell.getRowIndex(), cell.getColumnIndex(), dstSheet, dstRow, dstCol);
  }
 
  public static void insertRows(Worksheet sheet, int startRow, int endRow) {
    final Book book = (Book)sheet.getWorkbook();
    final Range rng = getRange(sheet, startRow, 0, endRow, book.getSpreadsheetVersion().getLastColumnIndex());
    rng.insert(Range.SHIFT_DEFAULT, Range.FORMAT_LEFTABOVE);
  }
View Full Code Here
750
751
752
753
754
755
756
757
758
    final Range rng = getRange(sheet, startRow, 0, endRow, book.getSpreadsheetVersion().getLastColumnIndex());
    rng.insert(Range.SHIFT_DEFAULT, Range.FORMAT_LEFTABOVE);
  }

  public static void deleteRows(Worksheet sheet, int startRow, int endRow) {
    final Book book = (Book)sheet.getWorkbook();
    final Range rng = getRange(sheet, startRow, 0, endRow, book.getSpreadsheetVersion().getLastColumnIndex());
    rng.delete(Range.SHIFT_DEFAULT);
  }
View Full Code Here
756
757
758
759
760
761
762
763
764
    final Range rng = getRange(sheet, startRow, 0, endRow, book.getSpreadsheetVersion().getLastColumnIndex());
    rng.delete(Range.SHIFT_DEFAULT);
  }

  public static void insertColumns(Worksheet sheet, int startCol, int endCol) {
    final Book book = (Book)sheet.getWorkbook();
    final Range rng = getRange(sheet, 0, startCol, book.getSpreadsheetVersion().getLastRowIndex(), endCol);
    rng.insert(Range.SHIFT_DEFAULT, Range.FORMAT_LEFTABOVE);
  }
View Full Code Here
762
763
764
765
766
767
768
769
770
    final Range rng = getRange(sheet, 0, startCol, book.getSpreadsheetVersion().getLastRowIndex(), endCol);
    rng.insert(Range.SHIFT_DEFAULT, Range.FORMAT_LEFTABOVE);
  }

  public static void deleteColumns(Worksheet sheet, int startCol, int endCol) {
    final Book book = (Book)sheet.getWorkbook();
    final Range rng = getRange(sheet, 0, startCol, book.getSpreadsheetVersion().getLastRowIndex(), endCol);
    rng.delete(Range.SHIFT_DEFAULT);
  }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
52
    return destination;
  }
 
  public static void setFontColor(Worksheet sheet, int row, int col, String color){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final Book book = (Book) sheet.getWorkbook();
    final short fontIdx = cell.getCellStyle().getFontIndex();
    final Font font = book.getFontAt(fontIdx);
    final Color orgColor = BookHelper.getFontColor(book, font);
    final Color newColor = BookHelper.HTMLToColor(book, color);
    if (orgColor == newColor || orgColor != null && orgColor.equals(newColor)) {
      return;
    }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
    cell.setCellStyle(style);
  }
 
  public static void setFillColor(Worksheet sheet, int row, int col, String color){
    final Cell cell = Utils.getOrCreateCell(sheet,row,col);
    final Book book = (Book) sheet.getWorkbook();
    final Color orgColor = cell.getCellStyle().getFillForegroundColorColor();
    final Color newColor = BookHelper.HTMLToColor(book, color);
    if (orgColor == newColor || orgColor != null  && orgColor.equals(newColor)) { //no change, skip
      return;
    }
View Full Code Here
TOP

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

  • org.zkoss.poi.ss.formula.DefaultDependencyTracker
  • org.zkoss.zss.app.cell.CellHelper
  • org.zkoss.zss.app.file.ExportToHtmlWindowCtrl
  • org.zkoss.zss.app.file.ExportToPdfWindowCtrl
  • org.zkoss.zss.app.file.FileHelper
  • org.zkoss.zss.app.link.InsertHyperlinkWindowCtrl
  • org.zkoss.zss.app.RangeHelper
  • org.zkoss.zss.app.sheet.SheetHelper
  • org.zkoss.zss.app.test.InvalidateSpreadsheetComposer
  • org.zkoss.zss.app.zul.ctrl.SSWorkbookCtrl
    • 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.