Apache OpenOffice (AOO) Bugzilla – Issue 123306
cell contents duplicated when opening xlsx
Last modified: 2023-01-31 00:03:18 UTC
Created attachment 81585 [details] Cell contents of "CJ1" are duplicated multiple times in OO > 3.4.1 Overview: Sometimes cell-contents are corrupted when opening certain .xlsx (contents are duplicated multiple times in same cell) Actual Results: "CJ1"-cell contents: "Low dust -logoLow dust -logoLow dust -logo" Expected Results: "CJ1"-cell contents: "Low dust -logo" OS: Mac OS X 10.6.8 (and 10.8.4) Build Date & Hardware: 3.4.1 Build: 9593 ... bug is present in 4.0 (Build: 9702) Additional Builds and Platforms: Last version that I found contents correct: stable version: 3.3.0 (Build: 9567) OS X 10.6.8 (and latest 10.8.4) Steps to reproduce: Open attached .xlsx and check cell "CJ1" Additional info: might relate to newline's inside cell.
Low dust vs. Low dust -logoLow dust -logoLow dust -logo Excel 2010 and Calc Rev. 1523756 Win 7
I have a much more extensive example if it would assist the developers working on this problem.
(In reply to Chip Davis from comment #2) > I have a much more extensive example if it would assist the developers > working on this problem. Yes please.
Created attachment 83072 [details] to-do list demonstrating duplicated contents in cells Hope this helps. This is quite repeatable.
Created attachment 83432 [details] Sample file with the same sympthom
Testing with -- AOO411m4(Build:9774) - Rev. 1614049 2014-07-28 17:54 - Linux i686 and confirmed the problem still persists.
Created attachment 84439 [details] Very small file that illustrates problem If the attached file is opened by Calc (4.1.1) the contents of cells in column A are corrupted. The problem disappears if any row is deleted or the contents of any cell cleared. Adding more rows doesn't fix the problem.
The problem persists in 4.1.2 Easily reproducable in the file I attached Jan 19, 2015.
And it is still there in 4.1.5 For instance, when the attached file (Excel_cellTextDuplication.xlsx) is opened the contents of all (I think) the cells is duplicated. This does not happen using Libre Office or Google docs (I attach .ods files after opening and saving using both these: Excel_cellTextDuplication-LibreOffice.ods and Excel_cellTextDuplication-GoogleDocs.ods). Makes OOO look more and more creaky I'm afraid!
Created attachment 86390 [details] File showing the problem
Created attachment 86391 [details] Libre Office can read the file without problem
Created attachment 86392 [details] Google Docs can read the file without problem
This text duplication bug only happens on the 4.1.x releases. On the trunk branch, it's fixed, but we don't know by which commit...
I downloaded file showing the problem.xlsx and it opens in AOO 4.1.13 without duplicating anything - there is no difference between AOO and LO 7.3.7.2.
I tested the file "problem.xlsx" on Windows with AOO (3.3.0; 4.1.1; 4.1.13; 4.2dev) and LO (7.3.7.2). The result varies - see the attached juxtaposition.
Created attachment 87168 [details] screenshots AOO & LO
I managed to build some old OpenOffice versions on Windows to investigate this bug further. These were the results: ---> AOO4113-GA / BAD / -----------------------------------> AOO41X / BAD? / / ----> merge-base -->-----+----------------------------> trunk 25 Feb 2014 2ed47956e3e GOOD BAD 29 Aug 2015 GOOD By backporting 8-9 patches (from https://wiki.openoffice.org/wiki/Building_old_versions), I managed to build the merge-base between AOO41X and trunk (f331e23ffae9e26f93997dc8f02086c5733e80df) from 25 Feb 2014, as well as a nearby commit, 2ed47956e3ec22116d5164494008afeac3f699a1 from 29 Aug 2015. The merge-base also shows the text duplication, but it's fixed by 2ed47956e3e, 550 days later. 514 commits happened in that time frame. Nothing jumps out at me, looking through the list of commits, nor through Bugzilla bugs closed in that time frame. "git bisect" would need 10 more steps, possibly more as the alg_writeframes branch was merged during that time. I'll see what I can do to narrow it down further.
---> AOO4113-GA / BAD / -----------------------------------> AOO41X / BAD? / / ----> merge-base -->------+----------+-----------+---------> trunk 25 Feb 2014 1b68054a318a 6dd50e53129ad 2ed47956e3e GOOD BAD 19 May 2014 21 Oct 2014 29 Aug 2015 BAD GOOD GOOD It was fixed between 1b68054a318a and 6dd50e53129ad.
I finally found it. This issue was fixed on trunk on 26 May 2014 by commit c0670b14b16dba0137a280c9aabcadc554988f08, which makes it a duplicate of bug 124928. However that fix was never applied to the AOO41X branch so all 4.1.X releases were broken. I've now cherry-picked it into AOO41X in commit 768bfd82c2396d947d0a3b8ab5aa44cfe31f4111, and it should appear in the upcoming 4.1.14 release. Resolving duplicate. Thank you for your bug report and sample documents. *** This issue has been marked as a duplicate of issue 124928 ***