Update spreadsheet without destroying layout

[c0dr.64d1]

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

 

[Stoyan]

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

[c0dr.64d1]

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

[Stoyan]

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