Keep Formula's after export

Aspose.Cells Product Family
1

We have one req. that we need to understand if your product can handle.

1) We have an SSRS report with values and at the bottom with a summation.

2) We need to export the report to xls where the formula for the total at the bottom will remain.

3) So the user can then modify the values above the summation and the total change.

Is this possible with your product. If so please provide instructions on best way to handle the requirement.

2

Hi,

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

Aspose.Cells for Reporting Services exports your RDL into XLS/XLSX/ODS and various other formats. However, we are not sure if you can control or export formulas with your RDL reports in XLS/XLSX/ODS formats.

We will investigate your requirement and let you know if you can achieve your desired output using Aspose.Cells for Reporting Services.

3

Thank you for your response. However its important for us to know the answer to the question, can you please provide the timing of your answer.

"There are two types of formulas that users can make use of: one is Reporting Services formulas and the other is Microsoft Excel dynamic formula provided by Aspose.Cells for Reporting Services.

Using Reporting Services formulas in Aspose.Cells.Report.Designer is exactly the same as applying formulas in Visual Studio. Users can set Reporting Services formulas based on the values of cells in report template, the formulas will be calculated and the calculation results will be sent back to cells at rendering time.

Comparing it with Reporting Services formulas, MS Excel dynamic formulas are not calculated but instead converted to a real Microsoft Excel formula dependent on certain rules and regulations and then sent back to cells at rendering time."

From the link: http://www.aspose.com/reporting-services/excel-component.aspx

4

Hi,

Thanks for considering Aspose.Cells for Reporting Services.

You may try Aspose.Cells for Reporting Service Report Designer to create report definition file in excel.

Please read user guide ( User Guide|Documentation ) on Aspose.Cells for Reporting Services Online documention.

You may create a report which includes summation table by excel.

If you need export excel report which includes a summation formula, you may set a sum formula of excel.

Please reference following example and Book1.rdl (attached).

&=Sum(TestDSET.numbers) → =SUM(E3:E3)

Please also see the attached images.

5

Thank you for the reply.


Can you provide a link to the designer, I do not see it in the download package.

6

Hi,

Thanks for your posting and considering Aspose.Cells.

Aspose.Cells.Report.Designer (client). This is a report designer tool that is integrated with MS Excel in Add-Ins. form. With Aspose.Cells.Report.Designer users can design a report template in MS Excel instead of Visual Studio. The report template is then embedded into Reporting Services RDL file and can be published to Report Server. Users can also preview and export the report in Aspose.Cells.Report.Designer.

If you install MSI or extract its contents, then you will get a folder Addin, it contains three files. Please install them.

I have attached the screenshot for your reference.