How to disable the edit data option of chart (C# .NET)

Rutuja · June 15, 2020, 9:07am

Hi,
I am using aspose licensed version 16.8.0 java. In my project, I have a requirement where I want to disable the edit data option on chart.
Step to reproduce the scenario:

Right click on the chart and click on Edit Data option.
In the excel file, open with the actual chart data.
In my scenario I do not want to show excel sheet values to unauthorized users .
Basically I need the edit data option to be disabled .
Kindly let me know how to achieve this.
Thanks.

mudassir.fayyaz · August 21, 2017, 3:00pm

@Rutuja,

I have observed your requirements and like to share that the requested support for restricting the edit mode for chart is unavailable in Aspose.Slides. Moreover, it is also not possible using PowerPoint as well. If you are able to achieve this using PowerPoint then please share the sample presentation with desired options applied and we shall investigate this on our end to include requested support in Aspose.Slides as well.

Rutuja · August 22, 2017, 6:36am

HI,
Thanks for your reply. However, I have observed that it is possible to achieve this functionality in Microsoft Powerpoint
Steps are:

Open the ppt - click on file
In properties section ->Related Document -> Edit links to file -> Select respective link and then break link.
Kindly reply as soon as possible.
Thanks

mudassir.fayyaz · August 22, 2017, 12:47pm

@Rutuja,

I have observed your comments and regret to share that I am unable to find the suggested option. Can you please provide snapshot describing link to afore mentioned properties and also sample presentation with desired effect. I will discuss that further with our product team to help you out.

ctolap · January 31, 2020, 9:20am

Mudassir,

If we attach an external workbook to a chart pragmatically using SetExternalWorkbook() and then break the link as mentioned by Rutuja in PowerPoint, Edit Data option is disabled.
I could not find a way to break link to files through Aspose.
Please let me know if it is possible.

Thanks

mudassir.fayyaz · February 1, 2020, 5:41am

@ctolap,

I have observed the issue shared by you and request you to please try using latest Aspose.Slides for .NET 20.1 on your end. In case the issue persist, please share working sampler project along with source files and generated output with us.