// TODO - Write junit test for this static CellRange[] resolveRangeOverlap(CellRange rangeA, CellRange rangeB) { if (rangeA.IsFullColumnRange()) { if (rangeB.IsFullRowRange()) { // Excel seems to leave these Unresolved return(null); } return(rangeA.sliceUp(rangeB)); } if (rangeA.IsFullRowRange()) { if (rangeB.IsFullColumnRange()) { // Excel seems to leave these Unresolved return(null); } return(rangeA.sliceUp(rangeB)); } if (rangeB.IsFullColumnRange()) { return(rangeB.sliceUp(rangeA)); } if (rangeB.IsFullRowRange()) { return(rangeB.sliceUp(rangeA)); } return(rangeA.sliceUp(rangeB)); }
// TODO - Write junit test for this static CellRange[] resolveRangeOverlap(CellRange rangeA, CellRange rangeB) { if (rangeA.IsFullColumnRange()) { if (rangeB.IsFullRowRange()) { // Excel seems to leave these Unresolved return null; } return rangeA.sliceUp(rangeB); } if (rangeA.IsFullRowRange()) { if (rangeB.IsFullColumnRange()) { // Excel seems to leave these Unresolved return null; } return rangeA.sliceUp(rangeB); } if (rangeB.IsFullColumnRange()) { return rangeB.sliceUp(rangeA); } if (rangeB.IsFullRowRange()) { return rangeB.sliceUp(rangeA); } return rangeA.sliceUp(rangeB); }