OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

getRange return the word "info" instead of real value

  • Thread starter Thread starter franko_camron
  • Start date Start date
F

franko_camron

Guest
I have a spreadsheet which values comes from an importRange built-in function, the thing is that the getRange function is not fetching the right values, regardless the ROW, COLUMN selected, it returns the word "info" all the time except for Row Column 1,1 (or A1), it returns #Error.

it is weird right? I dunno what am I doing wrong, hope you can help, it is driving me crazy, here is my test function

Code:
function TestFunction()
{
   var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("OTs");
   Logger.log(ss.getRange(14,5).getValue().toString());
 }

and in the image is the data in that spreadsheet, very simple table

here is the results in the console:



<p>I have a spreadsheet which values comes from an importRange built-in function, the thing is that the getRange function is not fetching the right values, regardless the ROW, COLUMN selected, it returns the word "<strong>info</strong>" all the time except for Row Column 1,1 (or A1), it returns <strong>#Error</strong>.</p>
<p>it is weird right? I dunno what am I doing wrong, hope you can help, it is driving me crazy, here is my test function</p>
<pre><code>function TestFunction()
{
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("OTs");
Logger.log(ss.getRange(14,5).getValue().toString());
}
</code></pre>
<p>and in the image is the data in that spreadsheet,
<a href="https://i.sstatic.net/kEqaJqTb.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/kEqaJqTb.png" alt="very simple table" /></a></p>
<p>here is the results in the console:</p>
<p><a href="https://i.sstatic.net/WxusFZAw.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/WxusFZAw.png" alt=" " /></a></p>
 

Latest posts

A
Replies
0
Views
1
Alfredo Augusto Petri
A
Top