Adding X11 colors to standard.soc in LibreOffice.org Calc on Ubuntu

LibreOffice.org Calc lacks a good selection of faded pastel colors that work well as cell backgrounds. To remedy this deficiency, I usually add the X11 colors to the standard.soc file in LibreOffice.org Calc. I presort the X11 colors by luminosity to push the high luminosity colors to the end of the list.


To find the standard.soc color file on an Ubuntu rig, pop open a terminal using Ctrl-Alt-t. Then run
sudo find -name standard.soc -type f

On Lubuntu 12.04 there are two standard.soc files.
/home/[username]/.config/libreoffice/3/user/config/standard.soc
/usr/lib/libreoffice/presets/config/standard.soc

The first is the one that contains both the LibreOffice.org standard colors and any custom colors one has added. The second is a preset file that apparently is overwritten on package upgrades. I use SciTE for editing, this package is available in the repositories. Nano would work, but the standard.soc file has no line feeds. I know how to add line feeds to SciTE which makes the file more human readable. Run SciTE as a super user:
sudo scite

Then add the X11 colors after Chart 12:

 <draw:color draw:name="x11-Black" draw:color="#000000" />
 <draw:color draw:name="x11-DarkGreen" draw:color="#006400" />
 <draw:color draw:name="x11-DarkSlateGray" draw:color="#2F4F4F" />
 <draw:color draw:name="x11-Maroon" draw:color="#800000" />
 <draw:color draw:name="x11-Olive" draw:color="#808000" />
 <draw:color draw:name="x11-Green" draw:color="#008000" />
 <draw:color draw:name="x11-Teal" draw:color="#008080" />
 <draw:color draw:name="x11-Navy" draw:color="#000080" />
 <draw:color draw:name="x11-Purple" draw:color="#800080" />
 <draw:color draw:name="x11-Indigo" draw:color="#4B0082" />
 <draw:color draw:name="x11-MidnightBlue" draw:color="#191970" />
 <draw:color draw:name="x11-DarkRed" draw:color="#8B0000" />
 <draw:color draw:name="x11-DarkCyan" draw:color="#008B8B" />
 <draw:color draw:name="x11-DarkBlue" draw:color="#00008B" />
 <draw:color draw:name="x11-DarkMagenta" draw:color="#8B008B" />
 <draw:color draw:name="x11-DarkOliveGreen" draw:color="#556B2F" />
 <draw:color draw:name="x11-SaddleBrown" draw:color="#8B4513" />
 <draw:color draw:name="x11-ForestGreen" draw:color="#228B22" />
 <draw:color draw:name="x11-OliveDrab" draw:color="#6B8E23" />
 <draw:color draw:name="x11-SeaGreen" draw:color="#2E8B57" />
 <draw:color draw:name="x11-DarkGoldenrod" draw:color="#B8860B" />
 <draw:color draw:name="x11-DarkSlateBlue" draw:color="#483D8B" />
 <draw:color draw:name="x11-Sienna" draw:color="#A0522D" />
 <draw:color draw:name="x11-MediumBlue" draw:color="#0000CD" />
 <draw:color draw:name="x11-Brown" draw:color="#A52A2A" />
 <draw:color draw:name="x11-DarkTurquoise" draw:color="#00CED1" />
 <draw:color draw:name="x11-DimGray" draw:color="#696969" />
 <draw:color draw:name="x11-LightSeaGreen" draw:color="#20B2AA" />
 <draw:color draw:name="x11-DarkViolet" draw:color="#9400D3" />
 <draw:color draw:name="x11-FireBrick" draw:color="#B22222" />
 <draw:color draw:name="x11-MediumVioletRed" draw:color="#C71585" />
 <draw:color draw:name="x11-MediumSeaGreen" draw:color="#3CB371" />
 <draw:color draw:name="x11-Chocolate" draw:color="#D2691E" />
 <draw:color draw:name="x11-Crimson" draw:color="#DC143C" />
 <draw:color draw:name="x11-Goldenrod" draw:color="#DAA520" />
 <draw:color draw:name="x11-MediumSpringGreen" draw:color="#00FA9A" />
 <draw:color draw:name="x11-SteelBlue" draw:color="#4682B4" />
 <draw:color draw:name="x11-LawnGreen" draw:color="#7CFC00" />
 <draw:color draw:name="x11-DarkOrchid" draw:color="#9932CC" />
 <draw:color draw:name="x11-Red" draw:color="#FF0000" />
 <draw:color draw:name="x11-OrangeRed" draw:color="#FF4500" />
 <draw:color draw:name="x11-DarkOrange" draw:color="#FF8C00" />
 <draw:color draw:name="x11-Orange" draw:color="#FFA500" />
 <draw:color draw:name="x11-Gold" draw:color="#FFD700" />
 <draw:color draw:name="x11-Yellow" draw:color="#FFFF00" />
 <draw:color draw:name="x11-YellowGreen" draw:color="#9ACD32" />
 <draw:color draw:name="x11-Chartreuse" draw:color="#7FFF00" />
 <draw:color draw:name="x11-LimeGreen" draw:color="#32CD32" />
 <draw:color draw:name="x11-Lime" draw:color="#00FF00" />
 <draw:color draw:name="x11-SpringGreen" draw:color="#00FF7F" />
 <draw:color draw:name="x11-Aqua" draw:color="#00FFFF" />
 <draw:color draw:name="x11-Cyan" draw:color="#00FFFF" />
 <draw:color draw:name="x11-CadetBlue" draw:color="#5F9EA0" />
 <draw:color draw:name="x11-DeepSkyBlue" draw:color="#00BFFF" />
 <draw:color draw:name="x11-Blue" draw:color="#0000FF" />
 <draw:color draw:name="x11-Magenta" draw:color="#FF00FF" />
 <draw:color draw:name="x11-Fuchsia" draw:color="#FF00FF" />
 <draw:color draw:name="x11-Gray" draw:color="#808080" />
 <draw:color draw:name="x11-SlateGray" draw:color="#708090" />
 <draw:color draw:name="x11-Peru" draw:color="#CD853F" />
 <draw:color draw:name="x11-BlueViolet" draw:color="#8A2BE2" />
 <draw:color draw:name="x11-LightSlateGray" draw:color="#778899" />
 <draw:color draw:name="x11-DeepPink" draw:color="#FF1493" />
 <draw:color draw:name="x11-MediumTurquoise" draw:color="#48D1CC" />
 <draw:color draw:name="x11-DodgerBlue" draw:color="#1E90FF" />
 <draw:color draw:name="x11-Turquoise" draw:color="#40E0D0" />
 <draw:color draw:name="x11-RoyalBlue" draw:color="#4169E1" />
 <draw:color draw:name="x11-SlateBlue" draw:color="#6A5ACD" />
 <draw:color draw:name="x11-MediumOrchid" draw:color="#BA55D3" />
 <draw:color draw:name="x11-DarkKhaki" draw:color="#BDB76B" />
 <draw:color draw:name="x11-IndianRed" draw:color="#CD5C5C" />
 <draw:color draw:name="x11-GreenYellow" draw:color="#ADFF2F" />
 <draw:color draw:name="x11-MediumAquamarine" draw:color="#66CDAA" />
 <draw:color draw:name="x11-Tomato" draw:color="#FF6347" />
 <draw:color draw:name="x11-Orchid" draw:color="#DA70D6" />
 <draw:color draw:name="x11-MediumPurple" draw:color="#9370DB" />
 <draw:color draw:name="x11-PaleVioletRed" draw:color="#DB7093" />
 <draw:color draw:name="x11-RosyBrown" draw:color="#BC8F8F" />
 <draw:color draw:name="x11-DarkSeaGreen" draw:color="#8FBC8F" />
 <draw:color draw:name="x11-Coral" draw:color="#FF7F50" />
 <draw:color draw:name="x11-CornflowerBlue" draw:color="#6495ED" />
 <draw:color draw:name="x11-DarkGray" draw:color="#A9A9A9" />
 <draw:color draw:name="x11-SandyBrown" draw:color="#F4A460" />
 <draw:color draw:name="x11-MediumSlateBlue" draw:color="#7B68EE" />
 <draw:color draw:name="x11-Tan" draw:color="#D2B48C" />
 <draw:color draw:name="x11-DarkSalmon" draw:color="#E9967A" />
 <draw:color draw:name="x11-BurlyWood" draw:color="#DEB887" />
 <draw:color draw:name="x11-HotPink" draw:color="#FF69B4" />
 <draw:color draw:name="x11-Salmon" draw:color="#FA8072" />
 <draw:color draw:name="x11-LightCoral" draw:color="#F08080" />
 <draw:color draw:name="x11-Violet" draw:color="#EE82EE" />
 <draw:color draw:name="x11-SkyBlue" draw:color="#87CEEB" />
 <draw:color draw:name="x11-LightSalmon" draw:color="#FFA07A" />
 <draw:color draw:name="x11-Khaki" draw:color="#F0E68C" />
 <draw:color draw:name="x11-Plum" draw:color="#DDA0DD" />
 <draw:color draw:name="x11-LightGreen" draw:color="#90EE90" />
 <draw:color draw:name="x11-Aquamarine" draw:color="#7FFFD4" />
 <draw:color draw:name="x11-Silver" draw:color="#C0C0C0" />
 <draw:color draw:name="x11-LightSkyBlue" draw:color="#87CEFA" />
 <draw:color draw:name="x11-LightSteelBlue" draw:color="#B0C4DE" />
 <draw:color draw:name="x11-PaleGreen" draw:color="#98FB98" />
 <draw:color draw:name="x11-LightBlue" draw:color="#ADD8E6" />
 <draw:color draw:name="x11-PowderBlue" draw:color="#B0E0E6" />
 <draw:color draw:name="x11-Thistle" draw:color="#D8BFD8" />
 <draw:color draw:name="x11-PaleGoldenrod" draw:color="#EEE8AA" />
 <draw:color draw:name="x11-PaleTurquoise" draw:color="#AFEEEE" />
 <draw:color draw:name="x11-LightGrey" draw:color="#D3D3D3" />
 <draw:color draw:name="x11-Wheat" draw:color="#F5DEB3" />
 <draw:color draw:name="x11-NavajoWhite" draw:color="#FFDEAD" />
 <draw:color draw:name="x11-Moccasin" draw:color="#FFE4B5" />
 <draw:color draw:name="x11-LightPink" draw:color="#FFB6C1" />
 <draw:color draw:name="x11-Gainsboro" draw:color="#DCDCDC" />
 <draw:color draw:name="x11-PeachPuff" draw:color="#FFDAB9" />
 <draw:color draw:name="x11-Pink" draw:color="#FFC0CB" />
 <draw:color draw:name="x11-Bisque" draw:color="#FFE4C4" />
 <draw:color draw:name="x11-LightGoldenrodYellow" draw:color="#FAFAD2" />
 <draw:color draw:name="x11-BlanchedAlmond" draw:color="#FFEBCD" />
 <draw:color draw:name="x11-LemonChiffon" draw:color="#FFFACD" />
 <draw:color draw:name="x11-AntiqueWhite" draw:color="#FAEBD7" />
 <draw:color draw:name="x11-Beige" draw:color="#F5F5DC" />
 <draw:color draw:name="x11-PapayaWhip" draw:color="#FFEFD5" />
 <draw:color draw:name="x11-Cornsilk" draw:color="#FFF8DC" />
 <draw:color draw:name="x11-LightYellow" draw:color="#FFFFE0" />
 <draw:color draw:name="x11-LightCyan" draw:color="#E0FFFF" />
 <draw:color draw:name="x11-MistyRose" draw:color="#FFE4E1" />
 <draw:color draw:name="x11-Linen" draw:color="#FAF0E6" />
 <draw:color draw:name="x11-Lavender" draw:color="#E6E6FA" />
 <draw:color draw:name="x11-OldLace" draw:color="#FDF5E6" />
 <draw:color draw:name="x11-WhiteSmoke" draw:color="#F5F5F5" />
 <draw:color draw:name="x11-Seashell" draw:color="#FFF5EE" />
 <draw:color draw:name="x11-FloralWhite" draw:color="#FFFAF0" />
 <draw:color draw:name="x11-Ivory" draw:color="#FFFFF0" />
 <draw:color draw:name="x11-Honeydew" draw:color="#F0FFF0" />
 <draw:color draw:name="x11-Azure" draw:color="#F0FFFF" />
 <draw:color draw:name="x11-AliceBlue" draw:color="#F0F8FF" />
 <draw:color draw:name="x11-LavenderBlush" draw:color="#FFF0F5" />
 <draw:color draw:name="x11-MintCream" draw:color="#F5FFFA" />
 <draw:color draw:name="x11-GhostWhite" draw:color="#F8F8FF" />
 <draw:color draw:name="x11-Snow" draw:color="#FFFAFA" />
 <draw:color draw:name="x11-White" draw:color="#FFFFFF" />
 <draw:color draw:name="lightlylavender" draw:color="#f0d0ff"/>

Start (restart) LibreOffice.org and color those spreadsheet cells in 147 X11 colors. Of course one could use any palette one wanted to use. The X11 colors were generated from a spreadsheet that can be resorted. HSL colors could be swapped in, an OpenDocument spreadsheet that handles HSL colors is also available.

The same standard.soc file is found on Windows rigs in a user profiles subfolder and can be edited in the same way if one is so inclined.

Popular posts from this blog

Box and whisker plots in Google Sheets

Traditional food dishes of Micronesia

Assessing Learning in Ethnobotany