[Libreoffice-ux-advise] [Bug 147273] Copying From Calc + Paste Unformatted Text into Writer = All Text in Single Cell

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Tex2002ans <Tex2002ans+LibreOffice at gmail.com> ---
> I expect it to be the correct behaviour, that's why you are pasting it as unformatted.

You expect the current? Or what I proposed?

> How other sofwares behave in this situation ?

I reproduced+attached my testfiles in:

- Excel 2016
- Word 2016

+ saved them as:

- XLSX
- DOCX

* * *

In Excel->Word:

Following Step 1+2 + Ctrl+V into first cell:

- Pastes all colored text into first cell.
--- I think it pastes a 3x3 table, similar to what was described in LO's Bug
#37223.

* * *

Another thing I noticed in Excel->Word:

After you Ctrl+V (paste) 3x3 table into Word's first cell, you get 4 "Paste
Options":

1. Nest Table (N)
2. Merge Table (M)
- This looks to be ~ what I was expecting!
- Although it actually:
--- Adds extra 3x3 rows between rows 1+2.
--- Carries over Excel's formatting.
3. Insert As New Rows (R)
4. Keep Text Only (K)
- Looks to be similar to LO's Paste "Unformatted Text".
--- Word shoves 3x3 text (with tabs between) into first cell.
--- LO does vertical line of text with enters between.

On a related note... if you Ctrl+V (paste) it into a normal Word paragraph, you
get different "Paste Options":

1. Keep Source Formatting (K)
2. Use Destination Styles (S)
3. Link & Keep Source Formatting (F)
4. Link & Use Destination Styles (L)
5. Picture (U)
5. Keep Text Only (T)

Anyway, I'm not familiar enough with Excel/Word to know what all the intricate
differences are.

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