Get all selected cells in google script

Question

I am using the following code to get selected cells:

var activeRange = SpreadsheetApp.getActiveRange().getA1Notation();

If I select cells B1, B2, B3 it returns "B1:B3". But if I select B1 and then use the Ctrl key to also select B3 it returns only "B3". I want "B1,B3". I couldn't find a function for this in the documentation.

Answer 1

  var range = '';
  var sel = SpreadsheetApp.getActive().getSelection().getActiveRangeList().getRanges();
  for(var i = 0; i < sel.length; i++){
    range += sel[i].getA1Notation() + ', ';
  }
  Logger.log(range);

Logs: [18-06-21 22:18:16:866 EEST] B1, B3,

Answer 2

Apps Script currently does not provide support for handling disjoint ranges within Range objects. What will happen is that the last selected sub-range will be returned by calls of getActiveRange(), etc. It is filed here as issue 4069. You may want to 'star' it.