Excel found unreadable content in XLSX file (Aspose Cells Reporting Services)

Aspose.Cells Product Family
15

Hii,

Thanks the team for the support & extra effort put on this task.

Newer version have solved some of the issues, but still we have some problems in the same rdl. I will send you the details in the attachment.

1. CostReport.rdl - Issues related with table/matrix, in this version also the rows are overlapped. But in the case .xls they have mensioned martix part (cell merging) it as 'Data Regions within table/matrix cells are ignored' . Refer issue.gif in attachment

2. EasyReport.rdl - Duplication is not existing but its not showing any value there. Refer issue1.gif in attachement

16

Hi,


Thanks for providing the details and screen shots.

We have logged it. I have reopened your issue again and we will look into your mentioned issues soon.

thank you.
17

Hi,

1. CostReport.rdl - Issues related with table/matrix, in this version also the rows are overlapped. But in the case .xls they have mensioned martix part (cell merging) it as ‘Data Regions within table/matrix cells are ignored’ . Refer issue.gif in attachment

You provide report define file which name is Cost_Sheet_Report.rdl.

Please post CostReport.rdl here. We will check it ASAP.

2. EasyReport.rdl - Duplication is not existing but its not showing any value there. Refer issue1.gif in attachement


We had fixed the issues.

Please try the fixed version: Aspose.Cells for Reporting Services V1.8.0.38 (SSRS2005).

18

Great Job!!!

Sorry it's 'Cost_Sheet_Report.rdl' itself i mistakely mension it as 'CostReport.rdl'

We still facing issue with EasyReport.rdl, its misplacing the column headers, sub total values missing. Refer issue3.gif for comparision

We have one more rdl with data duplication (NEW ISSUE) TAS- GTnE and RMT Reconciliation Report.rdl , i attaching its rdl & screen shot - Refer issue4.gif for comparion

19

Hi,

Thanks for your feedback.

It’s good to know some of your issues have now been resolved.

We will look into your mentioned issues and fix the problems and update you asap.

Your comments has been logged against the issue id: SSRS-40041

20

Hi,

We had fixed two issues. ( It’s misplacing the column headers and data duplication).

Please try the fixed version: Aspose.Cells for Reporting Services V1.8.0.39 (SSRS2005).

For sub-total values missing issues, we do not view sub-total row when we run the report (EasyReport.rdl).

Please tell us how to display sub-total row.

21

Excellent Work!!!!!!

Data duplication problem is solved..., but misplacing of cloumn header & scattering of data are there again... Refer image issue5.gif

In EasyReport.rdl contain a sub total field (cell) . I have attached rdl again & it screen shot...pls refer image issue6.gif

22

Hi,

That’s great. Thanks for your feedback.

We will look into the remaining issues and fix them and get back to you asap.

Your comments has been logged against the issue id: SSRS-40041

23

Hi,

For issue 5

We had checked and tested Cost Sheet Report. And we found the issue when there is table with no row.

We had fixed the issue.

Please try the fixed version: Aspose.Cells for Reporting Services V1.8.0.40 (SSRS2005).

For issue 6

We had checked and tested your provided report.

But we still could not get sub-total rows. We selected the default excel format and exported excel report file(2003). The report does not export sub-total row too.

Now ,we try to update rendering rule in order to export sub-total row.

Please try the fixed version: Aspose.Cells for Reporting Services V1.8.0.40 (SSRS2005).

Please let us know your run result.

24

Excellent Work!!!!

Thanks a lot, please try to solve the sub total data case also

25

Did we have any new updates on sub total !!!

Its very URGENT we have to move to production within two days, due to this problem we are holding.

26

Hi,

We are working over this issue

I have logged your comments against the issue id: SSRS-40041

Hopefully, your issue will be fixed soon.

27

We are having some new issues with Easy Report, when we take more than one month report there are two more columns are adding into existing report ie Year & Month in such cases again the columns are getting misplaced. Kindly solve this issue in EasyReport.rdl

28

Hi,


It will be better if you could post new issues in separate thread(s) with all the details with RDL file(s) etc. Also provide exported Excel files and screen shots to highlight the problematic areas (encircling with red color), it will help us to figure out your issue more accurately and speedily.

Thank you.
29

Hi,

Please try the fixed version: Aspose.Cells for Reporting Services v1.8.0.41 (SSRS2005)

If you still face the issues, please give us detailed feedback (screenshots will be helpful).

We will check it asap.

30

Thanks for your quick response!!!

Its not a new issue, this issue is assoicated with same EasyReport.rdl which we have reported it earlier & resolved it.

Now in current senerio we try to take report for a period of 4months rather than 1 month, it added two more additional columns (Year & Month) for this report which leads to misplace/scattered data into different columns.

Attached issue7.gif & EaseReport.rdl for reference

31

Hi,

We have found the issues and fixed it.

Please try the fixed version: Aspose.Cells for Reporting Services v1.8.0.42 (SSRS2005)

If you still face the issues, please give us detailed feedback.

We will check it ASAP.

32

Great Job!!!!!! Thanks a lot its works fine!!!

33

Hi,

Thanks for your feedback.

It’s great that your issues are finally resolved. Let us know if you still face any issue, we will help you asap.

34

Hi

PFA the screenshot of the same error happened again . Opening in XLS gives correct header format whereas opening in XLSX gives misaligned headers. Please provide a fix asap as this RDL is facing Production issue due to this.

The attachment contains. ProductionIssue.Zip

1)Screenshot of the error. 2)xls file 3)xlsx file 4)RDL file.

Revert in case of any concern.