Bug 91281 - Show color picker recently used background colour list in the "FORMAT CELLS -> BACKGROUND" dialog as well
Summary: Show color picker recently used background colour list in the "FORMAT CELLS -...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Area-Fill-Tab Cell-Format-Dialog
  Show dependency treegraph
Reported: 2015-05-14 09:32 UTC by Robert Orzanna
Modified: 2018-05-31 18:28 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Format Cells: Background colour dialog. (38.72 KB, image/png)
2015-05-14 09:32 UTC, Robert Orzanna

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Orzanna 2015-05-14 09:32:17 UTC
Created attachment 115594 [details]
Format Cells: Background colour dialog.

Dear all, 

Is it possible to add a feature to Calc to remember the recently used background colour for cells?

I am referring to the attached dialog window. Given all the different colour options, it is difficult to remember for me as a user which colour I applied to a certain cell and which I would like to use again to have a consistent appearance. 

A small selection panel featuring all recently used background colours would help enormously to quickly select the desired colour. 

What do you think?


Comment 1 A (Andy) 2015-05-14 11:42:54 UTC
Reproducible with LO, Win 8.1 and marked as enhancement request

If you use the colour picker in the toolbar at the top, then you can see the recent selected colours, but not in FORMAT CELLS -> tab BACKGROUND.

But there is also one further issue.  If you use the background colour from the toolbar which is shown at the start of CALC then this colour is not shown under Recent.  It will only be shown if the colour was changed before. -> Bug
Comment 2 kie000 2015-08-31 13:30:17 UTC
Nice idea, I'd like to see the last few recently used background colors in the drop down box...

OK, I've noticed that the word 'recent' is there with a long white rectangle below it but nothing more, is this an unfinished item? It only seems to populate when the drop-down on the tool-bar is used in a certain manner, this should be expanded to a background color being applied in any way such as right click->format cells->Background, or via copy+paste.

Comment 3 tommy27 2016-10-11 20:35:04 UTC
still reproducible with LibO
Build ID: e2f6c7f0d0cc14f851d7028ff846c5dc658a81c6
CPU Threads: 4; OS Version: Windows 6.29; UI Render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2016-10-10_23:08:02
Locale: it-IT (it_IT); Calc: group

@Jay @Caolan
do you think it's techically possible to reuse the "recent" color list from the color picker dropdown menu in the dialog window as well?
Comment 4 Yousuf Philips (jay) (retired) 2016-10-12 11:59:14 UTC
@Tommy: Yes the all-in-one object fill tab (bug 94551) which has a rcently used color section is intended to be ported into background tabs of various dialogs.
Comment 5 Cor Nouws 2018-04-10 19:24:42 UTC
( there is an meta issue for this, or something like that )