Package org.zkoss.poi.ss.util

Examples of org.zkoss.poi.ss.util.CellRangeAddress

1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
      for(DataValidation dataValidation : dataValidations) {
        CellRangeAddressList addrList = dataValidation.getRegions();
        boolean srcInRange = false;
        boolean dstInRange = false;
        for(int j = addrList.countRanges(); --j >= 0;) {
          final CellRangeAddress addr = addrList.getCellRangeAddress(j);
          if (!srcInRange) {
            srcInRange = addr.isInRange(srcRow, srcCol);
          }
          if (!dstInRange) {
            dstInRange = addr.isInRange(dstRow, dstCol);
          }
          if (srcInRange && dstInRange) { //no need to copy
            break;
          }
        }
        if (!srcInRange) { //this validation is not associated to source cell
          continue;
        }
        if (!dstInRange) { //so we shall copy this data validation to dst cell
          dataValidation.getRegions().addCellRangeAddress(dstRow, dstCol, dstRow, dstCol);
        }
      }
    } else {
      final DataValidationHelper helper = dstSheet.getDataValidationHelper();
      for(DataValidation dataValidation : dataValidations) {
        CellRangeAddressList addrList = dataValidation.getRegions();
        boolean srcInRange = false;
        for(int j = addrList.countRanges(); --j >= 0;) {
          final CellRangeAddress addr = addrList.getCellRangeAddress(j);
          if (!srcInRange) {
            srcInRange = addr.isInRange(srcRow, srcCol);
          }
          if (srcInRange) {
            break;
          }
        }
View Full Code Here
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
    return _showContextMenu;
  }
 
  private Map convertAutoFilterToJSON(AutoFilter af) {
    if (af != null) {
      final CellRangeAddress addr = af.getRangeAddress();
      if (addr == null) {
        return null;
      }
      final Map addrmap = new HashMap();
      final int left = addr.getFirstColumn();
      final int right = addr.getLastColumn();
      final int top = addr.getFirstRow();
      final Worksheet sheet = this.getSelectedSheet();
      addrmap.put("left", left);
      addrmap.put("top", top);
      addrmap.put("right", right);
      addrmap.put("bottom", addr.getLastRow());
     
      int offcol = -1;
      final List<FilterColumn> fcs = af.getFilterColumns();
      final List<Map> fcsary = fcs != null ? new ArrayList<Map>(fcs.size()) : null;
      if (fcsary != null) {
View Full Code Here
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
  private Map convertDataValidationToJSON(DataValidation dv) {
    final CellRangeAddressList addrList = dv.getRegions();
    final int addrCount = addrList.countRanges();
    final List<Map> addrmapary = new ArrayList<Map>(addrCount);
    for (int j = 0; j < addrCount; ++j) {
      final CellRangeAddress addr = addrList.getCellRangeAddress(j);
      final int left = addr.getFirstColumn();
      final int right = addr.getLastColumn();
      final int top = addr.getFirstRow();
      final int bottom = addr.getLastRow();
      final Worksheet sheet = this.getSelectedSheet();
      final Map<String, Integer> addrmap = new HashMap<String, Integer>();
      addrmap.put("left", left);
      addrmap.put("top", top);
      addrmap.put("right", right);
View Full Code Here
2363
2364
2365
2366
2367
2368
2369
2370
2371
2372
2373
2374
    int fzc = getColumnfreeze();
    if (mmhelper == null) {
      final int sz = sheet.getNumMergedRegions();
      final List<int[]> mergeRanges = new ArrayList<int[]>(sz);
      for(int j = sz - 1; j >= 0; --j) {
        final CellRangeAddress addr = sheet.getMergedRegion(j);
        mergeRanges.add(new int[] {addr.getFirstColumn(), addr.getFirstRow(), addr.getLastColumn(), addr.getLastRow()});
      }
      helpers.putHelper(sheetId, mmhelper = new MergeMatrixHelper(mergeRanges, fzr, fzc));
    } else {
      mmhelper.update(fzr, fzc);
    }
View Full Code Here
304
305
306
307
308
309
310
311
312
313
314
  @Override
  public CellRangeAddress getRepeatingRowsAndColumns(int sheetNumber) {
    final XSSFName name = getBuiltInName(XSSFName.BUILTIN_PRINT_TITLE, sheetNumber);
    if (name == null) {
      return new CellRangeAddress(-1, -1, -1, -1);
    } else {
      final String formula = name.getRefersToFormula();
      final Ptg[] ptgs = FormulaParser.parse(formula, XSSFEvaluationWorkbook.create(this), FormulaType.NAMEDRANGE, name.getSheetIndex());
      return BookHelper.getRepeatRowsAndColumns(ptgs);
    }
View Full Code Here
1803
1804
1805
1806
1807
1808
1809
    }
   
    if (minr < 0 || maxc < 0) { //all blanks!
      return null;
    }
    return new CellRangeAddress(minr, maxr, minc, maxc);
  }
View Full Code Here
1812
1813
1814
1815
1816
1817
1818
1819
1820
1821
1822
  public Range getCurrentRegion() {
    synchronized (_sheet) {
      final Ref ref = getRefs().iterator().next();
      final int row = ref.getTopRow();
      final int col = ref.getLeftCol();
      CellRangeAddress cra = getCurrentRegion(_sheet, row, col);
      return cra == null ?
          new RangeImpl(row, col, _sheet, _sheet) :
          new RangeImpl(cra.getFirstRow(), cra.getFirstColumn(), cra.getLastRow(), cra.getLastColumn(), _sheet, _sheet);
    }
  }
View Full Code Here
1820
1821
1822
1823
1824
1825
1826
1827
1828
1829
1830
1831
1832
1833
          new RangeImpl(cra.getFirstRow(), cra.getFirstColumn(), cra.getLastRow(), cra.getLastColumn(), _sheet, _sheet);
    }
  }
 
  private int[] getCellMinMax(Worksheet sheet, int row, int col) {
    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
1930
1931
1932
1933
1934
1935
1936
      if (foundMax) {
        maxc = c;
      }
    }

    return new CellRangeAddress(minr, maxr, minc, maxc);
  }
View Full Code Here
2000
2001
2002
2003
2004
2005
2006
    } while(!stopu || !stopd);
   
    if (minr == Integer.MAX_VALUE && maxr < 0) { //all blanks in 9 cells!
      return null;
    }
    return new CellRangeAddress(minr, maxr, minc, maxc);
  }
View Full Code Here
TOP

Related Classes of org.zkoss.poi.ss.util.CellRangeAddress

  • org.zkoss.zss.app.RangeHelper
  • org.zkoss.zss.app.zul.FormulaEditor
  • org.zkoss.zss.demo.MainWindow
  • org.zkoss.zss.model.impl.Book05XlsDeleteRowsTest
  • org.zkoss.zss.model.impl.Book05XlsxDeleteRowsTest
  • org.zkoss.zss.model.impl.Book13XlsRepeatRowsColumnsTest
  • org.zkoss.zss.model.impl.Book13XlsxRepeatRowsColumnsTest
  • org.zkoss.zss.model.impl.BookHelper
  • org.zkoss.zss.model.impl.HSSFBookImpl
  • org.zkoss.zss.model.impl.HSSFSheetImpl
    • 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.