Bug 141944 - Copy paste from Google Sheet work bad for merged cell
Summary: Copy paste from Google Sheet work bad for merged cell
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Merge-Split
  Show dependency treegraph
 
Reported: 2021-04-28 07:49 UTC by seven
Modified: 2023-04-25 06:08 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample for google sheet and LibreOffice result (12.07 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-04-28 07:50 UTC, seven
Details

Note You need to log in before you can comment on or make changes to this bug.
Description seven 2021-04-28 07:49:42 UTC
Description:
I try copy paste from google sheet to LibreOffice calc and get issue with merging cell (each next row merged like in increase mode)

Steps to Reproduce:
1. Create google sheet table
2. Select table and copy in Google Chrome, in Google sheet (sample take from attachment in first tab)
3. Paste in new LibreOffice Calc document (you must get result as in second tab in sample doc)

Actual Results:
Paste with wrong merged cells

Expected Results:
Paste same like in google sheet


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.3.1 (x64) / LibreOffice Community
Build ID: fa76d07d7006a0e2866c3247cef2d5eb55ae8369
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 seven 2021-04-28 07:50:27 UTC
Created attachment 171470 [details]
Sample for google sheet and LibreOffice result
Comment 2 pavlog 2021-05-22 14:46:38 UTC
Thanks for report, I can reproduce it in 

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 6e6e531b564cdc9d5b25287c215cdc5a1fcbb346
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL

Version: 7.1.2.2 (x64) / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
Comment 3 csyu.279 2023-04-19 20:37:26 UTC
Unable to reproduce in: 

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 61b41646c5a93ca24f2c9f143cdb0da2c9258989
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Version: 7.4.6.2 (x64) / LibreOffice Community
Build ID: 5b1f5509c2decdade7fda905e3e1429a67acd63d
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
Comment 4 Buovjaga 2023-04-24 17:58:41 UTC
I can't reproduce even in 7.2 or 7.3.

Steps tried:
1. Open attachment 171470 [details]
2. Copy cells from "Google sheet"
3. In Chromium, paste to Google Sheets
4. Copy cells from Google Sheets to LibreOffice

seven, pavlog: do you still repro? If so, with what steps?

Arch Linux 64-bit, X11
Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
7.5.2-1
Calc: CL threaded
Comment 5 ady 2023-04-25 01:09:56 UTC
I was able to repro when using old LO 7.1.

When testing with LO 7.4.6, the pasted cells are all OK (either merged or not), with the difference being the height and width. By dragging the respective row and column headers, I am able to set those attributes as needed.

The cells that were originally merged, end up also merged in LO 7.4.6. The cells that were originally single/normal (not merged), end up also not merged in LO 7.4.6.

IOW, width and height for cells need additional manual correction, but merged (and not merged) cells are pasted with their adequate attribute.
Comment 6 Buovjaga 2023-04-25 06:08:47 UTC
Thanks a lot, ady. As you were able to repro with an old version, it is enough to close this.