I can't fetch the correct number from a swedish Google Sheet - Official support forum | RGraph.net

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?
/Magnus

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):

var row = sheet.get('A1:A7');

for (var i=0; i<row.length; ++i) {
    row[i] = Number(String(row[i]).replace(/\s/, ''));
}

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:
function (sheet)
{
var data = sheet.get('J23:J27');
var labels = sheet.get('I23:I26');
var row = sheet.get('J23:J27');

for (var i=0; i<row.length; ++i) {
row[i] = Number(String(row[i]).replace(/\s/, ''));
}

for (var i=0; i<labels.length; i+=2) {
labels[i] = "\n" + labels[i];
}
but it still will not remove the space characters.
many thanks
/Magnus

Posted by Richard at 10:58 on Sunday 20th February 2022 [link]
Try this:

function (sheet)
{
    var data = sheet.get('J23:J27');
    var labels = sheet.get('I23:I26');

    for (var i=0; i<data.length; ++i) {
        data[i] = Number(String(data[i]).replace(/\s/, ''));
    }

    for (var i=0; i<labels.length; i+=2) {
        labels[i] = "\n" + labels[i];
    }
}

Posted by Richard at 13:27 on Tuesday 22nd February 2022 [link]
How did that work out for you?

Posted by Magnus at 01:45 on Thursday 3rd March 2022 [link]
Still no luck I'm afraid. I have created a minimal test-case if the trouble is something else. Please have a look if possible
the chart - https://dk6awepavhzl7aa5gsaznw-on.drv.tw/Troubleshooting/Troubleshooting.html
the sheet - https://docs.google.com/spreadsheets/d/1TAWiJ7i6kiPt0tSmZK0dy2LqpAZSV_U_mHb9da_DIPE/edit#gid=0

I'm very grateful for any help
/ Magnus

Posted by Richard at 11:30 on Thursday 3rd March 2022 [link]
This CodePen shows all four Pie charts:

https://codepen.io/rgraph/pen/rNYoqPJ?editors=1010

Posted by Magnus at 00:59 on Friday 4th March 2022 [link]
Thank You! It works & looks beautiful :)
/ Magnus

[Replies are now closed]