Apache OpenOffice (AOO) Bugzilla – Issue 124928
Particular .xlsx Cell contents multiplied within cell
Last modified: 2023-01-31 12:43:50 UTC
Steps: 1. Open attached .xlsx file which has filter to Calc 2. Check cell C68 Problem: content in cell C68 displays repeatedly
Created attachment 83417 [details] XLSX file with data filter
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
"clarence_guo" committed SVN revision 1597503 into trunk: for #i124928, rich text portion could be converted several times, each time w...
Fixed and change status
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.
*** Issue 123306 has been marked as a duplicate of this issue. ***
*** Issue 125343 has been marked as a duplicate of this issue. ***
*** Issue 128257 has been marked as a duplicate of this issue. ***
*** Issue 119916 has been marked as a duplicate of this issue. ***
*** Issue 123154 has been marked as a duplicate of this issue. ***
*** Issue 126712 has been marked as a duplicate of this issue. ***
*** Issue 123328 has been marked as a duplicate of this issue. ***
Cherry-picked by Damjan for AOO41X with: https://github.com/apache/openoffice/commit/768bfd82c2396d947d0a3b8ab5aa44cfe31f4111 Great find, thanks!