This is a migrated thread and some comments may be shown as answers.

Update spreadsheet without destroying layout

3 Answers 17 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
c0dr.64d1
Top achievements
Rank 1
Veteran
c0dr.64d1 asked on 31 Jan 2021, 05:07 PM

Hello Experts,

Is there a way to update the data rows and columns of a sheet after a read on the dataSource's model without it destroying the layout of the entire page?

 

Many thanks in advance

64d1

 

3 Answers, 1 is accepted

Sort by
0
Stoyan
Telerik team
answered on 02 Feb 2021, 02:31 PM

Hello,

Can you elaborate more on what you mean by "without it destroying the layout of the entire page" as I am not sure I understand what you mean. Generally speaking, when binding the Spreadsheet to a DataSource there are some known limitations, namely cell styles, formulas, and formats are not persisted in the data source.

That being said, please consider providing more details about your scenario. If you are experiencing an unexpected behavior I will appreciate providing a sample application or a runnable Dojo example. This will allow me to observe the issue and provide a more accurate suggestion.

Looking forward to your reply.

Regards,
Stoyan
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
c0dr.64d1
Top achievements
Rank 1
Veteran
answered on 06 Feb 2021, 12:18 PM

Sure,

What happens is that I make an ajax call to an API and on success the result gets passed to options.success(result); .

When that happens the results get pasted into the spreadsheet starting at row1, column 1...but I want to start it much further down because I have other things like headers and custom editors in those first few rows and it's writing over the top of what's already there. I'd post pics and code but it's sensitive data.  For the time being i'm simply calling my own function to format things, but i'd like to know more about how to handle options.success.

many thanks

64d1

0
Stoyan
Telerik team
answered on 10 Feb 2021, 02:53 PM

Hi, 64d1,
Thank you for providing details about the scenario.

To format the headers or footers of the response in the dataSource, handle the requestEnd event, as explained in this Knowledge Base article. Please note the approach is not applicable with the Create, Update and Destroy methods of the transport. These scenarios do not support the insertion of custom header or footer.

This is a Dojo example that applies the above to the Spreadsheet's dataSource binding Demo.

Hopefully, this is useful in your scenario.

Regards,
Stoyan
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Spreadsheet
Asked by
c0dr.64d1
Top achievements
Rank 1
Veteran
Answers by
Stoyan
Telerik team
c0dr.64d1
Top achievements
Rank 1
Veteran
Share this question
or