diff --git a/ClosedXML/Excel/CalcEngine/CalcEngineHelpers.cs b/ClosedXML/Excel/CalcEngine/CalcEngineHelpers.cs index 6dea5a7..83d872a 100644 --- a/ClosedXML/Excel/CalcEngine/CalcEngineHelpers.cs +++ b/ClosedXML/Excel/CalcEngine/CalcEngineHelpers.cs @@ -75,7 +75,7 @@ // if criteria is a regular expression, use regex if (cs.IndexOfAny(new[] { '*', '?' }) > -1) - { + { var pattern = Regex.Replace( cs, "(" + String.Join( diff --git a/ClosedXML_Tests/Excel/CalcEngine/MathTrigTests.cs b/ClosedXML_Tests/Excel/CalcEngine/MathTrigTests.cs index 1832b9d..ad9e5dc 100644 --- a/ClosedXML_Tests/Excel/CalcEngine/MathTrigTests.cs +++ b/ClosedXML_Tests/Excel/CalcEngine/MathTrigTests.cs @@ -219,7 +219,7 @@ /// /// refers to Example 1 from the Excel documentation, - /// + /// /// /// /// @@ -229,7 +229,7 @@ [TestCase(28000, "SUMIF(A1:A4, \">\" &C1, B1:B4)")] public void SumIf_ReturnsCorrectValues_ReferenceExample1FromMicrosoft(int expectedOutcome, string formula) { - using(var wb = new XLWorkbook()) + using (var wb = new XLWorkbook()) { wb.ReferenceStyle = XLReferenceStyle.A1; @@ -251,14 +251,14 @@ /// /// refers to Example 2 from the Excel documentation, - /// + /// /// /// /// - [TestCase( 2000, "SUMIF(A2:A7,\"Fruits\", C2:C7)")] + [TestCase(2000, "SUMIF(A2:A7,\"Fruits\", C2:C7)")] [TestCase(12000, "SUMIF(A2:A7,\"Vegetables\", C2:C7)")] - [TestCase( 4300, "SUMIF(B2:B7, \"*es\", C2:C7)")] - [TestCase( 400, "SUMIF(A2:A7, \"\", C2:C7)")] + [TestCase(4300, "SUMIF(B2:B7, \"*es\", C2:C7)")] + [TestCase(400, "SUMIF(A2:A7, \"\", C2:C7)")] public void SumIf_ReturnsCorrectValues_ReferenceExample2FromMicrosoft(int expectedOutcome, string formula) { using (var wb = new XLWorkbook())