=TEXTAFTER throws NullReferenceException

Aspose.Cells Product Family
1

According to Page
Aspose.Cells supported TEXTAFTER function, however I found out the exception is thrown instead. Please take a look on the code below

[Test]
public void Tst()
{
    var wb = new Workbook();
    var ws = wb.Worksheets.Add("Data");
    ws.Cells["A1"].Value = "X match";
    ws.Cells["B1"].Formula = @"=TEXTAFTER(A1,"""")";
    wb.CalculateFormula();
    var b1Value = ws.Cells["B1"].Value;

    Assert.That(b1Value, Is.EqualTo("X match"));
}

  Message: 
Aspose.Cells.CellsException : NullReferenceException: Object reference not set to an instance of an object.(Based on cell Data!B1)

  Stack Trace: 
Workbook.CalculateFormula(CalculationOptions options)
Workbook.CalculateFormula()
AsposeCellsServiceTests.Tst() line 20

I tried it on Aspose.Cells v24.2 and v 24.4

2

@dredodin,

Thanks for the details.

After an initial test, I was able to reproduce the issue asyou mentioned by using the formula. I found Formula “TEXTAFTER” throws NullReferenceException.

We require thorough evaluation of the issue. 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-55652

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

@dredodin,

This is to inform you that your issue has been resolved. The fix/enhancement will be included in our upcoming release (Aspose.Cells v24.5) that we plan to release this week. You will be notified when the next version is released.

4

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