Apache OpenOffice (AOO) Bugzilla – Issue 123306
cell contents duplicated when opening xlsx
Last modified: 2018-04-20 18:10:33 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