Cell colors don't stick

[paaskynen]

Hi, I'm having a problem, and have searched for similar reports but haven't found any, which is strange since this should've been noticed.

I'm using OOo 3.1.1 on WinXP SP3.

When I create a new spreadsheet, fill in a row (ie 1st row) with some names (ie fruit names), let's say 3 cells in a row, like this:

GRAPE
APPLE
ORANGE

Then, on the apple cell, I change the background and/or foreground color (by clicking on the background color button). Ok, the cell color is changed.

Then, I press the ascending order button.

The cells change to ascending order, but the color doesn't follow the apple. Now GRAPE is with a different color, which is a weird behaviour.

Anyone has a fix for this?

Also I'm noticing that when I press the ascending or descending order button, the first cell of the row isn't affected. Why is that?

Thanks

[jrkrideau]