background color

Spreadsheet
#1

Hi,

In version 1. How do I change the background colors from the 8 offered. For example I would like to change the orange to gold but I can’t find where to change it.

Thank you for a wonderful plugin!

#2

Hi,
we don’t provide ability to configure colors, but it possible to customize your spreadsheet. Here is instructions how to do it:

  1. create images color_rrggbb.png and locate it in codebase/imgs/icons/colors/
    rrggbb in file name is your color which you want to use. Size of image is 18*18.

  2. open codebase/dhtmlxspreadsheet.js and find the follow code:

{type: "buttonSelect", id: "topcolor", text: "Color", img: "colors/color_000000.png", tooltip: "Text color", openAll: true, show: '!read_only', options: [
	{id: "color__000000", type: "obj", text: "Black", img: 'colors/color_000000.png'},
	{id: "color__ffffff", type: "obj", text: "White", img: 'colors/color_ffffff.png'},
	{id: "color__ff0000", type: "obj", text: "Red", img: 'colors/color_ff0000.png'},
	{id: "color__ffc000", type: "obj", text: "Orange", img: 'colors/color_ffc000.png'},
	{id: "color__ffff00", type: "obj", text: "Yellow", img: 'colors/color_ffff00.png'},
	{id: "color__92d050", type: "obj", text: "LightGreen", img: 'colors/color_92d050.png'},
	{id: "color__00b050", type: "obj", text: "Green", img: 'colors/color_00b050.png'},
	{id: "color__00b0f0", type: "obj", text: "LightBlue", img: 'colors/color_00b0f0.png'},
	{id: "color__0070c0", type: "obj", text: "Blue", img: 'colors/color_0070c0.png'}
]},
{type: "buttonSelect", id: "topbgcolor", text: "Background", img: "colors/color_ffffff.png", tooltip: "Background color", openAll: true, show: '!read_only', options: [
	{id: "bgcolor__000000", type: "obj", text: "Black", img: 'colors/color_000000.png'},
	{id: "bgcolor__ffffff", type: "obj", text: "White", img: 'colors/color_ffffff.png'},
	{id: "bgcolor__ff0000", type: "obj", text: "Red", img: 'colors/color_ff0000.png'},
	{id: "bgcolor__ffc000", type: "obj", text: "Orange", img: 'colors/color_ffc000.png'},
	{id: "bgcolor__ffff00", type: "obj", text: "Yellow", img: 'colors/color_ffff00.png'},
	{id: "bgcolor__92d050", type: "obj", text: "LightGreen", img: 'colors/color_92d050.png'},
	{id: "bgcolor__00b050", type: "obj", text: "Green", img: 'colors/color_00b050.png'},
	{id: "bgcolor__00b0f0", type: "obj", text: "LightBlue", img: 'colors/color_00b0f0.png'},
	{id: "bgcolor__0070c0", type: "obj", text: "Blue", img: 'colors/color_0070c0.png'}
]},

It describes color buttons.
You you should select required item and change it:
replace color in id and in img attributes. Also you may change the name.

After that new color should be applied in spreadsheet.