Posted 11 March 2021, 12:34 am EST - Updated 3 October 2022, 12:53 am EST
Dear support,
I’m wondering if it could be possible to introduce a new method which permits the developer to get multiple cells based on a selection.
The getSelections() method permits to return an object like the one within the screenshot:
In order to get the single cells within a selection the approach we have, at the moment, is looping through the columns and rows, fire the getCell() method and eventually concatenate the output into an array for later use.
It would really be helpful to have a method e.g. “getCells()” which based on an object containing the information of a selection (col, row, colCount, rowCount) returns an array of cell instances.
Please let me know if you already have something similar (the current getRange doesn’t fit the purpose)
References:
Documentation of getSelections()
(https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Worksheet~getSelections.html?highlight=getselections%2C)
Documentation of getCell()
(https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Worksheet~getCell.html)
Thanks in advance