Issue with XLSX format

shakeel.faiz · June 11, 2012, 3:29am

Hi,

We had fixed the group function.

Please try fixed version: Aspose.Cells for Reporting Services V1.8.0.30(SSRS2008R2).

And let us know if it works fine.

Aftab.Ansari · June 11, 2012, 8:41am

Hi Team,

I have tried the Aspose.Cells for Reporting Services V1.8.0.30(SSRS2008R2) DLL but I don’t see any of my issue is resolved that I have mentioned in my previous post.

Let me know if you need any additional information.

Thanks,

Aftab Ansari

shakeel.faiz · June 11, 2012, 10:08am

Hi,

Thanks for your posting and using Aspose.Cells for Reporting Services.

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

Could you please provide screenshots that could be helpful in sorting out your issue?

Aftab.Ansari · June 11, 2012, 10:59am

Hi Team,

Please refer attached Report2.xls and Report2.xlsx Sheet1 for following issue description:

· On row2, XLS is showing required values whereas XLSX is showing error

· Row4 is coming under the report header in XLS as expected whereas the same is coming under the report body part in XLSX

Note : I am using ACRS2008R2.V1.8.0.30

Thanks,

Aftab Ansari

amjad.sahi · June 11, 2012, 1:45pm

Hi,

Thanks for the sample files.

We can notice the differences in the XLSX file as you pointed out. We have logged it and we will soon look into your issue.

Thank you.

shakeel.faiz · June 13, 2012, 3:54am

Hi

Row4 is coming under the report header in XLS as expected whereas the same is coming under the report body part in XLSX

We had fixed Freeze header issue.

Please download and try the latest version: Aspose.Cells for Reporting Services V1.8.0.31(SSRS2008R2) and let us know your feedback.

Please copy Aspose.Cells.ReportingServices.dll into following folder :

${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

If your problem still occurs, please provide us your RDL file.

Aftab.Ansari · June 13, 2012, 4:52am

Thanks Team.

I see the mentioned issue is fixed. But i have got another issue.

Issue Description:

· In row2, XLS is showing required values whereas XLSX is showing blank.

Please find required file as an attachment.

Thanks,

Aftab Ansari

shakeel.faiz · June 13, 2012, 4:54am

Hi,

Thanks for your feedback.

We have logged your files and comment in our database against the issue id: SSRS-40035

We will fix the remaining issues and update you asap.

shakeel.faiz · June 15, 2012, 1:07am

Hi,

Please download and try the fixed version: Aspose.Cells for Reporting ServiceV1.8.0.33(SSRS2008R2) and let us know your feedback.

Please copy Aspose.Cells.ReportingServices.dll into following folder :

${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Aftab.Ansari · June 15, 2012, 5:27am

Hi Team,

I have tried the suggested Aspose version and following are the issues I have noticed:

Issue Description:

· See the row-2 values in Sheet1 and Sheet2 in xls and xlsx. In Sheet2, xls has correct value as “Sample Report2” whereas xlsx is showing “Sample Report1”

· Alternate row color is not working XLSX. See Sheet2 table alter row color in xls and xlsx

Please find attached Samples and RDL.

Let me know if you need any additional information.

Thanks,

Aftab Ansari

shakeel.faiz · June 15, 2012, 5:30am

Hi,

Thanks for your feedback.

I have logged your issues and files, we will look into them and fix the problems and get back to you asap.

shakeel.faiz · June 17, 2012, 9:29pm

Hi,

We had checked your provided files and found the issues.

Please try the fixed version: Aspose.Cells for Reporting Services 1.8.0.34 (SSRS2008R2).

And let us know your feedback.

Please copy Aspose.Cells.ReportingServices.dll into following folder :

${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Aftab.Ansari · June 18, 2012, 4:15am

Hi Team,

Please share Aspose DLL of SSRS2008 version too.

Thanks,

Aftab Ansari

shakeel.faiz · June 18, 2012, 4:28am

Hi,

Thanks for your posting.

We will soon share the required dll with you.

Aftab.Ansari · June 18, 2012, 9:04am

Hi Team,

I have pointed 2 issue in my previous post dated 06-15-2012. Out of two issues, one issue has got resolved but still has issue with valid header text data.

Issue Description:

· See the row-2 values in Sheet1 and Sheet2 in xls and xlsx. In Sheet2, xls has correct value as “Sample Report2” whereas xlsx is showing “Sample Report1”

Please find attached Samples and RDL for your reference.

Let me know if you need any additional information.

Thanks,

Aftab Ansari

amjad.sahi · June 18, 2012, 1:08pm

Hi,

Thanks for your feedback with sample files.

We have logged it and we will look into it as well. Your existing issue SSRS-40035 is reopened again.

Thank you.

shakeel.faiz · June 19, 2012, 12:54am

Hi,

We had checked your provided files and found the issues.

Please try the following fixed version

Aspose.Cells for Reporting Services v1.8.0.35 (SSRS2008)

Aspose.Cells for Reporting Services v1.8.0.35 (SSRS2008R2)

And let us know your feedback.

Aftab.Ansari · June 20, 2012, 10:36am

Thanks Team.

DLL Version “Aspose.Cells for Reporting Services 1.8.0.35” has fixed our issue.

Thanks,

Aftab Ansari

kashif.iqbal · June 20, 2012, 11:27am

Hi,

It’s good to know that your issue has been resolved now. Feel free to contact us in case you have any additional query.

Aftab.Ansari · June 25, 2012, 5:27am

Hi Team,

I am getting column merging issues in Aspose XLSX file whereas there is no issue with XLS. Please take a look into attached Report3.xlsx and Report3.xls for Column A and B.

Please find attached file for reference.

Note: I am using “Aspose.Cells for Reporting Services 1.8.0.35 (SSRS2008)”

Thanks,

Aftab Ansari