Package org.zkoss.zss.model

Examples of org.zkoss.zss.model.Book

662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
    return r;
  }
 
  protected void syncClipboard() {
    if (_clipboard != null) {
      final Book srcBook = _clipboard.book;
      if (!srcBook.equals(_spreadsheet.getBook())) {
        _clipboard = null;
      } else {
        final Worksheet srcSheet = _clipboard.sourceSheet;
        boolean validSheet = srcBook.getSheetIndex(srcSheet) >= 0;
        if (!validSheet) {
          clearClipboard();
        } else if (!srcSheet.equals(_spreadsheet.getSelectedSheet())) {
          _spreadsheet.setHighlight(null);
        } else {
View Full Code Here
2146
2147
2148
2149
2150
2151
2152
2153
2154
2155
2156
2157
2158
2159
2160
2161
2162
2163
2164
      return deleteXSSFColumns(sheet, startCol, num);
    }
  }
 
  public static ChangeInfo deleteHSSFColumns(Worksheet sheet, int startCol, int num) {
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.deleteColumns(startCol, num);
    final int startCol0 = startCol + num;
    final List<CellRangeAddress[]> shiftedRanges = ((HSSFSheetImpl)sheet).shiftColumnsOnly(startCol0, -1, -num, true, false, true, true, Range.FORMAT_NONE);
    final List<MergeChange> changeMerges = prepareChangeMerges(refSheet, shiftedRanges);
    final Set<Ref> last = refs[0];
    final Set<Ref> all = refs[1];
    final int maxrow = book.getSpreadsheetVersion().getLastRowIndex();
    final int maxcol = book.getSpreadsheetVersion().getLastColumnIndex();
    shiftFormulas(all, sheet, 0, maxrow, 0, startCol0, maxcol, -num);
   
    return new ChangeInfo(last, all, changeMerges);
  }
View Full Code Here
885
886
887
888
889
890
891
892
893
894
895
896
897
   * @param pasteOperation
   * @param skipBlank
   * @param transpose
   */
  protected void doPasteImpl(Rect selection, int pasteType, int pasteOperation, boolean skipBlank, boolean transpose) {
    Book srcBook = _clipboard.book;
    Book targetBook = _spreadsheet.getBook();
    if (targetBook != null && targetBook.equals(srcBook)) {
      final Worksheet srcSheet = _clipboard.sourceSheet;
      boolean validSheet = srcBook.getSheetIndex(srcSheet) >= 0;
      if (!validSheet) {
        clearClipboard();
        return;
View Full Code Here
2162
2163
2164
2165
2166
2167
2168
2169
2170
2171
2172
2173
2174
2175
2176
2177
2178
2179
2180
   
    return new ChangeInfo(last, all, changeMerges);
  }
 
  public static ChangeInfo deleteXSSFColumns(Worksheet sheet, int startCol, int num) {
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.deleteColumns(startCol, num);
    final int startCol0 = startCol + num;
    final List<CellRangeAddress[]> shiftedRanges = ((XSSFSheetImpl)sheet).shiftColumnsOnly(startCol0, -1, -num, true, false, true, true, Range.FORMAT_NONE);
    final List<MergeChange> changeMerges = prepareChangeMerges(refSheet, shiftedRanges);
    final Set<Ref> last = refs[0];
    final Set<Ref> all = refs[1];
    final int maxrow = book.getSpreadsheetVersion().getLastRowIndex();
    final int maxcol = book.getSpreadsheetVersion().getLastColumnIndex();
    shiftFormulas(all, sheet, 0, maxrow, 0, startCol0, maxcol, -num);
   
    return new ChangeInfo(last, all, changeMerges);
  }
View Full Code Here
2186
2187
2188
2189
2190
2191
2192
2193
2194
2195
2196
2197
2198
2199
2200
2201
2202
2203
2204
2205
2206
2207
2208
2209
2210
2211
      return insertXSSFRange(sheet, tRow, lCol, bRow, rCol, horizontal, copyRightBelow);
    }
  }
 
  private static ChangeInfo insertHSSFRange(Worksheet sheet, int tRow, int lCol, int bRow, int rCol, boolean horizontal, int copyRightBelow) {
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.insertRange(tRow, lCol, bRow, rCol, horizontal);
    final int num = horizontal ? rCol - lCol + 1 : bRow - tRow + 1;
    final List<CellRangeAddress[]> shiftedRanges = horizontal ?
      ((HSSFSheetImpl)sheet).shiftColumnsRange(lCol, -1, num, tRow, bRow, true, false, true, false, copyRightBelow):
      ((HSSFSheetImpl)sheet).shiftRowsRange(tRow, -1, num, lCol, rCol, true, false, true, false, copyRightBelow);
    final List<MergeChange> changeMerges = prepareChangeMerges(refSheet, shiftedRanges);
    final Set<Ref> last = refs[0];
    final Set<Ref> all = refs[1];
    if (horizontal) {
      final int maxcol = book.getSpreadsheetVersion().getLastColumnIndex();
      all.add(new AreaRefImpl(tRow, lCol, bRow, maxcol, refSheet));
      shiftFormulas(all, sheet, tRow, bRow, 0, lCol, maxcol, num);
    } else {
      final int maxrow = book.getSpreadsheetVersion().getLastRowIndex();
      all.add(new AreaRefImpl(tRow, lCol, maxrow, rCol, refSheet));
      shiftFormulas(all, sheet, tRow, maxrow, num, lCol, rCol, 0);
    }
   
    return new ChangeInfo(last, all, changeMerges);
View Full Code Here
2210
2211
2212
2213
2214
2215
2216
2217
2218
2219
2220
2221
2222
2223
2224
2225
2226
2227
2228
2229
2230
2231
2232
2233
2234
2235
   
    return new ChangeInfo(last, all, changeMerges);
  }
 
  private static ChangeInfo insertXSSFRange(Worksheet sheet, int tRow, int lCol, int bRow, int rCol, boolean horizontal, int copyRightBelow) {
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.insertRange(tRow, lCol, bRow, rCol, horizontal);
    final int num = horizontal ? rCol - lCol + 1 : bRow - tRow + 1;
    final List<CellRangeAddress[]> shiftedRanges = horizontal ?
      ((XSSFSheetImpl)sheet).shiftColumnsRange(lCol, -1, num, tRow, bRow, true, false, true, false, copyRightBelow):
      ((XSSFSheetImpl)sheet).shiftRowsRange(tRow, -1, num, lCol, rCol, true, false, true, false, copyRightBelow);
    final List<MergeChange> changeMerges = prepareChangeMerges(refSheet, shiftedRanges);
    final Set<Ref> last = refs[0];
    final Set<Ref> all = refs[1];
    if (horizontal) {
      final int maxcol = book.getSpreadsheetVersion().getLastColumnIndex();
      all.add(new AreaRefImpl(tRow, lCol, bRow, maxcol, refSheet));
      shiftFormulas(all, sheet, tRow, bRow, 0, lCol, maxcol, num);
    } else {
      final int maxrow = book.getSpreadsheetVersion().getLastRowIndex();
      all.add(new AreaRefImpl(tRow, lCol, maxrow, rCol, refSheet));
      shiftFormulas(all, sheet, tRow, maxrow, num, lCol, rCol, 0);
    }
   
    return new ChangeInfo(last, all, changeMerges);
View Full Code Here
2242
2243
2244
2245
2246
2247
2248
2249
2250
2251
2252
2253
2254
2255
2256
2257
2258
2259
2260
2261
2262
2263
2264
2265
2266
2267
2268
      return deleteXSSFRange(sheet, tRow, lCol, bRow, rCol, horizontal);
    }
  }
 
  private static ChangeInfo deleteHSSFRange(Worksheet sheet, int tRow, int lCol, int bRow, int rCol, boolean horizontal) {
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.deleteRange(tRow, lCol, bRow, rCol, horizontal);
    final int num = horizontal ? rCol - lCol + 1 : bRow - tRow + 1;
    final List<CellRangeAddress[]> shiftedRanges = horizontal ?
      ((HSSFSheetImpl)sheet).shiftColumnsRange(rCol + 1, -1, -num, tRow, bRow, true, false, true, true, Range.FORMAT_NONE):
      ((HSSFSheetImpl)sheet).shiftRowsRange(bRow + 1, -1, -num, lCol, rCol, true, false, true, true, Range.FORMAT_NONE);
    final List<MergeChange> changeMerges = prepareChangeMerges(refSheet, shiftedRanges);
    final Set<Ref> last = refs[0];
    final Set<Ref> all = refs[1];
   
    if (horizontal) {
      final int maxcol = book.getSpreadsheetVersion().getLastColumnIndex();
      all.add(new AreaRefImpl(tRow, lCol, bRow, maxcol, refSheet));
      shiftFormulas(all, sheet, tRow, bRow, 0, rCol + 1, maxcol, -num);
    } else {
      final int maxrow = book.getSpreadsheetVersion().getLastRowIndex();
      all.add(new AreaRefImpl(tRow, lCol, maxrow, rCol, refSheet));
      shiftFormulas(all, sheet, bRow + 1, maxrow, -num, lCol, rCol, 0);
    }
   
    return new ChangeInfo(last, all, changeMerges);
View Full Code Here
2267
2268
2269
2270
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
   
    return new ChangeInfo(last, all, changeMerges);
  }

  private static ChangeInfo deleteXSSFRange(Worksheet sheet, int tRow, int lCol, int bRow, int rCol, boolean horizontal) {
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.deleteRange(tRow, lCol, bRow, rCol, horizontal);
    final int num = horizontal ? rCol - lCol + 1 : bRow - tRow + 1;
    final List<CellRangeAddress[]> shiftedRanges = horizontal ?
      ((XSSFSheetImpl)sheet).shiftColumnsRange(rCol + 1, -1, -num, tRow, bRow, true, false, true, true, Range.FORMAT_NONE):
      ((XSSFSheetImpl)sheet).shiftRowsRange(bRow + 1, -1, -num, lCol, rCol, true, false, true, true, Range.FORMAT_NONE);
    final List<MergeChange> changeMerges = prepareChangeMerges(refSheet, shiftedRanges);
    final Set<Ref> last = refs[0];
    final Set<Ref> all = refs[1];
   
    if (horizontal) {
      final int maxcol = book.getSpreadsheetVersion().getLastColumnIndex();
      all.add(new AreaRefImpl(tRow, lCol, bRow, maxcol, refSheet));
      shiftFormulas(all, sheet, tRow, bRow, 0, rCol + 1, maxcol, -num);
    } else {
      final int maxrow = book.getSpreadsheetVersion().getLastRowIndex();
      all.add(new AreaRefImpl(tRow, lCol, maxrow, rCol, refSheet));
      shiftFormulas(all, sheet, bRow + 1, maxrow, -num, lCol, rCol, 0);
    }
   
    return new ChangeInfo(last, all, changeMerges);
View Full Code Here
2304
2305
2306
2307
2308
2309
2310
2311
2312
2313
2314
2315
2316
2317
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328
   
  private static ChangeInfo moveHSSFRange(Worksheet sheet, int tRow, int lCol, int bRow, int rCol, int nRow, int nCol) {
    if (nRow == 0 && nCol == 0) { //nothing to do!
      return null;
    }
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.moveRange(tRow, lCol, bRow, rCol, nRow, nCol);
    final List<CellRangeAddress[]> shiftedRanges = nCol != 0 && nRow == 0 ?
      ((HSSFSheetImpl)sheet).shiftColumnsRange(lCol, rCol, nCol, tRow, bRow, true, false, true, false, Range.FORMAT_NONE):
      nCol == 0 && nRow != 0 ?
      ((HSSFSheetImpl)sheet).shiftRowsRange(tRow, bRow, nRow, lCol, rCol, true, false, true, false, Range.FORMAT_NONE):
      ((HSSFSheetImpl)sheet).shiftBothRange(tRow, bRow, nRow, lCol, rCol, nCol, true); //nCol != 0 && nRow != 0
    final List<MergeChange> changeMerges = prepareChangeMerges(refSheet, shiftedRanges);
    final Set<Ref> last = refs[0];
    final Set<Ref> all = refs[1];
    shiftFormulas(all, sheet, tRow, bRow, nRow, lCol, rCol, nCol);
    all.add(new AreaRefImpl(tRow, lCol, bRow, rCol, refSheet)); //original selection
    final int maxrow = book.getSpreadsheetVersion().getLastRowIndex();
    final int maxcol = book.getSpreadsheetVersion().getLastColumnIndex();
    int ntRow = Math.max(0, tRow + nRow);
    int nlCol = Math.max(0, lCol + nCol);
    int nbRow = Math.min(maxrow, bRow + nRow);
    int nrCol = Math.min(maxcol, rCol + nCol);
    if (ntRow <= nbRow && nlCol <= nrCol)
View Full Code Here
2333
2334
2335
2336
2337
2338
2339
2340
2341
2342
2343
2344
2345
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
 
  private static ChangeInfo moveXSSFRange(Worksheet sheet, int tRow, int lCol, int bRow, int rCol, int nRow, int nCol) {
    if (nRow == 0 && nCol == 0) { //nothing to do!
      return null;
    }
    final Book book = (Book) sheet.getWorkbook();
    final RefSheet refSheet = getRefSheet(book, sheet);
    final Set<Ref>[] refs = refSheet.moveRange(tRow, lCol, bRow, rCol, nRow, nCol);
    final List<CellRangeAddress[]> shiftedRanges = nCol != 0 && nRow == 0 ?
      ((XSSFSheetImpl)sheet).shiftColumnsRange(lCol, rCol, nCol, tRow, bRow, true, false, true, false, Range.FORMAT_NONE):
      nCol == 0 && nRow != 0 ?
      ((XSSFSheetImpl)sheet).shiftRowsRange(tRow, bRow, nRow, lCol, rCol, true, false, true, false, Range.FORMAT_NONE):
      ((XSSFSheetImpl)sheet).shiftBothRange(tRow, bRow, nRow, lCol, rCol, nCol, true); //nCol != 0 && nRow != 0
    final List<MergeChange> changeMerges = prepareChangeMerges(refSheet, shiftedRanges);
    final Set<Ref> last = refs[0];
    final Set<Ref> all = refs[1];
    shiftFormulas(all, sheet, tRow, bRow, nRow, lCol, rCol, nCol);
    all.add(new AreaRefImpl(tRow, lCol, bRow, rCol, refSheet)); //original selection
    final int maxrow = book.getSpreadsheetVersion().getLastRowIndex();
    final int maxcol = book.getSpreadsheetVersion().getLastColumnIndex();
    int ntRow = Math.max(0, tRow + nRow);
    int nlCol = Math.max(0, lCol + nCol);
    int nbRow = Math.min(maxrow, bRow + nRow);
    int nrCol = Math.min(maxcol, rCol + nCol);
    if (ntRow <= nbRow && nlCol <= nrCol)
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.