I can't fetch the correct number from a swedish Google sheet
Posted by Magnus at 01:52 on Saturday 19th February 2022[link]
Hi, I'm fetching numbers from a GoogleSheet with swedish/european formating. This formating include thousands delimiter with a space. RGraph.pie interpret 1 000 as 1.000 making the charts erroneous.
Is there anything to be done?
Posted by Richard at 09:49 on Saturday 19th February 2022[link]
You'll need to do a little post-processing on the data of your own.
So you can loop through the data that you fetch from the Sheet doing this (within the Sheets callback function):
That will remove all space characters from the numbers.
Posted by Magnus at 02:37 on Sunday 20th February 2022[link]
Thanks for Your response, I?m a tottal noob regarding JS so I hope I can get some more help. I use this code:
var data = sheet.get('J23:J27');
var labels = sheet.get('I23:I26');
var row = sheet.get('J23:J27');