getCells();
The getCells method gets array of cell in the given range.
This method returns an array of PP.Ui.TabSheetCell objects.
To execute the example, the HTML page must contain the TabSheet component named tabSheet (see Example of Creating the TabSheet Component). Determine the range B1:B2, select it and add the plus sign + to values of all its cells:
// Determine the range B1:B2
var range = tabSheet.getRange(1, 1, 1, 2);
// Check range validity
var isValid = range.isValid();
if (isValid) {
// Select this range
range.select();
// Get the array of selected range cells
var cells = range.getCells();
for (var i = 0; i < range.getCoordsCount(); i++) {
var cell = cells[i];
// Add the + sign
cell.setValue("+" + cell.CellData.FormattedText);
};
// Refresh table
tabSheet.rerender();
};
After executing the example the range B1:B2 was selected, and the plus sign + was added to values of all its cells:
See also: