Examples of AreaRefImpl

Examples of org.zkoss.zss.engine.impl.AreaRefImpl

1052
1053
1054
1055
1056
1057
1058
1059
    final int dstB = dstT + dstRowCount - 1;
    final int dstR = dstL + dstColCount - 1;
   
    //ZSS-22: Shall not allow Copy and Paste operation in a protected spreadsheet
    final Worksheet dstSheet = BookHelper.getSheet(_sheet, dstRefSheet);
    final Ref pasteRef = new AreaRefImpl(dstT, dstL, dstB, dstR, dstRefSheet);
    return new RangeImpl(pasteRef, dstSheet).isAnyCellProtected() ? null : pasteRef;
  }
View Full Code Here

Examples of org.zkoss.zss.engine.impl.AreaRefImpl

2198
2199
2200
2201
2202
2203
2204
2205
2206
2207
2208
2209
2210
2211
2212
    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

Examples of org.zkoss.zss.engine.impl.AreaRefImpl

2222
2223
2224
2225
2226
2227
2228
2229
2230
2231
2232
2233
2234
2235
2236
    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

Examples of org.zkoss.zss.engine.impl.AreaRefImpl

2255
2256
2257
2258
2259
2260
2261
2262
2263
2264
2265
2266
2267
2268
2269
    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

Examples of org.zkoss.zss.engine.impl.AreaRefImpl

2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
    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

Examples of org.zkoss.zss.engine.impl.AreaRefImpl

2316
2317
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328
2329
2330
2331
2332
      ((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)
    all.add(new AreaRefImpl(ntRow, nlCol, nbRow, nrCol, refSheet));
   
    return new ChangeInfo(last, all, changeMerges);
  }
View Full Code Here

Examples of org.zkoss.zss.engine.impl.AreaRefImpl

2345
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
2358
2359
2360
2361
      ((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)
    all.add(new AreaRefImpl(ntRow, nlCol, nbRow, nrCol, refSheet));
   
    return new ChangeInfo(last, all, changeMerges);
  }
View Full Code Here

Examples of org.zkoss.zss.engine.impl.AreaRefImpl

2369
2370
2371
2372
2373
2374
2375
2376
2377
2378
2379
2380
2381
2382
2383
2384
2385
      if (rng != null) {
        int tRow = rng.getFirstRow();
        int lCol = rng.getFirstColumn();
        int bRow = rng.getLastRow();
        int rCol = rng.getLastColumn();
        ref = new AreaRefImpl(tRow, lCol, bRow, rCol, sheet);
      }
      final CellRangeAddress orgRng = rngs[0];
      int tRow = orgRng.getFirstRow();
      int lCol = orgRng.getFirstColumn();
      int bRow = orgRng.getLastRow();
      int rCol = orgRng.getLastColumn();
      final Ref orgRef = new AreaRefImpl(tRow, lCol, bRow, rCol, sheet);
      changeMerges.add(new MergeChange(orgRef, ref));
    }
    return changeMerges;
  }
View Full Code Here

Examples of org.zkoss.zss.engine.impl.AreaRefImpl

2457
2458
2459
2460
2461
2462
2463
2464
2465
2466
2467
          final int lastCol = merged.getLastColumn();
          final int firstRow = merged.getFirstRow();
          final int lastRow = merged.getLastRow();
          if (firstCol >= lCol && lastCol <= rCol
            && firstRow >= tRow && lastRow <= bRow) { //total cover
        changes.add(new MergeChange(new AreaRefImpl(firstRow, firstCol, lastRow, lastCol, refSheet), null));
        sheet.removeMergedRegion(j);
          }
    }
    return new ChangeInfo(null, null, changes);
  }
View Full Code Here

Examples of org.zkoss.zss.engine.impl.AreaRefImpl

2558
2559
2560
2561
2562
2563
2564
2565
2566
2567
2568
        }
      }
    }
   
    sheet.addMergedRegion(new CellRangeAddress(tRow, bRow, lCol, rCol));
    final Ref mergeArea = new AreaRefImpl(tRow, lCol, bRow, rCol, BookHelper.getRefSheet((Book)sheet.getWorkbook(), sheet));
    all.add(mergeArea);
    changes.add(new MergeChange(null, mergeArea));
   
    return new ChangeInfo(last, all, changes);
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.