[Libreoffice-ux-advise] [Bug 154152] Paste-Special > Text, Number or Formula does nothing when data copied from other app

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=154152

--- Comment #6 from ady <adylo811517 at gmail.com> ---
(In reply to Eyal Rozenberg from comment #0)
> In a new Calc spreasheet, I now try to paste this content in different ways,
> into some arbitrary cell.
> 
> Pressing Ctrl+V:                                  Works, I get 5678.
> Right-click > Paste:                              Works, I get 5678.
> Right-click > Paste Special > Unformatted Text :  Works, I get 5678.
> Right-click > Paste Special > Text :              Nothing happens!
> Right-click > Paste Special > Number :            Nothing happens!
> Right-click > Paste Special > Formula :           Nothing happens!

Please note that you can paste "any" kind of values when the origin is some
plain text.

For instance, you can select the Unformatted Text alternative and then choose
different types of data per column.

Unformatted Text doesn't care whether you are copying from within Calc, or from
any other source; but the other alternatives do.

I think that the potential confusion, as others mentioned, is that "Unformatted
Text" seems to be in the same "category" as the others; it is not – not really.
Unformatted Text pastes from "any" source, whereas the others are from other
cells, limiting the result according to type of data in the source cells. IIRC,
they used to be within the Paste Special dialog only, and the fact that they
are now accessed more easily directly in the menu might had triggered this
potential confusion.

I agree with others; by itself this is NAB, but perhaps the idea of graying out
these alternative options when they are not really usable/relevant/adequate
might be a valid improvement.

-- 
You are receiving this mail because:
You are on the CC list for the bug.