openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pushpak Dagade <>
Subject Related to changing font color of a large selection of cells in OpenOffice Calc
Date Sat, 06 Jul 2013 07:28:50 GMT
I need to explain my problem with the help of an example.

Assume I have a spreadsheet with a column containing 50 cells of text data.
Suppose I change the font colour of only half the text in a particular
cell, say, no. 10, to red (so cell no. 10 now has its contents in 2 colours
- red and black). Everything is as expected till now.

The problem comes when I try to select all the cells and change their font
colour to say, yellow. What I expect is all cells, irrespective of their
prior font colours, should have their font colour yellow. However, what I
get is a different result for cell no. 10. Cell no.10 has half its text
(which was originally black by default) in yellow, but the red coloured
contents are still red in colour.

Manually changing colours for such cells in a big spreadsheet is a tiresome
job. Is there a way to force all cells to have the given font colour
irrespective of their prior font colours?

Quick reply will be appreciated.
Thank you.


PS: This small problem was found when we tried to shift from MSOffice to
Thanks to OpenOffice, for helping us save lot of money. We have ported all
our 300 machines to OpenOffice from MSOffice; and we are able to do most of
our work on OpenOffice without any difficulty.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message