Apache OpenOffice (AOO) Bugzilla – Issue 123626
[Enhancement] Better defaults for paste-special cells dialog
Last modified: 2022-10-28 12:54:25 UTC
The paste-special command for Calc cells comes up with "Paste All" and all other options disabled. Well, we call paste-special and not paste because we do not want to paste all so the "Paste All" option is questionable. Now, when we untick that option, the next default is "everything except numbers". Why of all things "Numbers" should be disabled when pasting data from one Calc range in another Calc range? Suggestion: By default paste-special should paste text, number and date-time which would be the equivalent to Excel's "Paste-Special Values".
Paste special has memory - i.e. once you've set the desired elements to paste, they will be remembered next time you paste special. IMHO enhancement not required.
The settings are preserved for the current session only. The initial defaults need to be overriden twice. First you turn off "All", then you select what you need which is most certainly not checked by default. The defaults confuse new users, sporadic Calc users and (of course) Excel users. In short: They make the program look stupid.
At one time, not too long ago, Calc remembered the paste special options from one session to another, but no longer. I think restoring that behavior would be the best solution.
IMHO comment 3 is not a good idea. A macro can be created for custom paste special.
Sure, a simple dispatch macro can solve that form me and a couple of other users. However, it does not solve the problem that by default paste-special does a full paste because by default that silly "All" check box is checked. When you untick this obsolete option you are confronted with another incomprehensive default that may be useful in less than 1% of all practical use cases. I've filed this issue from the perspective of a "support agent" who answers questions on the user forum every day.
Convinced by comment 5.
Created attachment 82322 [details] Patch to change the default checked options on paste special dialog According to the reporter's description, the following changes are contained: - no Paste all checked by default - Only Text, Numbers and Data & time are checked by default Do we need some discussions to apply this change?
Thank you hanya keyword = needhelp for any additional comments
Thank you very much.
No comments -> change can be applied.
"hanya" committed SVN revision 1560642 into trunk: #i123626# change default for paste special dialog of Calc to Text, Numbers an...
Fixed.