Issue 123154 - Xlsx text is erroneously replicated multiple times within a single cell
Summary: Xlsx text is erroneously replicated multiple times within a single cell
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.0.0
Hardware: PC Windows XP
: P3 Major with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-09-01 02:53 UTC by Bob
Modified: 2014-09-18 08:49 UTC (History)
3 users (show)

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

Cells B521:B538 of 2010 Jan. 19 105 KB Perkins_books.xlsx (12.61 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-09-01 02:53 UTC, Bob
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Bob 2013-09-01 02:53:14 UTC
Created attachment 81422 [details]
Cells B521:B538 of 2010 Jan. 19 105 KB Perkins_books.xlsx

his bug appears to be a more severe and widespread manifestation of bug 119916, which is, as of this bug report, open on OO3.4.  No instability appears to be created in either the app or OS.

Multiple extraneous copies of the text in 3 of the 18 occupied cells of the attached single-column Excel spreadsheet are displayed by Open Office Calc 4.0.0 (Apache Open Office Version 4.0.0 Milestone A00400m3 Build ID 9702 SVN r1503704) but none of these errors are displayed by either 3.3.0 or Excel.  In each problematic cell, extra copies appear appended to the correct text in the font of the “square root” symbol that ends the correct text.  However, that trailing symbol also appears in the correctly displayed cell of row 18.   This 4.0.0 problem was first observed in a much larger xlsx.  It it, most but not all cells with the red trailing “square root” symbol exhibit the problem.  In that xlsx, the problem -- always manifest in a single cell -- typically involves many more replications than just one: even 30 replications or more.

In an attempt to attach a minimal example of the problem, I found that the problem does not persist in very small excerpts of the original xlsx.  Conversely, after I deleted rows and columns of the source xlsx to create the attached xlsx, the formerly correctly displayed cell in row 14 now ironically also exhibits the problem.  In general, the appearance of the problem in a given cell seems dependent on other cells not necessarily adjacent.

In the original xlsx the red “square root” symbol is not the only apparent trigger of replicated text.  Sometimes (but not in the attached xlsx) a cell with a hypertext link (and blue on gray colors) exhibits the problem.  The only other, similarly occasional, trigger of the problem is apparently the presence, in the affected cell, of at least some text with an orange color.  Almost every cell with replication has at least some colored text.  The converse is not true, and in the original xlsx there is at least one cell with replication but only black text.

Running XP Pro V2002 SP3 32-bit
Comment 1 Edwin Sharp 2013-09-01 05:37:22 UTC
Text is duplicated in cells A4, A7, A14.

Rev. 1516794 Win 7
Comment 2 hhue13 2014-09-18 08:49:29 UTC
I see the same problem on Apache OO 4.1.1 on RHEL 6.5.