Formatting issues with new version of Aspose

Aspose.Cells Product Family
1

Hi,


We have recently updated aspose.cell from 7.5.2.0 to 8.2.2.0. We are seeing lots of issue with new version.

We generate excel sheet and then merge into a single file. We had some cell’s which refers across to different sheet and after merging the sheets we were getting populated with proper data. But with new version with same code we are getting “#Ref!”.

Code base is same, we are getting issue only after the update. Tried “CalculateFormula();” but still showing reference error.

We have seen other issues with new updates like:
http://www.aspose.com/community/forums/588933/height-specified-is-not-reflecting-in-excel-sheet-created-using-aspose/showthread.aspx#588933

Thanks,
Aniket

2

Hi Aniket,


I am afraid, it is hard to detect what could have gone wrong unless you provide us your source code (preferably an executable sample application) along with input spreadsheet (if any). It is best that the sample application covers your complete scenario so that we are able to isolate the problem cause.

Before you move forward to provide the above requested, please give the scenario another try with latest version of Aspose.Cells for .NET (Latest Version) , just to see if it makes any difference.

Thank you for your cooperation & understanding.

3

Hi,


Please find the two input file (ip1.xlsx and ip2.xml) attached with the mail.

Below is the code to generate output file:
Workbook excelReportWorkbook = new Workbook(FileFormatType.Xlsx);
Worksheet workSheet1 = new Workbook(@“C:\ip1.xlsx”).Worksheets[0];
Worksheet workSheet2 = new Workbook(@“C:\ip2.xml”).Worksheets[0];

excelReportWorkbook.Worksheets[0].Copy(workSheet1);
excelReportWorkbook.Worksheets[0].Name = “Test1”;

excelReportWorkbook.Worksheets.Add();
excelReportWorkbook.Worksheets[1].Copy(workSheet2);
excelReportWorkbook.Worksheets[1].Name = “Test2”;

excelReportWorkbook.CalculateFormula();
excelReportWorkbook.Save(@“C:\op.xlsx”);

Also attached files generated using 7.5.2.0 and 8.2.2.0 version. Deference will be clearly seen in second sheet were 7.5.2.0 is giving correct output while new version is giving ref error.

Please let me know when I can expect a fix for the issue. Thanks.

Regards,
Aniket
4

Hi Aniket,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing your sample code with your source Excel files using the latest version: Aspose.Cells for .NET (Latest Version) . CalculateFormula() is causing Reference Error.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43200 - CalculateFormula() is causing Reference Error

5

Hi,


Can you provide a timeline on when this issue will be resolved?

Will it be a part of v8.3.0.3 release as we are expecting a fix for another issue CELLSNET-43184?

Regards,
Aniket
6

Hi Aniket,

Thanks for your posting and using Aspose.Cells.

We will try to fix your both issues in our next version. Please spare us some time. Once, we will have some good news for you, we will share it with you asap.

7

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.

8

Hi,


Is there any updates on above issue. New version is breaking out existing functionality and its causing lot of issue. We need the fix urgently for CELLSNET-43184 and CELLSNET-43200.

For CELLSNET-43184 it was communicated that the fix should be available in 3-5 days in 8.3.0.3 version on 1st Dec. Still we have not received any updates.

Please provide a date on when we can expect a new version to be available. Its a big risk for our project if we get a build post 8th Dec. Is there are way we can escalate the issue?

Thanking in anticipation.

Regards,
Aniket
9

Hi Aniket,


Thank you for your patience with us.

Please try the latest version of Aspose.Cells for .NET (Latest Version) against the problem logged under the ticket CELLSNET-43200, and let us know of your feedback. In the meanwhile, we will update you regarding your other ticket (CELLSNET-43184) on its corresponding thread.

10

The issues you have found earlier (filed as CELLSNET-43200) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.