font colours available in OpenOffice

Johnny Rosenberg gurus.knugum at
Wed Aug 25 22:15:51 UTC 2010

2010/8/25 NoOp <glgxg at>:
> On 08/25/2010 03:23 AM, Adam Funk wrote:
>> Some colleagues and I are trying to coordinate Impress presentations,
>> and we noticed that some of us have more colours than others.  My OO
>> has 101 font colours; one colleague has at least a dozen more,
>> including "Ubuntu Red", which we all like and want to use in our
>> presentations, as well as "Chart 1", "Chart 2", etc.
>> We're both using 1:3.2.0-7ubuntu4.1 on Lucid, and I
>> can't see any relevant differences in the related packages we have
>> installed.
>> I've figured out how to add this particular colour (Tools -> Options
>> -> Colours, use RGB = 202, 0, 22) manually, but it's bugging me that
>> my installation is missing things.
> It's most likely that your colleagues may be using different/older color
> palettes in their OOo user profile. In OOo it's not readily apparent how
> to load different *.soc files as you need to do this in Draw:
> <>
> [Color Bar]
> Once you've changed the .soc to another color palette, those colors will
> be available in other component (Writer, Calc, Impress, Base) as well.
> If you are in a Writer document & need to change, the easiest way is to
> add the Draw toolbar (View|Toolbars|Drawing) and then put a small
> ellipse on the page. Right-click the ellipse & select 'Area|Color' and
> load/change the *.soc that you need. You can then delete the ellipse.
> You can copy additional *.soc files (example: scribus.soc) to your user
> profile so that you do not need to hunt them down in other folders later on:
> /home/<username>/
> Have your colleagues take a look at the *.soc files in the above and see
> if they match yours. "Ubuntu Red" was (IIRC) was around the
> Dapper/Feisty timeframe, and is, I think, possibly 'Rosso corsa'
> (D40000):
> (212, 0, 0)
> An easy RGB to hex converter is here:

And here's another one:
Add these functions to My Macros:

REM  *****  BASIC  *****

Option Explicit

Function RGBToHEX(R As Integer, G As Integer, B As Integer) As String
	RGBToHEX=Hex(R) & Hex(G) & Hex(B)
End Function

Function HEXToRGB(H As String) As String
	Dim i As Integer
	Dim RGB As String
	For i=0 To 2
		RGB=RGB & Str(CInt("&H" & Mid(H,2*i+1,2)))
	Next i
End Function

Now you can easily convert directly in Calc, for example:

If A4 contains abcdef, then the result is:
171 205 239

If A5=171, A6=205 and A7=239, then ABCDEF will be returned.


Be aware though, that I didn't include any kind of error handling, so
bad input gives bad output, maybe unexpected some times, I'd guess.


Johnny Rosenberg

> ============
> Interesting OT note: Canonical/Ubuntu have changed to an Orange theme &
> I can't find the old logo documents. These offer some guidance:
> The "interesting" part is that the PDF's were created with Adobe
> InDesign CS4 (6.0.5) - Acrobat Distiller 8.2.2 (Macintosh) - and the
> larger pdf documents don't even contain TOC or indexes...
> Seems a shame that Canonical/Ubuntu can't even use their own OS/system
> and tools (OOo) to produce these public facing documents.
> --
> ubuntu-users mailing list
> ubuntu-users at
> Modify settings or unsubscribe at:

More information about the ubuntu-users mailing list