Issue 123306

Summary: cell contents duplicated when opening xlsx
Product: Calc Reporter: ville.jarvensivu
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: chip, daniel_j_lema, elish, issues, kschenk, mgilb999, Peter.Binney, wrpower123
Version: 4.0.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Cell contents of "CJ1" are duplicated multiple times in OO > 3.4.1
none
to-do list demonstrating duplicated contents in cells
none
Sample file with the same sympthom
none
Very small file that illustrates problem
none
File showing the problem
none
Libre Office can read the file without problem
none
Google Docs can read the file without problem none

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
Comment 12 peterB 2018-04-20 18:10:33 UTC
Created attachment 86392 [details]
Google Docs can read the file without problem