Bug 121452 - Missing the font format when I copy data from LibreOffice Calc and Paste in other Calc version - add Help for Paste Special
Summary: Missing the font format when I copy data from LibreOffice Calc and Paste in o...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
6.2.0.0.alpha1+
Hardware: All Windows (All)
: medium minor
Assignee: Not Assigned
URL: https://help.libreoffice.org/6.2/bs/t...
Whiteboard:
Keywords:
Depends on:
Blocks: Paste
  Show dependency treegraph
 
Reported: 2018-11-16 01:36 UTC by Dieudonne Dukuzumuremyi
Modified: 2022-03-01 12:40 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Image of Copied contents from Calc Version: 6.1.2.1 (x64) (43.10 KB, image/jpeg)
2018-11-16 01:52 UTC, Dieudonne Dukuzumuremyi
Details
Image of Pasted contents from Calc Version: 6.2.0.0.alpha1+ (x64) (36.57 KB, image/jpeg)
2018-11-16 01:53 UTC, Dieudonne Dukuzumuremyi
Details
Sample File for Formatting Created in 6.1.3.2 (Linux) (7.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-11-20 09:19 UTC, Joel Madero
Details

Note You need to log in before you can comment on or make changes to this bug.
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