The paste-special allows a ton of useful stuff to be done; -but- it is a royal pain to use.
By far my most useful set of settings is to allow numbers, and formats, and ... to be pasted, but not the formulae behind them.
There are several other sets of useful pre-canned settings there too.
It would be lovely to have a toolbar-type row of icons inside this dialog (ux-advise input appreciated) to allow selection of a pre-canned set of options.
It'd be sensible to use missing or home-drawn images for the buttons until we can get a designer to produce some attractive ones :-)
Code is here:
adding LibreOffice developer list as CC to unresolved EasyHacks for better visibility.
see e.g. http://nabble.documentfoundation.org/minutes-of-ESC-call-td4076214.html for details
(we usually set the version to the oldest know version with the behaviour that is challenged ;) )
Created attachment 104635 [details]
I would like to see if I can offer something for the resolution of this bug.
a proposed patch is at https://gerrit.libreoffice.org/#/c/10928/
It currently has
- Paste values only,
- paste values and formats,
- paste transpose.
These are the ones I use most, but other desirable short cut combinations can be added as well.
The would-be icons are based on the paste symbol in the galaxy theme.
I appreciate any comment you may have.
Thomas Viehmann committed a patch related to this issue.
It has been pushed to "master":
fdo#79116 make paste special easier to use
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Awesome work Thomas =) thanks for that - pushed to master (perhaps the calc guys will have a comment here or there :-), and looking forward to your next commit. Anything else you can see to cleanup around that dialog ?
Failing that could I interest you in bug#82641 - I (for one) would find that rather useful too ;-)
This looks like something that needs to be highlighted in the release notes :-)
Migrating Whiteboard tags to Keywords: (EasyHack DifficultyBeginner SkillCpp TopicCleanup)
Remove LibreOffice Dev List from CC on EasyHacks
(curtailing excessive email to list)