Problems rendering "Colored" Cells after exporting to Spreadsheet

Aspose.Cells Product Family
1

Our team is using SSRS - Matrix to formulate reports with multiple cells reflected with different colors based on calculations. However, when we export to: Excel 2007xlsx via Aspose Cells, and XLS Excel Workbook via Aspose Cells - the report converts all the cells to "red." Is there anyway to resolve this?

FYI - When we test this scenario using Export to PDF via Aspose - works successfully. When we export to PPT Aspose Slides works great except for the watermark issue with Slides version 4.0.

2

Hi,

Please update performance configuration in Aspose.Cells.ReportingServices.xml file.

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



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



<AutoRowFit value=“True”/>

<SetStyle value=“False”/>

<Merged value=“True”/>

<ConditionalFormatting value=“True”/>




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

If you still face the issues, please post your report define file here.
3

Shakeel, I do not see an Aspose Cells Report Services XML file - any suggestions?

4

Hi,

Please try to locate it at this folder:
${SQL Reporting Services}\Reporting Services\ReportServer\bin

Or try searching it using *.xml

5

Hi,

How did you install Aspose.Cells for Reporting Services?

Please try finding Aspose.Cells.ReportingServices.xml file in following folder:

${Aspose.Cells for Reporting Services installation folder}.

If you could not find, then please download and try the latest version:
Aspose.Cells
for Reporting Services v1.8.0.12 (MSI)

6

Shakeel - we were able to use the performance code listed above for the configuration xml file - but the multiple excel cells still show as one color.

7

Hi,

Please download and try the fixed version: Aspose.Cells for Reporting Services V1.8.0.13 .

Please uninstall the previous version, deleted all dll’s and re-install it, it should work fine then.

Please let me know your feedback.