Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||cell contents duplicated when opening xlsx|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||chip, daniel_j_lema, elish, issues, kschenk, mgilb999, Peter.Binney, wrpower123|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description ville.jarvensivu 2013-09-20 10:00:11 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.
Comment 1 Edwin Sharp 2013-09-20 12:14:22 UTC
Low dust vs. Low dust -logoLow dust -logoLow dust -logo Excel 2010 and Calc Rev. 1523756 Win 7
Comment 2 Chip Davis 2014-04-03 08:32:53 UTC
I have a much more extensive example if it would assist the developers working on this problem.
Comment 3 Edwin Sharp 2014-04-03 08:41:59 UTC
(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.
Comment 4 Chip Davis 2014-04-03 14:25:03 UTC
Created attachment 83072 [details] to-do list demonstrating duplicated contents in cells Hope this helps. This is quite repeatable.
Comment 5 Daniel Lema 2014-05-20 14:36:07 UTC
Created attachment 83432 [details] Sample file with the same sympthom
Comment 6 Kay 2014-08-02 22:32:13 UTC
Testing with -- AOO411m4(Build:9774) - Rev. 1614049 2014-07-28 17:54 - Linux i686 and confirmed the problem still persists.
Comment 7 Bill Power 2015-01-19 09:24:09 UTC
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.
Comment 8 Bill Power 2016-03-11 10:41:57 UTC
The problem persists in 4.1.2 Easily reproducable in the file I attached Jan 19, 2015.
Comment 9 peterB 2018-04-20 18:07:27 UTC
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!
Comment 10 peterB 2018-04-20 18:08:37 UTC
Created attachment 86390 [details] File showing the problem
Comment 11 peterB 2018-04-20 18:09:49 UTC
Created attachment 86391 [details] Libre Office can read the file without problem