Hello, 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. Regards, Pushpak PS: This small problem was found when we tried to shift from MSOffice to OpenOffice. 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.
