google apps script - Converting float to int not working -


i pulling numbers sheet , comparing them user selection via html. though numbers in google sheet int type numbers such 1001, 1002 et cetera numbers in logger.log show floats. when trying compare numbers against user input comes false comparing float (from sheet) int (from user).

i've tried converting returned float int using parsteint, math.floor , round. doesnt seem convert variable. there method should using?

i kind of issue , use 2 workarounds : script have store value in property when call property text , not number, double number not issue calculation. :

var prop = propertiesservice.getuserproperties(); var number = parseint(prop.getproperty('property_name')); //do stuffs after 

fo script had little bit more dirty, because property example "8.0" instead of "8". :

var prop = propertiesservice.getuserproperties(); var value = prop.getproperty('property_name'); var number = number.split(".")[0]; 

at end works.

stéphane


Comments