Export Formulas in Excel

Aspose.Cells Product Family
1

I’m looking for a product that will allow me to take the output of a report and export it to Excel, but rather than provide the summarized values, provide a formula.
For example, A1 = Salary , A2 = Rate, A3 = A1+A2. I’d want to see the numbers for A1 and A2, but see the formula for A3
I thought your product could do it, but in trying out the examples on your demo website, I’m getting summarized numbers, not excel formulas.

2

Hi,

Thanks for your inquiry.

We will get back to you soon.

Thank you.

3

Hi,


Thanks for considering Aspose.Cells for Reporting Services.

Currently, Aspose.Cells for Reporting Services only supports exporting Excel formulas as per the following conditions.

1) The report should be designed by the Aspose.Cells.ReportingServices Client tool in MS Excel.

2) The cells position for the Formulas should not be mentioned in the range of table report item.



Thanks for your understanding!