Created attachment 117466 [details] 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
Created attachment 117467 [details] Table without merged cells in first row
Created attachment 117468 [details] Inserted table with merged cells in first row in LibreOffice 4.2
Created attachment 117469 [details] Inserted table with merged cells in first row in LibreOffice 3.5
Please could you explain exactly what is the issue and step by step how to reproduce it.
Created attachment 117482 [details] Inserted table with merged cells in first row in LibreOffice 4.2
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
Problem exist in LibreOffice 4.4.4.3 from https://launchpad.net/~libreoffice/+archive/ubuntu/ppa
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?
From HTML table "Table with merged cells in first row"
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.
Title was changed
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.
** 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
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
I can reproduce it in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
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
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
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!
This looks like a duplicate of the bug 67883.
*** Bug 67883 has been marked as a duplicate of this bug. ***
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
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.
Pending review https://gerrit.libreoffice.org/c/core/+/129550 for 7-3
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.
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.
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.