Bug 50746 - UI: Under customize Edit menu options: add the option "paste unformatted text"
Summary: UI: Under customize Edit menu options: add the option "paste unformatted text"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.4.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard: EasyHack DifficultyBeginner SkillCpp
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-05 12:36 UTC by efelthauser
Modified: 2014-10-18 20:01 UTC (History)
5 users (show)

See Also:
i915 platform:
i915 features:


Attachments
photo of where the missing option should go (134.36 KB, image/png)
2012-06-05 12:36 UTC, efelthauser
Details
Screenshot: "Customize"/"Add Commands" dialogs in LibO 3.5.4 Calc (160.82 KB, image/png)
2012-06-17 02:24 UTC, Roman Eisele
Details
Screenshot: "Customize"/"Add Commands" dialogs in LibO 3.5.4 Writer (150.87 KB, image/png)
2012-06-17 02:25 UTC, Roman Eisele
Details
Screenshot: "Customize"/"Add Commands" dialogs in LibO 3.5.4 Impress (185.22 KB, image/png)
2012-06-17 02:25 UTC, Roman Eisele
Details
Screenshot: Bug still present in LOdev 2012-12-06 (Mac OS X): Paste commands (368.13 KB, image/png)
2012-12-13 07:45 UTC, Roman Eisele
Details
Screenshot: Bug still present in LOdev 2012-12-06 (Mac OS X): UNO paste commands (372.19 KB, image/png)
2012-12-13 07:51 UTC, Roman Eisele
Details

Description efelthauser 2012-06-05 12:36:30 UTC
Created attachment 62597 [details]
photo of where the missing option should go

Under Tools>Customize>Menu>Edit, there should be the option to add a menu item called "Paste unformatted text". There is not. Instead, there are two "Paste special" items listed...
Comment 1 Roman Eisele 2012-06-17 02:23:12 UTC
Thank you for your report!

REPRODUCIBLE with LibreOffice 3.5.4.2 (Build ID: 165a79a-7059095-e13bb37-fef39a4-9503d18), German langpack installed, on MacOS X 10.6.8 German UI.

To reproduce, start LibreOffice Calc and select (from the menu) "Tools > Customize ...", then select the "Edit" menu, then click "Add ..." and then select the "Category" called "Edit".

I get the same results as the original reporter; I will attach a screenshot confirming this. However, I have to point out:

1) The original reports's screenshot (attachment 62597 [details]) shows also two entries called "Paste Special" in the list of the "Customize" window, the 1st one right after "Undo" (a very strange place!), the 2nd one at the right position after "Paste". I don't see the 1st "Paste special" menu item (see my screenshot), and I think this is not a part of the problem -- it may be just a coincidence from some playing around with the "Add command" utility.

2) There is an interesting little difference between the two "Paste Special" entries in the list of the "Add commands" dialog window: the 2nd one has a description which is shown below ("Inserts the contents of the clipboard into the current file in a format that you can specify."; see my screenshot), but if I select the 1st "Paste Special" entry, no such description appears.

3) One could question if this is a but at all. Of course, it is strange that there are two "Paste Special" entries in the list of the "Add commands" dialog window, but who has said that there should be a "Paste unformatted text" entry? One could think "Maybe this is a missing feature, but not a bug."

But we can easily show that there is really a bug or at least an inconsistency here, because this "Paste Unformatted Text" entry is missing only in Calc (and in Impress), but it is present in Writer. See my 2nd screenshot: Writer allows to add a special "Paste unformatted text" menu item; and my 3rd screenshot for Impress.

Summary:
* Writer  offers "Paste", "Paste Special", "Paste Unformatted Text".
* Calc    offers "Paste", "Paste Special", "Paste Special" (2 times!)
* Impress offers "Paste", "Paste Special".

Given the fact that Writer offers both "Paste Special" and "Paste unformatted text" items in the list of the "Add commands" dialog window, and no 2nd "Paste Special" item, it seems reasonable to speek of both an inconsistency (there is a "Paste unformatted text" in Writer, but neither in Calc nor in Impress) and of a bug (the 2nd and useless "Paste Special" item in Calc should probably be a "Paste unformatted text" item like in Writer).

I have changed the "Component" field of this bug report to "Spreadsheet" to make clear that we are talking about a Calc issue.

