Bug 121452

Summary: Missing the font format when I copy data from LibreOffice Calc and Paste in other Calc version - add Help for Paste Special
Product: LibreOffice Reporter: Dieudonne Dukuzumuremyi <jimdosy>
Component: DocumentationAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: minor CC: 79045_79045, himajin100000, jmadero.dev, olivier.hallot, telesto
Priority: medium    
Version: 6.2.0.0.alpha1+   
Hardware: All   
OS: Windows (All)   
URL: https://help.libreoffice.org/6.2/bs/text/scalc/guide/main.html
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=113429
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 102593    
Attachments: Image of Copied contents from Calc Version: 6.1.2.1 (x64)
Image of Pasted contents from Calc Version: 6.2.0.0.alpha1+ (x64)
Sample File for Formatting Created in 6.1.3.2 (Linux)

Description Dieudonne Dukuzumuremyi 2018-11-16 01:36:25 UTC
Description:
I prepared an table with colors, font-sized, make some part bold, etc..  in LibreOffice Calc Version: 6.1.2.1 (x64).
but anytime I select and copy the contents and Past into LibreOffice Calc
Version: 6.2.0.0.alpha1+ (x64).
Only the text can be pasted. The rest like colors,bold, etc. disappear. 

Steps to Reproduce:
1. Open LibreOffice Calc version 6.1.2.1 (x64) 
2. Make a simple table with Font formating such as colors, bold etc..
3. Select All the contents 
4. Open LibreOffice Calc Version: 6.2.0.0.alpha1+ (x64)
5. Past the contents 

Actual Results:
The Pasted contents loose its font format such as colors, size and text bold etc..

Expected Results:
The Pasted contents from  Calc version 6.1.2.1 (x64), should look like the contents in Calc Version: 6.1.2.1 (x64)


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Copy from: 

Version: 6.1.2.1 (x64)
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 8; OS: Windows 6.3; UI render: default; 
Locale: en-US (en_US); Calc: group threaded


Past into:

Version: 6.2.0.0.alpha1+ (x64)
Build ID: 8274c4c62df5b937b3f0bec9e1eeca85f3b219d4
CPU threads: 8; OS: Windows 6.3; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-10-22_01:47:50
Locale: en-US (en_US); Calc: threaded
Comment 1 Dieudonne Dukuzumuremyi 2018-11-16 01:52:24 UTC
Created attachment 146676 [details]
Image of Copied contents from Calc Version: 6.1.2.1 (x64)
Comment 2 Dieudonne Dukuzumuremyi 2018-11-16 01:53:31 UTC
Created attachment 146677 [details]
Image of Pasted contents from Calc Version: 6.2.0.0.alpha1+ (x64)
Comment 3 Joel Madero 2018-11-20 09:19:14 UTC
Created attachment 146814 [details]
Sample File for Formatting Created in 6.1.3.2 (Linux)

Cannot reproduce, attached sample document.

Steps:
1) Open sample document with Version: 6.1.3.2
2) Open LibreOffice daily (https://dev-builds.libreoffice.org/daily/master/)
3) Copy A1 from 6.1.3.2
4) Paste into Calc daily build

Works as expected

My setup:
Linux Mint 19
Copy from version: 6.1.3.2
Copy to version: Version: 6.2.0.0.alpha1+
Build ID: 1647bc1309dcd313dff2614f4844b71b1c558dee

Maybe Windows only issue but can you just confirm this happens still with master build? Also try to reset your profile (https://wiki.documentfoundation.org/UserProfile)

Not moving to another status as of yet - want someone to test on Windows. 

Also, thanks for the solid report, really easy to follow. In the future, please also include a test document (not just screenshots).
Comment 4 Timur 2018-11-20 12:13:35 UTC
I confirm in Windows for different LO versions, not just 6.1. and 6.2 as reported. 
But I'm not sure if this should be fixed. In normal use one doesn't need to use different LO versions at the same time. 
Probably default paste format is text, but we can still use some of other formats via Paste Special. 

What I'll do is confirm this bug but for Documentation. To explain copy and paste options, i.e. Paste Special that I couldn't find in https://help.libreoffice.org/6.2/bs/text/scalc/guide/main.html.
Comment 5 Roman Kuznetsov 2022-03-01 12:34:40 UTC
I don't think it's an only Documentation problem

still rerpo in current 7.4 master