Apache OpenOffice (AOO) Bugzilla – Issue 40778
Calc cell formatting buttons (font & bground colour) not 'sticky'
Last modified: 2013-08-07 15:12:27 UTC
In Calc, the two cell formatting buttons for Font Colour & Background Colour, change as you move the selection, to reflect the state of the currently seleced cell(s). This means to change the colour, you have to click to open the colour box then choose the one you want I think with most applications, the these buttons 'stick' to the last selected colour, which is better (IMO) because if you are changing a number of cells to another colour for instance you only have to choose the colour once then apply it with a single click to however many cells you want. Maybe this is as designed (I see it's the same in 1.1.4), but to me at least it's inconsistent with other applications such as MS Excel, and OOo Writer. David Bell
so this has to be discussed by User experience
*** Issue 42880 has been marked as a duplicate of this issue. ***
There was a same issue report through Korean community forum a while ago. So, I tried both approach (in Calc and Excel), and found it is more useful to stick to the latest selected color, absolutely.
*** Issue 50370 has been marked as a duplicate of this issue. ***
*** Issue 56386 has been marked as a duplicate of this issue. ***
*** Issue 60659 has been marked as a duplicate of this issue. ***
This is a duplicate of issue 10864.
Duplicate of 10864. *** This issue has been marked as a duplicate of 10864 ***
Please transfer your votes to 10864.