Unable to retrieve single value from array of values

up vote
0
down vote

favorite

I'm trying to retrieve a value to do a String comparison test and I can't seem to retrieve the single value from an array of values. Here's my code:

function CoverageCalculator() {

  var sheet = SpreadsheetApp.getActiveSheet();



  var searchRange = sheet.getRange('D3:D20')

  var rangeValues = searchRange.getValues();



  var Test = searchRange[1][1];

}

In debug mode, "Test" is undefined, any ideas on why this might be the case?

edited Nov 22 at 19:01

Rubén

9,93043265

asked Nov 22 at 16:20

Nicholas Besse

2

Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47

add a comment |

up vote
0
down vote

favorite

I'm trying to retrieve a value to do a String comparison test and I can't seem to retrieve the single value from an array of values. Here's my code:

function CoverageCalculator() {

  var sheet = SpreadsheetApp.getActiveSheet();



  var searchRange = sheet.getRange('D3:D20')

  var rangeValues = searchRange.getValues();



  var Test = searchRange[1][1];

}

In debug mode, "Test" is undefined, any ideas on why this might be the case?

edited Nov 22 at 19:01

Rubén

9,93043265

asked Nov 22 at 16:20

Nicholas Besse

2

Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47

add a comment |

up vote
0
down vote

favorite

I'm trying to retrieve a value to do a String comparison test and I can't seem to retrieve the single value from an array of values. Here's my code:

function CoverageCalculator() {

  var sheet = SpreadsheetApp.getActiveSheet();



  var searchRange = sheet.getRange('D3:D20')

  var rangeValues = searchRange.getValues();



  var Test = searchRange[1][1];

}

In debug mode, "Test" is undefined, any ideas on why this might be the case?

edited Nov 22 at 19:01

Rubén

9,93043265

asked Nov 22 at 16:20

Nicholas Besse

I'm trying to retrieve a value to do a String comparison test and I can't seem to retrieve the single value from an array of values. Here's my code:

function CoverageCalculator() {

  var sheet = SpreadsheetApp.getActiveSheet();



  var searchRange = sheet.getRange('D3:D20')

  var rangeValues = searchRange.getValues();



  var Test = searchRange[1][1];

}

In debug mode, "Test" is undefined, any ideas on why this might be the case?

google-apps-script google-sheets

edited Nov 22 at 19:01

Rubén

9,93043265

asked Nov 22 at 16:20

Nicholas Besse

edited Nov 22 at 19:01

Rubén

9,93043265

asked Nov 22 at 16:20

Nicholas Besse

edited Nov 22 at 19:01

Rubén

9,93043265

edited Nov 22 at 19:01

Rubén

9,93043265

edited Nov 22 at 19:01

Rubén

9,93043265

asked Nov 22 at 16:20

Nicholas Besse

asked Nov 22 at 16:20

Nicholas Besse

asked Nov 22 at 16:20

Nicholas Besse

2

Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47

add a comment |

2

Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47

Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47

add a comment |

1 Answer
1

active

oldest

votes

up vote
1
down vote

accepted

Change

var Test = searchRange[1][1];

var Test = rangeValues[1][0];

The above because searchRange is a Range object, not an array, but rangeValues it's. Regarding the indexes, the first one determines the row, and the second the column and considering that the source range is D3:D20 the resulting array has 17 rows high and 1 column width, then the maximum valid index for the second index is 0.

edited Nov 22 at 21:34

answered Nov 22 at 19:03

Rubén

9,93043265

Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50

Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52

@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53434918%2funable-to-retrieve-single-value-from-array-of-values%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
1
down vote

accepted

Change

var Test = searchRange[1][1];

var Test = rangeValues[1][0];

edited Nov 22 at 21:34

answered Nov 22 at 19:03

Rubén

9,93043265

Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50

Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52

@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34

add a comment |

up vote
1
down vote

accepted

Change

var Test = searchRange[1][1];

var Test = rangeValues[1][0];

edited Nov 22 at 21:34

answered Nov 22 at 19:03

Rubén

9,93043265

Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50

Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52

@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34

add a comment |

up vote
1
down vote

accepted

Change

var Test = searchRange[1][1];

var Test = rangeValues[1][0];

edited Nov 22 at 21:34

answered Nov 22 at 19:03

Rubén

9,93043265

Change

var Test = searchRange[1][1];

var Test = rangeValues[1][0];

edited Nov 22 at 21:34

answered Nov 22 at 19:03

Rubén

9,93043265

edited Nov 22 at 21:34

answered Nov 22 at 19:03

Rubén

9,93043265

answered Nov 22 at 19:03

Rubén

9,93043265

answered Nov 22 at 19:03

Rubén

9,93043265

Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50

Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52

@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34

add a comment |

Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50

Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52

@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34

Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50

Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52

@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Qfyilyi