diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs index 9ef7381..d86698a 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs @@ -184,7 +184,9 @@ /// Merges this range. /// The contents and style of the merged cells will be equal to the first cell. /// - IXLRange Merge(Boolean checkIntersect = true); + IXLRange Merge(); + + IXLRange Merge(Boolean checkIntersect); /// /// Creates a named range out of this range. diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs index 69cc663..6b946c8 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs @@ -319,7 +319,12 @@ return CellsUsed(includeFormats); } - public IXLRange Merge(Boolean checkIntersect = true) + public IXLRange Merge() + { + return Merge(true); + } + + public IXLRange Merge(Boolean checkIntersect) { if (checkIntersect) { diff --git a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs index f3ca136..b9545be 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs @@ -14,33 +14,32 @@ { private static void Main(string[] args) { - - using (XLWorkbook wb = new XLWorkbook(XLEventTracking.Disabled)) - { - using (var ws = wb.AddWorksheet("MergeCellsWorksheet")) - { - int total = 5000; - var timer = System.Diagnostics.Stopwatch.StartNew(); - // Insert some values - for (int i = 1; i <= total; i += 2) - { - ws.Cell(i, 1).Value = "Merge Cell 1"; - ws.Cell(i, 3).Value = "Merge Cell 2"; - ws.Cell(i, 4).Value = "Merge Cell 3"; - ws.Cell((i + 1), 4).Value = "Merge Cell 4"; +int total = 5000; +var timer = System.Diagnostics.Stopwatch.StartNew(); +using (XLWorkbook wb = new XLWorkbook(XLEventTracking.Disabled)) +{ + using (var ws = wb.AddWorksheet("MergeCellsWorksheet")) + { + ws.RangeUsed().Style.Fill.BackgroundColor = XLColor.FromArgb(1); + // Insert some values + for (int i = 1; i <= total; i += 2) + { + ws.Cell(i, 1).Value = "Merge Cell 1"; + ws.Cell(i, 3).Value = "Merge Cell 2"; + ws.Cell(i, 4).Value = "Merge Cell 3"; + ws.Cell((i + 1), 4).Value = "Merge Cell 4"; - ws.Range("A" + i + ":B" + (i + 1)).Merge(false); - ws.Range("C" + i + ":C" + (i + 1)).Merge(false); - ws.Range("D" + i + ":E" + i).Merge(false); - ws.Range("D" + (i + 1) + ":E" + (i + 1)).Merge(false); - } - timer.Stop(); - Console.WriteLine("Took {0}s", timer.Elapsed.TotalSeconds); - } - - wb.SaveAs(@"c:\temp\saved.xlsx"); - } - Console.WriteLine("Done"); + ws.Range("A" + i + ":B" + (i + 1)).Merge(false); + ws.Range("C" + i + ":C" + (i + 1)).Merge(false); + ws.Range("D" + i + ":E" + i).Merge(false); + ws.Range("D" + (i + 1) + ":E" + (i + 1)).Merge(false); + } + } + wb.SaveAs(@"c:\temp\saved.xlsx"); +} +timer.Stop(); +Console.WriteLine("Took {0}s", timer.Elapsed.TotalSeconds); +Console.WriteLine("Done"); Console.ReadKey(); }