Issue 124928

Summary: Particular .xlsx Cell contents multiplied within cell
Product: Calc Reporter: fanyuzhen
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CLOSED FIXED QA Contact:
Severity: Major    
Priority: P3 CC: clarence.guo.bj, denis_levin, jake, jody.diamond, liushenf, mgilb999, mseidel, r.gildea, rainerbielefeld_ooo_qa, shanzhu33, ville.jarvensivu
Version: 4.1.0Keywords: regression
Target Milestone: 4.1.14   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
XLSX file with data filter none

Description fanyuzhen 2014-05-19 09:57:12 UTC 
Steps:
1. Open attached .xlsx file which has filter to Calc
2. Check cell C68

Problem: content in cell C68 displays repeatedly
Comment 1 fanyuzhen 2014-05-19 10:04:47 UTC 
Created attachment 83417 [details]
XLSX file with data filter
Comment 2 Rainer Bielefeld 2014-05-19 12:20:30 UTC 
Reproducible with server installation of "AOO 4.1.0-dev – English UI / German locale - [AOO410m14(Build:9760)  -  Rev. 1583418 2014-05-03]" on German WIN7 Home Premium (64bit)", own separate user profile.

When I open document with AOO string in cell C68 "华南理工大学" will be shown as 18 times "华南理工大学" (without separators).

(a) No problem with 3.3.0, so REGRESSION.
(b) If useful I can narrow down version of appearance.
(c) Looks ok with Kingsoft Spreadsheet and MS Excel viewer, also LibO 4.2 not
   affected
Comment 3 SVN Robot 2014-05-26 03:03:15 UTC 
"clarence_guo" committed SVN revision 1597503 into trunk:
for #i124928, rich text portion could be converted several times, each time w...
Comment 4 Clarence GUO 2014-05-26 03:05:10 UTC 
Fixed and change status
Comment 5 Clarence GUO 2014-05-27 01:36:10 UTC 
When text in a cell has different format, it will divided into several text portions. Each portion will be converted once when finalizeImport is called. It is possible that the finalizeImport is called several times which means the conversion also could be called several times. But in the conversion, the portion string is inserted instead of rewrite. Hence in such scenario, the text portion was repeatedly inserted.
Add a flag to avoid repeated conversion.
Comment 6 damjan 2023-01-31 00:03:18 UTC 
*** Issue 123306 has been marked as a duplicate of this issue. ***
Comment 7 damjan 2023-01-31 00:26:45 UTC 
*** Issue 125343 has been marked as a duplicate of this issue. ***
Comment 8 damjan 2023-01-31 00:31:26 UTC 
*** Issue 128257 has been marked as a duplicate of this issue. ***
Comment 9 damjan 2023-01-31 00:36:56 UTC 
*** Issue 119916 has been marked as a duplicate of this issue. ***
Comment 10 damjan 2023-01-31 00:39:11 UTC 
*** Issue 123154 has been marked as a duplicate of this issue. ***
Comment 11 damjan 2023-01-31 00:43:35 UTC 
*** Issue 126712 has been marked as a duplicate of this issue. ***
Comment 12 damjan 2023-01-31 00:58:12 UTC 
*** Issue 123328 has been marked as a duplicate of this issue. ***
Comment 13 Matthias Seidel 2023-01-31 12:43:50 UTC 
Cherry-picked by Damjan for AOO41X with:
https://github.com/apache/openoffice/commit/768bfd82c2396d947d0a3b8ab5aa44cfe31f4111

Great find, thanks!