IssueTracker

Google Sheets Appscipt gives wrong references for getRangeByName when sheet has  case sensitive named ranges

A short description of the issue:


A small code sample that reliably reproduces the issue. The sample should run as-is or with minimal setup, without external dependencies.

            let spreadSheet = SpreadsheetApp.getActiveSpreadsheet();
            let namedRanges = spreadSheet.getNamedRanges();
            for(let range of namedRanges){
                let myRange = spreadSheet.getRangeByName(range.getName());
                console.log("range Name ::" + range.getName() + " refers to ::" + myRange.getA1Notation());
            }


What steps will reproduce the problem?
1. Create tow named ranges with Names Test1 and test1
2. Now run the above code using appscript
3.Observe that the range address pinted belongs to only one and is not correct
4. Check the Name Manager and you see that these named ranges are valid and point to two different ranges.

What is the expected output?
getRangeByName() should give correct range information.



Please provide any additional information below.