For the missing item in Impress, we should file a separate report, probably an enhancement request.
Comment 2 Roman Eisele 2012-06-17 02:24:35 UTC
Created attachment 63128 [details]
Screenshot: "Customize"/"Add Commands" dialogs in LibO 3.5.4 Calc
Comment 3 Roman Eisele 2012-06-17 02:25:03 UTC
Created attachment 63129 [details]
Screenshot: "Customize"/"Add Commands" dialogs in LibO 3.5.4 Writer
Comment 4 Roman Eisele 2012-06-17 02:25:27 UTC
Created attachment 63130 [details]
Screenshot: "Customize"/"Add Commands" dialogs in LibO 3.5.4 Impress
Comment 5 Roman Eisele 2012-06-17 02:29:19 UTC
The same inconsistency/bug is already present in LibreOffice 3.4.4 (for MacOS X), therefore adjusted the Version field.
Comment 6 Roman Eisele 2012-06-20 03:13:31 UTC
The same inconsistency/bug (see my summary in comment #1) is also present in LibreOffice 3.5.4.2 on *Windows*. Therefore not a special MacOS issue; changed the Platform to "All".
Comment 7 Roman Eisele 2012-06-20 03:18:29 UTC
@Markus Mohrhard,
@Eike Rathke:

This Calc/UI issue is neither terrible nor urgent, but it is still of some importance, especially for power users, and probably rather easy to fix. It would be very nice if you could take a look at it.

Thank you very much in advance!
Comment 8 Roman Eisele 2012-06-28 09:05:46 UTC
(In reply to comment #1)
> For the missing item in Impress, we should file a separate report, probably an
> enhancement request.

I have done so; please see bug 51525, which is a enhancement request for adding the "Paste Unformatted Text" to the commands list in the "Customize > Add Commands" dialog for Impress.
Comment 9 Rob Snelders 2012-12-02 15:42:36 UTC
1 paste special is the uno:PasteSpecial-command.
The other is uno:InsertContents-command.

They are 2 different commands with the same name. I'm not sure however what to rename 1 of those to to make them differ.
Comment 10 Roman Eisele 2012-12-02 16:33:26 UTC
Rob, thank you for investigating this issue!

Well, it would be very helpful if was possible to rename one of the two entries, because the two entries with the same name confuse the user, and prevent that he/she recognizes the difference of them ...
Comment 11 Rob Snelders 2012-12-02 19:03:42 UTC
As far as I can see the function do mainly the same thing. Somebody should look into it and find out what the difference is.
Comment 12 Markus Mohrhard 2012-12-05 18:26:36 UTC
At least in master I have Paste, Paste Special, Paste Only with Text, Number and Formula.

@Roman: If you could confirm this we could close this bug report. We can't backport any changes for it as it would break the string freeze.
Comment 13 Roman Eisele 2012-12-06 07:36:18 UTC
(In reply to comment #12)
> At least in master I have Paste, Paste Special, Paste Only with Text, Number
> and Formula.

Nice to hear that!

> @Roman: If you could confirm this we could close this bug report. We can't
> backport any changes for it as it would break the string freeze.

I would like to do so, but since 2012-11-28, there are no new master/daily builds for Mac OS X. I have a bunch of fixes etc. which I need to verify, check, etc. ... When there will be a new (and working) master build, I will check this.
Comment 14 Roman Eisele 2012-12-13 07:45:15 UTC
Created attachment 71430 [details]
Screenshot: Bug still present in LOdev 2012-12-06 (Mac OS X): Paste commands


@ Markus:
(In reply to comment #12)
> At least in master I have Paste, Paste Special, Paste Only with Text, Number
> and Formula.
> 
> @Roman: If you could confirm this we could close this bug report. We can't
> backport any changes for it as it would break the string freeze.

IMHO the problem is still present. With the latest master build for Mac OS X (Version 4.1.0.0.alpha0+, Build ID: e43d62fb39e0b6b3e59b22110460d23b6d507b5, pull time: 2012-12-06_09:19:57) -- sorry, there is no newer one! --, I still see two "Paste Special" options, but no "Paste Only with Text" option. Please see the attached screenshot ...
Comment 15 Roman Eisele 2012-12-13 07:51:05 UTC
Created attachment 71431 [details]
Screenshot: Bug still present in LOdev 2012-12-06 (Mac OS X): UNO paste commands

Of course, besides the normal “Paste” and the duplicated “Paste Special” options, there are also four options with “.uno:” prefix:

  .uno:PasteOnly
  .uno:PasteOnlyFormula
  .uno:PasteOnlyText
  .uno:PasteOnlyValue

Did you refer to these options?

IMHO the names of these options are a bit unlucky: a “normal” user might not understand what the rather technical “.uno:” prefix means, and may not realize that he/she should use *these* options in order to add a custom menu option. Instead, he/she might just search for a simple “Paste Unformatted Text” option.

So, if it was possible to rename these four UNO options just to “Paste Only Formula”, “Paste Only Text”, etc., we would have a perfect solution ;-)
Comment 16 Cor Nouws 2013-03-30 22:30:43 UTC
The second 'paste special' is not present in my 4.0.2rc1

I think the idea is that Paste unformatted text is added as choice?
Comment 17 Cor Nouws 2014-10-18 20:00:55 UTC
pls note that in 4.0 the context menu contains
 Paste special
 Paste only > Text
            > Number
            > Formula
Comment 18 Cor Nouws 2014-10-18 20:01:18 UTC
(In reply to Cor Nouws from comment #17)
> pls note that in 4.0 the context menu contains

 Stupid me: must be 4.4 of course!

>  Paste special
>  Paste only > Text
>             > Number
>             > Formula


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.