zdavatz / spreadsheet

The Ruby Spreadsheet by ywesee GmbH
http://spreadsheet.ch
GNU General Public License v3.0
1.13k stars 240 forks source link

RGB color assignments for a cell #200

Closed kannannadarajan closed 7 years ago

kannannadarajan commented 7 years ago

Hi,

Is there any option to set custom RGB color as background color for a cell or row ? sheet.row(0).set_custom_color(41,63,108,175) sheet.row(0).col(0).set_custom_color(41,63,108,175)

I would be great if you can guide me.

Thanks, Kannan

zdavatz commented 7 years ago

https://github.com/zdavatz/spreadsheet/blob/master/GUIDE.md

UlyssesZh commented 1 year ago

So how? We cannot fill in RGB values. We can only fill in a limited set of preset colors.

https://github.com/zdavatz/spreadsheet/blob/0f860fbd4f457f51331c873603efc4d5f7d5dc94/lib/spreadsheet/datatypes.rb#L13-L15