[upstream] Calc doesn't merge cells when pasting merged content from HTML

[Roman Shipovskij]

1) lsb_release -rd
Description: Ubuntu 15.10
Release: 15.10

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:5.0.2-0ubuntu1
  Candidate: 1:5.0.2-0ubuntu1
  Version table:
 *** 1:5.0.2-0ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ wily/main amd64 Packages
        100 /var/lib/dpkg/status

3) What is expected to happen is when one opens the following URL via Firefox https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1417534/+attachment/4311118/+files/table_with_merged_cells_in_first_row.html > highlights all content in the top row > paste into Calc then A1 contains:
Cell1

and B1 and C1 are merged together containing:
Cell2 + 3

as it does in Excel 2013.

4) What happens instead is that while cell A1 contains Cell1, B1 and C1 are not merged, and B1 contains Cell2 + 3.

Originally reported on LO 4.2, and reported to not exist in LO 3.5.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Rolf Leggewie (r0lf)]

This ticket would likely benefit if somebody reported the issue upstream at https://bugs.documentfoundation.org/

I'll leave a pointer here to document how to "install" the latest upstream release alongside the Ubuntu version -> https://wiki.documentfoundation.org/Installing_in_parallel/Linux

[Roman Shipovskij (roman-shipovskij)]

Created attachment 117466
Table with merged cells in first row

LibreOffice Calc have problem with inserting table with merged cells in first row.

Problem exists in all version >= 4.2 (Ubuntu 14.04 and latest).

Problem does not exists in version 3.5 (Ubuntu 12.04).

How to reproduce:
1) copy table with merged cells in first row
2) insert it in LibreOffice Calc

[Roman Shipovskij (roman-shipovskij)]

Created attachment 117467
Table without merged cells in first row

[Roman Shipovskij (roman-shipovskij)]

Created attachment 117468
Inserted table with merged cells in first row in LibreOffice 4.2

[Roman Shipovskij (roman-shipovskij)]

Created attachment 117469
Inserted table with merged cells in first row in LibreOffice 3.5

[Roman Shipovskij (roman-shipovskij)]

Upsteram bug report:
https://bugs.documentfoundation.org/show_bug.cgi?id=92960

[Miguelangelrv (miguelangelrv)]

Please could you explain exactly what is the issue and step by step how to reproduce it.

[Roman Shipovskij (roman-shipovskij)]

Created attachment 117482
Inserted table with merged cells in first row in LibreOffice 4.2

[Roman Shipovskij (roman-shipovskij)]

Sorry, I attached wrong file "Inserted table with merged cells in first row in LibreOffice 4.2", I replaced it.

How to reproduce:
1) copy table with merged cells in first row (attached)
2) insert it in LibreOffice Calc >= 4.2

inserted table should look as in file:
"Inserted table with merged cells in first row in LibreOffice 3.5"

but it look as in file:
"Inserted table with merged cells in first row in LibreOffice 4.2"

problem exist only if table contain merged cells in first row

[Roman Shipovskij (roman-shipovskij)]

Problem exist in LibreOffice 4.4.4.3 from https://launchpad.net/~libreoffice/+archive/ubuntu/ppa

[Miguelangelrv (miguelangelrv)]

From which version are you copying?
Or are you opening the file with 4.2 and pasting in a new file created inside 4.2?

[Roman Shipovskij (roman-shipovskij)]

From HTML table "Table with merged cells in first row"

[Miguelangelrv (miguelangelrv)]

Well seems that the issue is pasting (not the same than inserting) from HTML into a spreadsheet.

For me the issue happens not only in the first, but when the merged cells include the last cell in the row. For example in the fifth row.

Please change the title for a better explanation about the issue.

[Roman Shipovskij (roman-shipovskij)]

Title was changed

[penalvch (penalvch)]

I'm going to provide a revamped Description, given it wasn't as obvious as possible what the problem was as originally described:
What is expected to happen is when one opens the following URL via Firefox https://bugs.documentfoundation.org/attachment.cgi?id=117466 > highlights all content in the top row > paste into Calc then A1 contains:
Cell1

and B1 and C1 are merged together containing:
Cell2 + 3

as it does in Excel 2013.

What happens instead is that while cell A1 contains Cell1, B1 and C1 are not merged, and B1 contains Cell2 + 3.

[Qa-admin-q (qa-admin-q)]

** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of LibreOffice
(5.2.5 or 5.3.0 https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of LibreOffice and
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword

Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20170306

[Roman Shipovskij (roman-shipovskij)]

The bug is still present on:

Ubuntu 16.04, LibreOffice 5.2.5.1 from https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-5-2

Ubuntu 16.04, LibreOffice 5.3.0.3 from https://launchpad.net/~libreoffice/+archive/ubuntu/ppa

Windows 10, LibreOffice 5.2.5.1

Windows 10, LibreOffice 5.3.0.3

The bug does not present on LibreOffice 3.5 and lower, it's a regression

[Xiscofauli (xiscofauli)]

I can reproduce it in

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

[Roman Shipovskij (roman-shipovskij)]

From http://downloadarchive.documentfoundation.org/libreoffice/old/

Version 3.6.7.2 (Build ID: e183d5b) - last version without bug
Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) - first version with bug

[Beluga (beluga)]

Still repro.

Arch Linux 64-bit
Version: 6.1.0.0.alpha1+
Build ID: 5956828c88501ef1366e60010b05053a8e1e642e
CPU threads: 8; OS: Linux 4.16; UI render: default; VCL: kde4;
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on May 23rd 2018

[Beluga (beluga)]

Unfortunately, the commit range includes such that make LibreOffice crash upon pasting. Used 43all repo.

There are only 'skip'ped commits left to test.
The first bad commit could be any of:
866567b8f6f645b3fd67aff5e493460c63c5bfa4
8f4aeaad2f65d656328a451154142bb82efa4327
9ce5b0d85edd56bb90464833eb52c0b274449c32
a72763112e846bcb1c4e4c6f1612ccab6ac73772
52abf2b644b9c2396246581d02b1796dd9cd2dff
8641cbd807db765b43d4b98f8865ebf34bc1c4ca
241d451e09694446622f9767fb76db50481c9e32
77e720fb6d169639d8efe43613ae517dd3490394
21334bea86b7167cacd2c436f91b405fcdc83b98
98e26b741cd0eff4b7549d782d7db5a1e98eb1a6
458ab868acbc40422ffe2093f3dd28c8bfac3305
ba2b3f1f9d9e4a2edd571a16dab7746bd17ee03a
5bac99c03c8d9c687c11c53285a65e79af6c8ef5
6d8bd8dba8e0b0a4c2efd95b03c2b5656646bf33
7d3d1a6f00503d8d402f5069e746ec5eb492a096
bf9969effb2f759d95ecbb1a688e25f75a78da16
2da15b0933b13a6a96a60bf2f84cfd1d012051e0
2e349599ef946cf01cfe40929509254c596fdca3
0e54cced22ee8d216a783202cf26384317db0959
cf8644ffc4c66e8567e9c4be706caac879032caf
7d63b17e3d3fe488e34de32ffa042559dbad3cfd
d2720e99b9e6cb7b099256cc7a6d2b3f907b8d7c
77c163b8bed3972f153b1fbb7fdcd956073f4873
a035fba5e34dc12e2b1796af6ec46f04647a3576
03a729c328bfa2eafca37f1a2d0796c6575b9e61
18518588d8414f446ece5591944766f5082ebef5
44ae604621f386a254b6c8fb7599b2c176245149
80860139a96019d7487e02c7b488a8990e1e524f
bc819bc0c4d8592212f84069eb7f65e539517166
We cannot bisect more!

[John100 (john100)]

This looks like a duplicate of the bug 67883.

[Beluga (beluga)]

*** Bug 67883 has been marked as a duplicate of this bug. ***

[Stéphane Guillou (stephane-guillou)]

Reproducible in LO 7.0.0 as per comment 12.

Version: 7.0.0.3
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

[Libreoffice-commits (libreoffice-commits)]

Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/8a9b870a40c41c7cae6e43452b593804fa17f831

Resolves: tdf#74577 tdf#92960 Create missing offsets in very outer table

It will be available in 7.4.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

[Eike Rathke (erack)]

Pending review https://gerrit.libreoffice.org/c/core/+/129550 for 7-3

[Libreoffice-commits (libreoffice-commits)]

Eike Rathke committed a patch related to this issue.
It has been pushed to "libreoffice-7-3":

https://git.libreoffice.org/core/commit/2ea7055ea6115051a92c66a439b02d83bb067db7

Resolves: tdf#74577 tdf#92960 Create missing offsets in very outer table

It will be available in 7.3.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

[Libreoffice-commits (libreoffice-commits)]

Xisco Fauli committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/04c0a05f58618f53e1be83856ebc2b615066391a

tdf#74577 tdf#92960: sc: Add UItest

It will be available in 7.4.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

[Libreoffice-commits (libreoffice-commits)]

Eike Rathke committed a patch related to this issue.
It has been pushed to "libreoffice-7-2":

https://git.libreoffice.org/core/commit/23821b60107d4d2e46f8f0e17b016bc84379b29e

Resolves: tdf#74577 tdf#92960 Create missing offsets in very outer table

It will be available in 7.2.6.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.