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
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.
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
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];
}
}
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
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]
Posted by Magnus at 00:59 on Friday 4th March 2022 [link]
Thank You! It works & looks beautiful :)
/ Magnus
/ Magnus
[Replies are now closed]