Why does GoogleSpreadsheet - Write range always add a ' before a number?

Help
1

Hi!
I think I’v found something strange with the GoogleSpreadsheet Package.
Every time I write a number to a cell in Google Spreadsheets I get a ’ before a number.
This does not happen when I write a letter.

Does anyone else have the same problem?

isitabug

2

Hi Martin,

This isn’t a UiPath-specific thing, but rather a common behavior in spreadsheet applications. The apostrophe before the number indicates that the number is actually text. When you are writing the values to the spreadsheet, I’m guessing the values are being passed as a string?

Depending on what you need to do, the ` might not be an issue at all. If it’s causing you problems, maybe you could share more of your workflow so that we can figure out why your numbers are being treated as text.

Best,

Evan

3

Hi Evan!
My bad - didn’t analyse my problem carefully. You are right about the behaviour of Google Spreadsheets. Could you put me in the right direction of how to change datatype for a specific column?

4

Sorry to say - but the easiest way to get correct formating was to use a macro in google sheets. The macro has a trigger when a edit happends in the sheet.

//My macro:

function changeFormat() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var changer = ss.getSheetByName(“KundFranWP”); //use your sheetname
changer.getRange(‘J:J’).activate(); //the column with dates
changer.getActiveRangeList().setNumberFormat(‘yyyy"-“mm”-"dd’); //my formating
};

1 Like