ForeColor expression issue

Hi Team,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I am getting a formatting issue in Aspose XLSX. Forecolor expression is not working for Aspose XLSX format.

Take a look into forecolor in column-D in attached MS excel and aspose excel samples.

Thanks,

Aftab

Hi,


Thanks for the sample files.

I have logged a ticket with an id: SSRS-40061. We will look into your issue soon.

By the way, Could you try installing our latest fix using its MSI installer if it makes any difference:
Aspose.Cells for Reporting Services v1.8.0.58 (MSI)


Thank you.

Thanks for your response.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I have tried the latest version “Aspose.Cells for Reporting Services v1.8.0.58 (MSI)” but issue persist.

Thanks,

Aftab

Hi,


Thanks for your feedback.

We will look into your issue and figure it out soon.

Thank you.

Hi,

Thanks for considering Aspose.Cells for Reporting Services.

Please refer to the following context to update the value of set style in Aspose.Cells.ReportingServices.xml file.

<Performance value=“ON” IsAutoRowFit =“True” IsMerged=“True” IsSetStyle=“False” IsConditionalFormatting =“False”>








If you still face any issue, please post report define (RDL) file here.

We will check it ASAP.

Where will i get the "AsposeCells.ReportingServices.xml" file?

Thanks,

Aftab

Hi,

Well, we meant, "Aspose.Cells.ReportingServices.xml" file, the file should be there in the installation folder(s) for Aspose.Cells for Reporting Services, e.g ".../Aspose/Aspose.Cells for Reporting Services/".


Hi,

Thanks for your posting and using Aspose.Cells for .NET.

You will find Aspose.Cells.ReportingServices.xml inside the installation folder.

Thanks team.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Your suggested change has resolved our issue.

Thanks,

Aftab

Hi,

Thanks for your feedback.

It’s good to know that your issue is now resolved.

If you have any other question or you face some other issue relating to Aspose.Cells family products, please feel free to post on our forums.

We will be glad to help you.

Hi Team,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

After setting IsSetStyle="False" in Aspose.Cells.ReportingServices.xml file as you have suggested in your above post, we are getting required forecolor formatting for our reports. But this change has opened another issue.

Issue Description

If we export any report output having ~5 Lacs or above records in Aspose XLSX fromat then we are getting timeout issue. we are able to export the same output if we rollback the XML file change (set to IsSetStyle="True")

Let me know if you need any additional details.

Thanks,

Aftab

Hi,

Aftab.Ansari:


Issue Description

If we export any report output having ~5 Lacs or above records in Aspose XLSX fromat then we are getting timeout issue. we are able to export the same output if we rollback the XML file change (set to IsSetStyle="True")


Setting IsSetStyle="False" may effect performance if you are rendering huge list of records in the worksheet. Anyways, we have logged it and we will surely look into it soon. Once we have any update on it, we will let you know here.


Thank you.

Hi,

We have found the issues and fixed them.

Please download and try the fixed version: Aspose.Cells for Reporting Services v1.8.0.62 (SSRS2008).

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

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

And refer to following content to update the value of set style in AsposeCells.ReportingServices.xml file.

==================================

<Performance value=“ON” IsAutoRowFit =“True” IsMerged=“True” IsSetStyle=“True” IsConditionalFormatting =“False”>








==================================

Let us know your run results.

Hi Team,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

After using latest DLL and xml file changes, our issue has been resolved.

Thanks for the great work.

Thanks,

Aftab

Hi,

Thanks for your feedback.

It’s good to know that your issue is resolved with latest fix and xml changes.

Let us know if you face any other issue, we will be glad to assist you further.

Please share Aspose.Cells for Reporting Services v1.8.0.62 or latest for SSRS2008R2. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thanks,

Aftab

Hi,

Please download the latest SSRS2008R2 version: Aspose.Cells for Reporting Services v1.8.0.64 (SSRS2008R2)

Thank you, Team.

Hi,

Thanks for using Aspose.Cells for Reporting Services.

You are welcome.

Let us know if you face any other issue, we will be happy to help you further.

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


This message was posted using Notification2Forum from Downloads module by aspose.notifier.