How to trigger a save of all the data in a spreadsheet

Spreadsheet
#1

Hi,

I have implemented your spreadsheet in a web site, and it works brilliantly for saving each value as you move focus from cell to cell. However, I have a requirement to add a button that triggers a save of the full spreadsheet, but I can’t seem to find a way to do this.

I tried looking at save_send_query(), but it seems engineered to only save the active cell.

I am using the latest spreadsheet version. Any help would be greatly appreciated.

Many thanks,

Scott

#2

Hi,
you should modify method save() to prevent sending data immediately:

	// start timer after which request will be sent
	send: function() {
		// do nothing
	},

now to send all data at once you should call:

dhx_sh.send_save_query();