On Tuesday, January 02, 2007 11:53 AM [GMT+1=CET], TerryJ
<[EMAIL PROTECTED]> wrote:
Harold Fuchs-3 wrote:
On Tuesday, January 02, 2007 11:20 AM [GMT+1=CET], david potter
<[EMAIL PROTECTED]> wrote:
Hi,
I used Microsoft Excel until I retired 11 years ago. I now have a
need to use spreadsheets again and have downloaded the free version
of Open Office. Generally I am finding it great but obviously there
are differences. Some I am managing to work out but others prove
refractory.
1.. <snip>
2.. The second thing is an observation. I wanted to highlight
text. I went to the Help facility and found a familiar icon
(superscript ab with below a diagonal pen leading to a coloured line
at the bottom). I could not find this icon on any of the toolbars
in Calc. that I looked at (those that by name seemed relevant). By
examining the icons on the Formatting Toolbar I soon found one with
what looked like paint being poured from a pot. It highlighted any
cell or selection of cells that I wanted but would not highlight a
selection of words from a sentence in a cell. This is fine as you
can do the latter by changing the text colour and I really wanted to
colour the background to words as you would in a text document. I
wonder if this information about the icon and how to use it in a
spreadsheet could be included in the Help function? Or, maybe it is
there but I was unable to find it. I notice that the familiar Icon
that I found in help was in the Writer section. I had tried looking
in several other highlight help areas but without success.
Regards,
Dave Potter
1. Menu item Window>Freeze. Click in A2 and then Window>Freeze to
freeze row 1; click in B1 and then Window>Freeze to freeze column 1;
click in B2 and then Window>Freeze to freeze row 1 *and* column 1.
2. As far as I know Calc only has Cell and Page styles; seems you
can't go to a lower level of detail than the cell.
Harold Fuchs
London, England
I don't know about icons. Double-click on your cell, highlight the
characters you want to format and select Format >Character.
(Background of characters is not available on my version (2.0.2))
Yes; sorry, I overlooked this. It's on the Font Effects tab. Background
of characters isn't in my 2.1 either.
Harold Fuchs
London, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
