T.DIST.2T fails when deg_freedom >342

Aspose.Cells Product Family
1

Here is some C# code that shows the result of T.DIST.2T is wrong compared to Excel in V24.3.0, back at least to v17.1.0. Please can you have a look.

using System;
namespace TestTDIST {
internal class Program {
static void Main(string[] args) {
var wb = new Aspose.Cells.Workbook();
var ret = wb.Worksheets[0].CalculateFormula(“=T.DIST.2T(0.5,342)”).ToString();
Console.WriteLine(“This works”);
Console.WriteLine(ret);
Console.ReadLine();
ret = wb.Worksheets[0].CalculateFormula(“=T.DIST.2T(0.5,343)”).ToString();
Console.WriteLine(“This one fails with NotANumber”);
Console.WriteLine(ret);
Console.ReadLine();
}
}
}

2

@catnoise,

After an initial test, I am able to reproduce the issue as you mentioned. I found T.DIST.2T fails when deg_freedom >342.

We need to evaluate your issue in details. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-55363

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@catnoise
This is to inform you that your issue (logged as “CELLSNET-55363”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells v24.4) that we plan to release in the first half of April 2024. You will be notified when the next version is released.

4

The issues you have found earlier (filed as CELLSNET-55363) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi