Requirement of the Reporting Services

Aspose.Cells Product Family
1
Hi

I have a requirement
from my SSRS report
need to save excel file to user machine with below option
it has price, quantity and total cost
user should able to only edit quantity column after downloading the report
rest cells should be locked
and if user change the quantity
the cell color should change
and the total cost should calculate after change the quantity
like formula to be needed in excel
is it possible in Aspose ?

This message was posted using Email2Forum by Imran Rafique.
2

Hi Jaison,

Thanks for your posting and considering Aspose.Cells.

Please provide us some sample Excel file showing your output. You can create one using Microsoft Excel and attach it here. It will help us look into this issue and we will let you know if such an output could be achieve with Aspose.Cells for Reporting Services.

Thanks for your cooperation.

3

Hi Shakeel Faiz,

Thanks for your reply.

could you please provide me the email address which i can forward the sample excel file? because i am unable to see the attachment option here.

4

Hi Jaison,

Thanks for your posting and considering Aspose.Cells.

You will see the

File attachment

Add/Update

button, when you will click Reply button not Quick Reply button.

Please note, there are two buttons Reply button which is at the top of the post and Quick Reply link which is at the bottom of the post.

5

Please find the attachment

6

Hi Jaison,

Thanks for your posting and considering Aspose.Cells.

Aspose.Cells for Reporting Services mainly contains two components : Aspose.Cells.Report.Designer and Aspose.Cells.Renderer for Reporting Services.

Aspose.Cells.Renderer for Reporting Services only meets sheet lock in your requirement.

Aspose.Cells for Reporting Services report designer create new report definition file which supports excel feature. But the report only show report data in report server.

Please reference Aspose.Cells for Reporting Services User Guide

( User Guide|Documentation ).