When creating cells they are created roughly as follows
This displays correctly on the browser view but when I go to export it and then open it in excel only the bottom border shows up
{
value: String(result[0][i]["date_description"]),
...CONFIG_LEFT,
borderTop: { color: "#000000", style: "solid", width: 1 },
borderBottom: { color: "#000000", style: "solid", width: 1 },
borderLeft: { color: "#000000", style: "solid", width: 1 },
borderRight: { color: "#000000", style: "solid", width: 1 },
},
When I do something like the following it will both display correctly in the browser except a few random cells will have their left or right border missing AND when I export it to excel the entire right border on the right most cells is missing
const alphabet = "ABCDEFGHIJKLMNOP".split("") for(let i = 0; i < 13; i++) { for(let j = 0; j < r + 2; j++) { let r = sheet.range(`${alphabet[i]}${j}`) r.borderRight({size: 1, color: "black"}) r.borderTop({size: 1, color: "black"}) r.borderBottom({size: 1, color: "black"}) r.borderLeft({size: 1, color: "black"}) } }