Grid getvalue vs innerText with '&'

1

I have a Grid cell that contains “Oil & Filters”

LogGrid:" & LogGrid.getValue(ssRowSelected + 2,1)

will return 'Oil & Filters' but

document.getElementById("LogGrid_" & (ssRowSelected + 2) & "_1").parentElement.innerText

will return "Oil & Filters"

This expected?

2

Yes. One is returning the innerHTML, the other is getting innerText. (& is html for &)

3

I always thought Grid.getValue() returned the text from a cell as it is displayed. Is getting the innerText or textContent a more reliable way of ensuring your code is getting the right info going forward or is .getvalue with some processing better?

4

getValue() does return what is actually in the cell, without being treated as HTML.