Bug 50746

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.

Created attachment 63128 [details]
Screenshot: "Customize"/"Add Commands" dialogs in LibO 3.5.4 Calc

Created attachment 63129 [details]
Screenshot: "Customize"/"Add Commands" dialogs in LibO 3.5.4 Writer

Created attachment 63130 [details]
Screenshot: "Customize"/"Add Commands" dialogs in LibO 3.5.4 Impress

The same inconsistency/bug is already present in LibreOffice 3.4.4 (for MacOS X), therefore adjusted the Version field.

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".

@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!

(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.

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.

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 ...

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.

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.

(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.

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 ...

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 ;-)

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?

pls note that in 4.0 the context menu contains
 Paste special
 Paste only > Text
            > Number
            > Formula

(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