getChangeColumnsSettings (wbk, columns);
wbk. Sets workbook value.
columns. Sets columns.
The getChangeColumnsSettings method returns body of a request to edit workbook columns.
To execute the example, the page must contain the WorkbookBox component named workbookBox (see Example of Creating the WorkbookBox Component), and the following code must be added in the document opening event handler:
var changeColumnsSettingsButt = new PP.Ui.Button({ ParentNode: document.body, //DOM parent node Content: "Change Column Parameters", //text Click: PP.Delegate(onClickgetChangeColumnsSettings) }); function onClickgetChangeColumnsSettings() { var source = workbookBox.getSource();//Return an instance of the PP.TS.WbkDocument class var columns = wbk.getWbkMetadata().columns; //Change text in the column header columns.its.it[0].customTitle = 'Column changed'; //Change workbook columns var body = tsService.getChangeColumnsSettings(wbk, columns); wbk.setIsChanged(True); tsService._invokeRemoteProc(wbk, body, PP.Delegate(onColumnsChanged, this)); //changeColumns function execution end event handler function onColumnsChanged(sender, args){ //Refresh the workbookBox component workbookBox.refreshAll(); } }
After executing the example a button named Change Column Parameters is placed in HTML page. Clicking this button sets the Column Changed header for the column with the index 0.
See also: