Issue 124928 - Particular .xlsx Cell contents multiplied within cell
Summary: Particular .xlsx Cell contents multiplied within cell
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.0
Hardware: All All
: P3 Major (vote)
Target Milestone: 4.1.14
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: regression
: 119916 123154 123306 123328 125343 126712 128257 (view as issue list)
Depends on:
Blocks:
 
Reported: 2014-05-19 09:57 UTC by fanyuzhen
Modified: 2023-01-31 12:43 UTC (History)
11 users (show)

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

Attachments
XLSX file with data filter (99.78 KB, application/unknown)
2014-05-19 10:04 UTC, fanyuzhen 		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 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!