Upgrade to Aspose.Cells 21.4.0 throws null pointer exception on worksheet.Cells.ConvertStringToNumericValue()

Aspose.Cells Product Family
,
1

Dear all
we updated Aspose.Cells from 21.2.0 to 21.4.0 and one of our unit tests failed after the update. After creating and filling a document we got a null point exception on worksheet.Cells.ConvertStringToNumericValue()

Is this a known issue? Is there any advise available?

Beste regards

Marc

1 Like
2

@thomae,
You may please share a sample runnable console application along with the template file(s) that can be compiled and executed without any missing reference for our testing. We will reproduce the issue here and share our feedback accordingly.

3

Same problem, have you solved?

4

hi, this my test xlsx file, and the code is like follow:

var path = @"E:\Desktop\bug.xlsx";
Workbook workbook = new Workbook(path);
workbook.Worksheets["sheet1"].Cells.ConvertStringToNumericValue();
workbook.Save(path);

bug.zip (460.2 KB)

My Environment is as follows:

  • Windows10 20H2
  • .NET Framework 4.6.2
  • Aspose.Cells Version: 21.5.0
5

No I could not solve the problem. I downgraded

6

@thomae,
We have logged the issue as “CELLSNET-48147” in our database for investigations. Once we will have some news for you, we will update you in this topic.

7

@Cesaryuan, @thomae,

Please try our latest version/fix: Aspose.Cells for .NET v21.5.6.
Aspose.Cells21.5.6 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.5.6 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.5.6 For .NetStandard20.Zip (5.5 MB)

We have tested using the above fix and it works fine and we do not find such an issue.

Let us know your feedback.

8

With Version 21.6.0 this issue is fixed

9

@thomae,
We are glad to know that your issue is resolved. Feel free to write us back if you have any other query related to Aspose.Cells.

10

Hi,
Please find below my sample project for Grouping:
Examples.zip (5.6 MB)
Please find below input, output and expected files:
ExcelFiles.zip (21.0 KB)
When I expand level 1 group, all underlying groups are getting expanded as shown below.
image.jpg (182.1 KB)
Expected behavior is not to expand underlying groups as shown below:
image.png (134.0 KB)

Regards,
Sailaja

11

@sjasthi
Please set worksheet.Outline.SummaryRowBelow = false; before grouping rows as the following:
worksheet.Outline.SummaryRowBelow = false;
worksheet.Cells.GroupRows(5, 7, true);
worksheet.Cells.GroupRows(9, 14, true);

        worksheet.Cells.GroupRows(6, 7, true);
        worksheet.Cells.GroupRows(10, 12, true);

        worksheet.Cells.GroupRows(12, 12, true);
12

Yes. Setting SummaryRowBelow property prior to GroupRows has resolved the issue.

Thank you for the quick response and help.

Regards,
Sailaja

13

@sjasthi,

Good to know that the suggested line of code (before grouping rows) figures out your issue. In the event of further queries or issue, feel free to write us back.