refreshWbk (report, callback);
report. Sets object
callback. Sets handler for operation execution end.
The refreshWbk method refreshes a workbook.
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 wbkDataBox = workbookBox.getDataView();
var setHorizontalButt = new PP.Ui.Button({
ParentNode: document.body, //DOM parent node
Content: "Change Display Mode", //text
Click: PP.Delegate(onClickSetHorizontal)
});
function onClickSetHorizontal(){
//Get a component used to control workbook view position
var modeSelector = wbkDataBox.getModeSelectorView();
//Get metadata of the selected mode change
var pos;
if (wbk.getActiveSheet().getMetadata().windowsPosition == "Horizontal")
{
pos = modeSelector.getModeSelectorState(PP.TS.Ui.ModeSelectorType.Vertical);
}
else
{
pos = modeSelector.getModeSelectorState(PP.TS.Ui.ModeSelectorType.Horizontal);
}
//Get workbook metadata
var md = wbk.getMetadata();
//Set metadata of the selected mode change to workbook metadata
for (var prop in pos){
md[prop] = pos[prop];
}
//Refresh workbook
tsService.refreshWbk(wbk, PP.Delegate(function(){
wbkDataBox.refreshAll();
}));
}
After executing the example the Change Display Mode button is placed in HTML page. Clicking this button changes workbook display mode.
See also: