Grid getvalue with &nbsp

1

I have set a decimal value into a grid column,

grid1.setvalue(0,0,"100")

however when i get the value later, it has a   follow with 100

console.log(grid1.getvalue(0,0)) 'return two value 100 and  

Any idea?

Thanks
Teo

2

Does this work?

console.log(grid1.getvalue(0,0).trim())
3

I found the problem due to additional blank row is added at last row.
thus, the value return always has   in the list

for u=0 to grid1.getRowCount() - 1
    if grid1.getvalue(u,0)<>"" then amt=amt + grid1.getvalue(u,2)
next
console.log(amt)

Thanks
Teo

4

trim() should get rid of that too.