Bug 132628 - Copy table with merged cells from Writer to Calc doesn't preserve table layout
Summary: Copy table with merged cells from Writer to Calc doesn't preserve table layout
Status: RESOLVED DUPLICATE of bug 101313
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Writer-Tables
  Show dependency treegraph
 
Reported: 2020-05-03 10:10 UTC by Zayed
Modified: 2024-02-16 05:49 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
table in odt (18.56 KB, application/vnd.oasis.opendocument.text)
2020-05-03 10:10 UTC, Zayed
Details
Calcu output after paste the table (20.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-05-03 10:10 UTC, Zayed
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Zayed 2020-05-03 10:10:08 UTC
Created attachment 160271 [details]
table in odt

When copy table with merging cells from Writer to Calc, the table losses its overall layout. 

Please see the attached files. Try to copy the table from Writer to Calc.
Comment 1 Zayed 2020-05-03 10:10:51 UTC
Created attachment 160272 [details]
Calcu output after paste the table
Comment 2 Ming Hua 2020-05-04 02:35:06 UTC
Reproduced in 6.4.4 RC1:
版本: 6.4.4.1 (x64)
Build ID: b50bc319eca5cd5b66fbfe2ebd0d3bd1eed099b5
CPU 线程: 2; 操作系统: Windows 10.0 Build 18363; UI 渲染: 默认; VCL: win; 
区域语言: zh-CN (zh_CN); UI 语言: zh-CN
Calc: threaded
Comment 3 Ming Hua 2020-05-04 22:48:23 UTC
According to bug 98440, copying merged cells doesn't even work from one part of a table to another part inside Writer, so no surprise it dosn't work from Writer to Calc either.
Comment 4 BogdanB 2022-01-27 20:59:05 UTC
Ming Hua, I tried to copy the table from Writer to a new Writer and no problem.

But of course, the bug is still active with pasting to Calc.


I retested the bug.

REPRO in
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 2f4f4cbeb8e50081d607b86b0475b93971c40ab8
CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 5 QA Administrators 2024-01-28 03:14:00 UTC Comment hidden (obsolete)
Comment 6 Zayed 2024-01-31 13:09:42 UTC
Still exist in version: 7.6.4.1 (X86_64) / LibreOffice Community
Comment 7 ady 2024-01-31 14:39:27 UTC
The problem seems to depend on where exactly the merged cells in the original Writer table are located in relation to the selected area to be copied.

So, for instance, a writer table such as:

| a1 | b1 | c1 |
|  a2&b2  | c2 |
| a3 | b3 | c3 |

... should be pasted correctly on Calc. But when selecting in the same Writer table only from cell A2 (merged with B2) to cell C3 and only copying that partial area, the pasted result is incorrect, with the original cell A3 being merged with B3 in the resulting Calc area and the rest of the cells in the same row shifted to the right.

This is just one example. Similar inconsistencies can be seen when the merged range is located in the last selected column (as in attachment 160271 [details] from comment 0), compared to having additional columns (to the right) after the merged cells.

IOW, the location of the resulting merged attribute in Calc depends on the location of the merged cells in relation to the selected area in Writer, which is evidently a bug. This is especially noticed when the merged area is located on the "limit" of the selected area in the Writer's table (but not necessarily only in such cases).
Comment 8 Kevin Suo 2024-02-16 05:49:15 UTC

*** This bug has been marked as a duplicate of bug 101313 ***