Not Considering the latest Formula as Formula

Aspose.Cells Product Family
1

Hello,

I am having the Latest Version of “Formula” in my excel worksheet.
Which is as follow:
In Excel 2019 It is: “=TEXTJOIN(”-",TRUE, I27,I28)".
In Excel 2007 It Is: “=_xlfn.TEXTJOIN(”-",TRUE, I27,I28)"

Both are formula and Excel is returning them as Formula but aspose cells is not able to consider the formula as “Formula” in any of the version.
It’s cell.IsFormula Method returns False as it’s not considering as formula.

2

@harshCIPL22,

Thanks for your query.

Could you attached your template file containing the formula, we will check it soon.

3

Here is the sample file for it.
Sample.zip (60.7 KB)

4

@harshCIPL22,

After an initial test, I am able to reproduce the issue as you mentioned by using your template file and following sample code. I found Aspose.Cells does not consider TEXTJOIN (advanced formula/function) as formula when it has more than 3 parameters or so:
e.g
Sample code:

Workbook wb = new Workbook("e:\\test2\\Sample_nct.xlsx");
            Worksheet worksheet = wb.Worksheets["Sheet1"];

            Cell cell1 = worksheet.Cells["I4"];

            Cell cell3 = worksheet.Cells["J4"];
            Console.WriteLine(cell1.IsFormula + ":" + cell1.Formula);

            Console.WriteLine(cell3.IsFormula + ":" + cell3.Formula);

I have logged a ticket with an id “CELLSNET-47135” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

5

@harshCIPL22,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

6

Thanks for you quick responses.

I’ll wait for the new version or hot fix.

7

@harshCIPL22,
You are welcome.

8

@harshCIPL22,

Please try our latest version/fix: Aspose.Cells for .NET v20.1.7 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.1.7 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells20.1.7 For .Net4.0.Zip (5.0 MB)

9

The issues you have found earlier (filed as CELLSNET-47135) have been fixed in Aspose.Cells for .NET v20.2. This message was posted using Bugs notification tool by Amjad_Sahi