Some UX feedback from users of COOL / Calc is that they really want to use 'recent colors' in a given document across machines. We could do this by stuffing yet more UI state into every file - but that seems silly. Instead - I'd like to see if we can grok the item-pools to find eg. all the styles with background set, and (if we have a helpful reference count) get the top eight one sorted by some rough usage heuristic; and include these into the color picker: with a "Popular colors" section or somesuch. This it seems would meet 99% of their use-case, and (hopefully) not be horribly hard. It seems most calc sheets use only a few colors to highlight cells so the set is probably quite small. I assume we could do the same for various other color pickers too by hunting for different color attributes (?) Thanks!
If I'm not wrong, it is a request for enhancement.
I'm hesitant to make the simple control more complex. And isn't it a task for templates? Or the document themes thingy. Besides, the "new" color picker done for bug 94551 has the "Custom" palette where all user-defined colors are added. And this extension [1] exports the Custom palette so it can be added elsewhere. [1] https://extensions.libreoffice.org/en/extensions/show/custom-palette-eport
The user problem is: "I want to use the same color as is already in the document for this new <thing>" - and inevitably it is not a style color, or a theme color - it is some hard-coded, selected color present in the document; and this is thus very hard to fix. Perhaps another option would be to have a whole-document 'color picker' feature in the picker that might solve the same problem I guess.
Duplicate? Bug 84577 - Custom color dialog should be able to grab colors from document Bug 93813 - Integration of a color picker/pipette dropper control into the sidebar and color picker dialog Bug 107380 - [META] Document colors palette issues
(In reply to Heiko Tietze from comment #4) > Duplicate? > > Bug 84577 - Custom color dialog should be able to grab colors from document > Bug 93813 - Integration of a color picker/pipette dropper control into the > sidebar and color picker dialog > Bug 107380 - [META] Document colors palette issues Bug 93813 is a duplicate of bug 84577 (or visa versa). The title of bug 84577 doesn't properly summarize the request. The color picker idea is nice, however it probably doesn't solve the problem. It doesn't the required scale. Multiple people working on same document on multiple machines want to use the existing colors quickly. Not spending time to add the colors manually one by one each time the use the document (way to time consuming, I guess) Couple of possibility's: 1. Color picker (clumsy) 2. Extract the most used colors from a document on file open (works for any file) 3. Store the last used colors (or custom pallet) inside the document (likely limited to native format; and probably not allowed by document specifications) 4. People should rely on custom cell styles (different workflow; possible compatibility with MSO file format)
(In reply to Telesto from comment #5) > 2. Extract the most used colors from a document on file open (works for any > file) Known as "Document colors" with all the issues listed in bug 107380. Not to confuse with the Theme Colors, see bug 151507.
Interestingly, it seems we already take the existing color of the attribute we're picking for into the recent colors list at the end which is rather nice =)
Hmm - so I think this is actually just ignorance - the "Document Colors" palette which we already have does this, and we just exposed in LOK/Online =) so I'll tentatively close.
no commmit -> no fix. notabug seems to fit from the conversation in this bug. Feel free to change if you disagree.