FIXED: I can't fetch the correct number from a swedish Google sheet - Official support forum

About

RGraph is a JavaScript charts library based on HTML5 SVG and canvas. RGraph is mature (over 15 years old) and has a wealth of features making it an ideal choice to use for showing charts on your website.

Download

Get the latest version of RGraph (version 6.18, 1st June 2024) from the download page. You can read the changelog here. There's also older versions available, minified files and links to cdnjs.com hosted libraries.

License

RGraph can be used for free under the GPL or if that doesn't suit your situation there's an inexpensive (£129) commercial license available.

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

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 - [LINK REMOVED]
the sheet - [LINK REMOVED]

I'm very grateful for any help
/ Magnus