ONLYOFFICE DocSpace released: improve document collaboration with offices, customers, and partners. Use it for free!
ONLYOFFICE DocSpace released

Select range of filled cells

Hello, i’ve started working with onlyoffice spreadsheets and i was wondering if i could select the range of all the filled cells in the sheet.
I know about the GetCols() and GetRows() functions but that returns the whole row or column

I’d be interested to know if there is a way i can get just the range of filled cells

Hello @edlacer

Unfortunately, at the moment we don’t have a method for multiple ranges, i.e. it is impossible right now to select several cells within multiple ranges.
However, we have created enhancement suggestion to add this method into our internal bug tracker under the number 62297.
It will be added in one of the future releases. Sorry for the inconvenience.