Aspose Cell & Excel2007 Export & Tool tip with user name issue

Aspose.Cells Product Family
1

Hi,
We have a report with tool tip and after exporting this report, we are seeing the tool tip in the exported excel file and it is good. But we don't want to see the message saying "Cell Commented by User Name" at the status bar. Please see the attached image for details and help us to solve this issue.
Thanks
Dexter

2

Hi Dexter,


Thank you for using Aspose.Cells.

You can use the Author property of the Comment object to hide the author name. e.g. setting this field to empty will hide the user name.

comment.Author = “”;



3

Hi Kashif,
Thanks for quick answer.
I am using SQL Reporting Service 2008 for my reports and I am not sure which place in reports to put this comment.Author = ""; settings
Thank for the help.
Dexter

4

Hi,

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

Please try the latest version: Aspose.Cells for Reporting Services 1.8.0.35 (SSRS2008).

And let us know your feedback.

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

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

If the problem still occurs, please provide us your RDL file and the xlsx rendering.

We have also logged your issue in our database. Development team will look into your issue and give you advice.

Once, there is some update for you, we will let you know asap.

This issue has been logged as SSRS-40043.

5

Hello Shakeel,
I have tried with the new dll and it didn’t work.
I am attaching the rdl and excel export for review.
We are using the Credentials stored securely in the report server for Data Source settings and we are seeing the same User name in comments by part in Excel report.
Thanks for the help.
Dexter

6

Hi,

Thanks for your feedback and providing us the needed files.

We will look into your issue and update you asap.

We have also logged your comments and files against the issue id: SSRS-40043.

7

Hi,

We have checked your provided files and fixed the issues.

Please try the fixed version: Aspose.Cells for Reporting Services v1.8.0.44(SSRS2008R2).

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

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

8

Great! It fixed the issue.

Thanks lots for the help.
Dexter
9

Hi,

Thanks for your feedback.

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

If you face any other problem, please feel free to post, we will help you asap.

Have a nice day.