Although I use Fedora Core 6 myself, and KDE, the way to do this should be pretty much the same.
You start: KDE Control Center > SystemAdministration > FontInstaller > AddFonts(icon)
and from there on, you'll manage. This is the way it is in FC6. Though I seem to recall that I used to do this in FC5 by starting "spadmin" binary in the OpenOffice2.0 install directory. There used to be a manual for adding new fonts this way in OpenOffice Help, but it seems this way has been deprecated.
So, try out one of these two, and I guess You shouldn't have any problems.