C# (CSharp) NPOI.HSSF.Record.CF CellRange.sliceUpの例

コード例 #1

ファイル: CellRange.cs プロジェクト: cschen1205/myob-accounting-plugin

 // 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));
 }

コード例 #2

ファイル: CellRange.cs プロジェクト: babywzazy/Server

 // 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);
 }