node-google-spreadsheet icon indicating copy to clipboard operation
node-google-spreadsheet copied to clipboard

set backgroundColor for the new row

Open y-maslouskaya opened this issue 3 years ago • 2 comments

Hello, I am trying to add backgroundColor when the new row creates, but I can't make it work. I was able to set backgroundColor when I make some cell updates but I don't know how to apply it for the whole row.

I would really appreciate any help. Thank you in advance!

Here is the part of my code to add a row:

Screen Shot 2022-11-07 at 12 12 00 PM

y-maslouskaya avatar Nov 07 '22 18:11 y-maslouskaya

At the moment, the row-based API does not have access to any more advanced styling / formatting capabilities available. You'll have to use the cell-based methods to do it. Also, I have not implemented the "repeatCell" request which would allow updating a range of cells to a specific format. You'd have to update each cell in the row and then save the updated cells.

Adding some formatting to rows would be nice enhancement though... maybe soon

theoephraim avatar Nov 11 '22 20:11 theoephraim

@theoephraim Thank you a lot for the reply! I'll try what you recommend

y-maslouskaya avatar Nov 27 '22 19:11 y-maslouskaya