I'm trying to programmatically copy everything (data, cells borders, format (%), color) from one set of columns to another.
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = sheet.getSheets();
const range = sheet.getRange('A1:C5').getValues();
const newrange = sheet.getRange('D1:F5');
Here the data as well as the color are copied correctly to the new location.
However, I could not figure out how to replicate:
The cell border lines (to draw a table)
The format of my cells in percentage (including the sign %).
I've tried the following for the percentage - but did not worked:
const percentageRange = sheet.getRange('A1:C5');
Not sure how should I do for the border