diff --git a/ClosedXML/Excel/CalcEngine/Functions/MathTrig.cs b/ClosedXML/Excel/CalcEngine/Functions/MathTrig.cs index 8111c18..7fc00f2 100644 --- a/ClosedXML/Excel/CalcEngine/Functions/MathTrig.cs +++ b/ClosedXML/Excel/CalcEngine/Functions/MathTrig.cs @@ -118,7 +118,7 @@ private static object Csch(List p) { - if (p[0].Evaluate().Equals(0)) + if (p[0].Evaluate().Equals(0.0)) { return ErrorExpression.ExpressionErrorType.DivisionByZero; } diff --git a/ClosedXML_Tests/Excel/CalcEngine/MathTrigTests.cs b/ClosedXML_Tests/Excel/CalcEngine/MathTrigTests.cs index 0c0b33a..b8406cd 100644 --- a/ClosedXML_Tests/Excel/CalcEngine/MathTrigTests.cs +++ b/ClosedXML_Tests/Excel/CalcEngine/MathTrigTests.cs @@ -163,13 +163,13 @@ } [Test] - public void Csh_ReturnsDivisionByZeroErrorOnInput0() + public void Csch_ReturnsDivisionByZeroErrorOnInput0() { using (var wb = new XLWorkbook()) { var ws = wb.AddWorksheet("Sheet1"); ws.FirstCell().Value = 0; - Assert.AreEqual(ErrorExpression.ExpressionErrorType.DivisionByZero, ws.Evaluate("CSH(A1)")); + Assert.AreEqual(ErrorExpression.ExpressionErrorType.DivisionByZero, ws.Evaluate("CSCH(A1)")); } } }