Why Class Range Getvalues Sometimes Returns [[]] When Chained To Class Sheet Getactiverange?

Tl;Dr. Is a good practice chaining getValues() to Class Sheet getActiveRange() ? What could cause that sometimes returns [[]] instead of the expected values? NOTE: [[]] is what is

Solution 1:

So far my conclusion based on the comments to the question and on the related questions that used chaining and the answers uses equivalent code but that doesn't use chaining I think that is safer to avoid the use of chaining with "active" methods.

By active methods I mean

• Class Spreadsheet getActiveSheet()
• Class Spreadsheet and Class Sheet getActiveRange()

Related chat rooms

• chat created by me
• chat created by Oleg Valter
• chat created by a ♦ mod.