spreadsheet icon indicating copy to clipboard operation
spreadsheet copied to clipboard

Adding styling to a sheet tab

Open Elian-Braja opened this issue 2 years ago • 5 comments

I want to add custom styling to my sheet tab boxes and I can't find any way to do this with Spreadsheet gem

Elian-Braja avatar Jun 30 '22 12:06 Elian-Braja

Like what? Custom colors? See the guide: https://github.com/zdavatz/spreadsheet/blob/master/GUIDE.md#writing-is-easy

zdavatz avatar Jul 01 '22 13:07 zdavatz

On the documentation I can only add styling to excel cells but not tabs. I am referring to sheet tabs Screenshot from 2022-07-01 16-58-37 . On the example below I want to color Space Ideas, SpaceMembers and SpaceSettings tab boxes to have background color

Elian-Braja avatar Jul 01 '22 14:07 Elian-Braja

try the last option here: https://stackoverflow.com/questions/865186/excel-file-with-multiple-tabs

zdavatz avatar Jul 01 '22 19:07 zdavatz

I can render the excel with multiple sheets using spreadsheet gem. The only problem, as I mentioned is to color those sheet boxes as shown in the screenshot. The link provided by you has nothing to do with styling them. I am not referring to the sheet content, but to the sheet box as shown in the image.

elianbraja avatar Jul 01 '22 20:07 elianbraja

The color of the sheet boxes I do not know, sorry. You will have to dig into the code I guess.

zdavatz avatar Jul 04 '22 06:07 zdavatz