Package org.zkoss.poi.ss.usermodel

Examples of org.zkoss.poi.ss.usermodel.Cell

397
398
399
400
401
402
403
404
405
406
407
408
      final Worksheet sheet = BookHelper.getSheet(_sheet, refSheet);
      final Workbook book = sheet.getWorkbook();
     
      for(int row = tRow; row <= bRow; ++row) {
        for (int col = lCol; col <= rCol; ++col) {
          final Cell cell = BookHelper.getCell(sheet, row, col);
          final CellStyle style = cell != null ? cell.getCellStyle() : null;
          final String oldFormat = style != null ? style.getDataFormatString() : null;
          if (oldFormat == null || "General".equals(oldFormat)) {
            CellStyle newCellStyle = book.createCellStyle();
            if (style != null) {
              newCellStyle.cloneStyleFrom(style);
View Full Code Here
641
642
643
644
645
646
647
648
649
650
651
    }
    return row;
  }
 
  private Cell getOrCreateCell(Row row, int colIndex, int type) {
    Cell cell = row.getCell(colIndex);
    if (cell == null) {
      cell = row.createCell(colIndex, type);
    }
    return cell;
  }
View Full Code Here
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
        if (sheet.getProtect()) {
          for (int r = top; r <= bottom; ++r) {
            final Row row = sheet.getRow(r);
            if (row != null) {
              for (int c = left; c <= right; ++c) {
                final Cell cell = row.getCell(c);
                if (cell != null) {
                  final CellStyle cs = cell.getCellStyle();
                  if (cs != null && cs.getLocked()) {
                    //as long as one is protected and locked, return true
                    return true;
                  }
                }
View Full Code Here
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
      for(int rr = rowRepeat; rr > 0; --rr) {
        for(int srcRow = tRow; srcRow <= bRow; ++srcRow, ++dstRow) {
          int dstCol= dstRef.getLeftCol();
          for (int cr = colRepeat; cr > 0; --cr) {
            for (int srcCol = lCol; srcCol <= rCol; ++srcCol, ++dstCol) {
              final Cell cell = BookHelper.getCell(srcSheet, srcRow, srcCol);
              if (cell != null) {
                if (!skipBlanks || cell.getCellType() != Cell.CELL_TYPE_BLANK) {
                  final ChangeInfo changeInfo0 = BookHelper.copyCell(cell, dstSheet, dstRow, dstCol, pasteType, pasteOp, transpose);
                  BookHelper.assignChangeInfo(toEval, affected, mergeChanges, changeInfo0);
                }
              } else if (!skipBlanks) {
                final Set<Ref>[] refs = BookHelper.removeCell(dstSheet, dstRow, dstCol);
                BookHelper.assignRefs(toEval, affected, refs);
              }
            }
          }
        }
      }
    } else { //row -> column, column -> row
      int dstCol = dstRef.getLeftCol();
      for(int rr = rowRepeat; rr > 0; --rr) {
        for(int srcRow = tRow; srcRow <= bRow; ++srcRow, ++dstCol) {
          int dstRow = dstRef.getTopRow();
          for (int cr = colRepeat; cr > 0; --cr) {
            for (int srcCol = lCol; srcCol <= rCol; ++srcCol, ++dstRow) {
              final Cell cell = BookHelper.getCell(srcSheet, srcRow, srcCol);
              if (cell != null) {
                if (!skipBlanks || cell.getCellType() != Cell.CELL_TYPE_BLANK) {
                  final ChangeInfo changeInfo0 = BookHelper.copyCell(cell, dstSheet, dstRow, dstCol, pasteType, pasteOp, transpose);
                  BookHelper.assignChangeInfo(toEval, affected, mergeChanges, changeInfo0);
                }
              } else if (!skipBlanks) {
                final Set<Ref>[] refs = BookHelper.removeCell(dstSheet, dstRow, dstCol);
View Full Code Here
1615
1616
1617
1618
1619
1620
1621
1622
1623
1624
1625
      Ref ref = _refs != null && !_refs.isEmpty() ? _refs.iterator().next() : null;
      if (ref != null) {
        final int tRow = ref.getTopRow();
        final int lCol = ref.getLeftCol();
        final RefSheet refSheet = ref.getOwnerSheet();
        final Cell cell = getCell(tRow, lCol, refSheet);
        if (cell != null) {
          return getValue0(cell);
        }
      }
      return null;
View Full Code Here
1734
1735
1736
1737
1738
1739
1740
1741
1742
1743
1744
1745
1746
1747
1748
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1785
1786
1787
1788
1789
1790
1791
1792
1793
1794
1795
1796
1797
1798
1799
1800
1801
        if (ll < 0) { //empty row
          continue;
        }
        int rr = rowobj.getLastCellNum() - 1;
        for(int c = ll; c <= rr; ++c) {
          final Cell cell = rowobj.getCell(c);
          if (!BookHelper.isBlankCell(cell)) { //first no blank row
            minr = r;
            break;
          }
        }
      }
    }
    //bottom row
    int maxr = -1;
    for(int r = b; r >= minr && maxr < 0; --r) {
      final Row rowobj = sheet.getRow(r);
      if (rowobj != null) {
        int ll = rowobj.getFirstCellNum();
        if (ll < 0) { //empty row
          continue;
        }
        int rr = rowobj.getLastCellNum() - 1;
        for(int c = ll; c <= rr; ++c) {
          final Cell cell = rowobj.getCell(c);
          if (!BookHelper.isBlankCell(cell)) { //first no blank row
            maxr = r;
            break;
          }
        }
      }
    }
    //left col
    int minc = Integer.MAX_VALUE;
    for(int r = minr; r <= maxr; ++r) {
      final Row rowobj = sheet.getRow(r);
      if (rowobj != null) {
        int ll = rowobj.getFirstCellNum();
        if (ll < 0) { //empty row
          continue;
        }
        int rr = rowobj.getLastCellNum() - 1;
        for(int c = ll; c < minc && c <= rr; ++c) {
          final Cell cell = rowobj.getCell(c);
          if (!BookHelper.isBlankCell(cell)) { //first no blank row
            minc = c;
            break;
          }
        }
      }
    }
    //right col
    int maxc = -1;
    for(int r = minr; r <= maxr; ++r) {
      final Row rowobj = sheet.getRow(r);
      if (rowobj != null) {
        int ll = rowobj.getFirstCellNum();
        if (ll < 0) { //empty row
          continue;
        }
        int rr = rowobj.getLastCellNum() - 1;
        for(int c = rr; c > maxc && c >= ll; --c) {
          final Cell cell = rowobj.getCell(c);
          if (!BookHelper.isBlankCell(cell)) { //first no blank row
            maxc = c;
            break;
          }
        }
View Full Code Here
1825
1826
1827
1828
1829
1830
1831
1832
1833
    final CellRangeAddress rng = BookHelper.getMergeRegion(sheet, row, col);
    final int t = rng.getFirstRow();
    final int l = rng.getFirstColumn();
    final int b = rng.getLastRow();
    final int r = rng.getLastColumn();
    final Cell cell = BookHelper.getCell(sheet, t, l);
    return (!BookHelper.isBlankCell(cell)) ?
      new int[] {l, t, r, b} : null;
  }
View Full Code Here
2090
2091
2092
2093
2094
2095
2096
2097
2098
2099
2100
    }
    return true;
  }
 
  private boolean shallHide(FilterColumn fc, int row, int col) {
    final Cell cell = BookHelper.getCell(_sheet, row, col + fc.getColId());
    final boolean blank = BookHelper.isBlankCell(cell);
    final String val =  blank ? "=" : BookHelper.getCellText(cell); //"=" means blank!
    final Set critera1 = fc.getCriteria1();
    return critera1 != null && !critera1.isEmpty() && !critera1.contains(val);
  }
View Full Code Here
2207
2208
2209
2210
2211
2212
2213
2214
2215
2216
2217
      final int row2 = affectedArea.getLastRow();
      final Set cr1 = fc.getCriteria1();
 
      final Set<Ref> all = new HashSet<Ref>();
      for (int r = row; r <= row2; ++r) {
        final Cell cell = BookHelper.getCell(_sheet, r, col);
        final String val = BookHelper.isBlankCell(cell) ? "=" : BookHelper.getCellText(cell); //"=" means blank!
        if (cr1 != null && !cr1.isEmpty() && !cr1.contains(val)) { //to be hidden
          final Row rowobj = _sheet.getRow(r);
          if (rowobj == null || !rowobj.getZeroHeight()) { //a non-hidden row
            new RangeImpl(r, col, _sheet, _sheet).getRows().setHidden(true);
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
//            if (srcStyle != null) {
//              row.setRowStyle((HSSFCellStyle)copyFromStyleExceptBorder(srcStyle));//style
//            }
            if (srcCells != null) {
              for (Entry<Integer, Cell> cellEntry : srcCells.entrySet()) {
                final Cell srcCell = cellEntry.getValue();
                final CellStyle cellStyle = srcCell.getCellStyle();
                final int c = cellEntry.getKey().intValue();
                Cell cell = row.getCell(c);
                if (cell == null) {
                  cell = row.createCell(c);
                }
                cell.setCellStyle(BookHelper.copyFromStyleExceptBorder(getBook(), cellStyle));
              }
            }
          }
        }
       
View Full Code Here
TOP

Related Classes of org.zkoss.poi.ss.usermodel.Cell

  • org.zkoss.zss.app.cell.CellHelper
  • org.zkoss.zss.app.ctrl.AutoFilterCtrl
  • 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.sort.CustomSortWindowCtrl$SortAlgorithm
  • org.zkoss.zss.app.zul.FormulaEditor
  • org.zkoss.zss.demo.MainWindow
  • org.zkoss.zss.demo.ZssGmapWindow
    • 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.