Issue 123306 - cell contents duplicated when opening xlsx
Summary: cell contents duplicated when opening xlsx
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.0.0
Hardware: All All
: P3 Normal with 5 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-09-20 10:00 UTC by ville.jarvensivu
Modified: 2018-04-20 18:10 UTC (History)
8 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Cell contents of "CJ1" are duplicated multiple times in OO > 3.4.1 (60.32 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-09-20 10:00 UTC, ville.jarvensivu 		no flags Details
to-do list demonstrating duplicated contents in cells (44.91 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-04-03 14:25 UTC, Chip Davis 		no flags Details
Sample file with the same sympthom (37.43 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-05-20 14:36 UTC, Daniel Lema 		no flags Details
Very small file that illustrates problem (8.00 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-01-19 09:24 UTC, Bill Power 		no flags Details
File showing the problem (48.27 KB, application/zip)
2018-04-20 18:08 UTC, peterB 		no flags Details
Libre Office can read the file without problem (13.57 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-04-20 18:09 UTC, peterB 		no flags Details
Google Docs can read the file without problem (31.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-04-20 18:10 UTC, peterB 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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