[Libreoffice-bugs] [Bug 109011] Calc: Edit-Paste Only items Text/Number/Formula don't paste content from Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from tenbob1 at ymail.com ---
Confirmed. This bug currently exists with LibreOffice 7.0.3.1 (x64) on Windows
7.

All I want to do is paste a range of cells from Excel to Calc. This doesn't
work in some cases. My version of Excel is Microsoft Excel 2000 (9.0.2720).

The cells in Excel that I am copying contain assorted numbers, text and
formulas. I have also applied different kinds of formatting.

Below is what happened when I pasted an identical block of cells from Excel to
Calc using various methods of pasting. 

Note that the menus in Calc are a bit confusing. When you click "Paste Special"
you get a sub menu with more choices. The choices in the sub menu sometimes
lead to further dialog boxes. Other sub menu choices take effect immediately. 

Confusingly one of the choices in the sub menu is "Paste Special" (again) which
takes you to a further dialog box titled "Paste Special". So in effect you are
selecting "Paste Special" three times in succession, so it could be thought of
as "Paste extra extra special". 


Results
========
Ordinary Paste (not special). Result as expected. Numbers, text, formulas and
formatting are pasted as expected.

Paste using Ctrl+V. Result as expected. Same as ordinary paste above.

Paste Special > Paste Unformatted Text > Dialog "Text Import". Result as
expected. Numbers are pasted as numbers. Text pasted as text. Formulas pasted
as values. Formatting is not pasted.

Paste Special > Paste Only Text. Result: Broken. Nothing happens.

Paste Special > Paste Only Numbers. Result: Broken. Nothing happens.

Paste Special > Paste Only Formula. Result: Broken. Nothing happens.

Paste Special > Paste Special (again) > Dialog "Paste Special". Results as
expected. Actual results vary according to the format selected. BIFF gives a
full copy with formulas and formatting, DIF copies only values, DDE sets up
links to values in the original sheet.

In summary, Paste Only Text, Paste Only Numbers and Paste Only Formula are all
broken. 

HTH. Bob

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201125/e613d6ca/attachment.htm>