Is there a way to call the Telerik 'insert chart' dialog for a RadSpreadsheet?
I don't want to include the whole ribbon bar, as it has lots of options which would make a mess of my data if a user tried to use it, but I'd REALLY like to let them to be able to add charts.
Otherwise, ss I had to do with the find/replace dialog, I'll have to replciate your UI, which is silly.
3 Answers, 1 is accepted
Hello Ian,
You can work with charts programmatically as well. For more information about the available API, refer to the documentation of the library used as a model of RadSpreadsheet - RadSpreadProcessing: Charts API.
Regards,
Dinko | Tech Support Engineer
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.
Rank 2
Bronze
Iron
Iron
Thanks Dinko,
I had already seen the API which lets me use all of the charting function: I guess I'm looking for something a lot closer to the default charting experience which the user gets from using the ribbon bar.
As described elsewhere, I can't use the default ribbon bar because (1) its really slow and (2) i need to remove lots of function which I can't let users use and (3) I have lots of specialised stuff I need to add.
This is why I want to use your 'insert chart' dialog.
Is this possible via the API?
Hello Ian,
If I have correctly understood your question, you want to start the insert chart dialog from code. In this case, you can execute the InserChart command. This way you can execute the command on a separate button click and you will need to use the ribbon. Let me know if this is what you are looking for.
this.radSpreadsheet1.SpreadsheetElement.CommandDescriptors.InsertChart.Command.Execute(null);As a side note, each option in the RadSpreadsheetRibbonBar is exposed via property. You can hide each of the buttons depending on your case.
Regards,
Dinko | Tech Support Engineer
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.
Rank 2
Bronze
Iron
Iron
Ah - that looks excellent -I'll give it a try.
As for disabling buttons on the Ribbon Bar, do you know it this improves the performance, if I disable lots of options?
I hope the suggested code will work for you. As for the spreadsheet ribbon bar, disabling the buttons won't take a role in the performance. The internal logic of binding the commands will still be executed.