Google Script: Can not sort a range with getRangeByName

Question

I need order by alphabet a list in a range by name, but for some reason fail in some point and give me a "The cell reference is out of range." in line var tmp_range = raw_range.sort( 1 );

The weird think is in the first call seems to work but with the sencond call (with other range name) fail.

function getValuesOfRange( range_name ){
  var raw_range = SpreadsheetApp.getActiveSpreadsheet().getRangeByName( range_name );
  Logger.log( raw_range );
  if ( raw_range != null ){
    Logger.log( range_name );
    var tmp_range = raw_range.sort( 1 );
  }
  ...
}

Hari Das · Accepted Answer · 2016-08-29 15:27:33Z

1

The most probable cause is you are providing wrong index inside the parameter. The sort function takes different types of argument. Check here

https://developers.google.com/apps-script/reference/spreadsheet/range#sortsortspecobj

// Sorts by the values in the first column (A)
 range.sort(1);

So for example if your named range is from 'Sheet1'!D1:D9 The sorting should be like range.sort(4);

So in your case change raw_range.sort( 1 ) to raw_range.sort( raw_range.getColumn())

edited Aug 29, 2016 at 15:27

answered Aug 29, 2016 at 14:52

Hari Das

11k8 gold badges69 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

inye Over a year ago

Thx. I change raw_range.sort( 1 ) by raw_range.sort( raw_range.getColumn() ) and work perfect. Can you edit your answer with this code to mark as correct answer?

Hari Das Over a year ago

Updated the anwser

Collectives™ on Stack Overflow

Google Script: Can not sort a range with getRangeByName

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related