I can't fetch the correct number from a swedish Google sheet

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

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.

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

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];
    }
}

How did that work out for you?

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

This CodePen shows all four Pie charts:

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

Thank You! It works & looks beautiful :)
/ Magnus