Issue 126712 - Data dublicating in cells
Summary: Data dublicating in cells
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.2
Hardware: All Windows, all
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: interop_OOXML, ms_interoperability
: 127748 (view as issue list)
Depends on:
Blocks:
 
Reported: 2015-11-30 10:42 UTC by Denis
Modified: 2018-04-05 19:19 UTC (History)
2 users (show)

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


Attachments
source data file (14.83 KB, application/zip)
2015-11-30 10:42 UTC, Denis
no flags Details
correct data display in ms excel viewer app (893.32 KB, image/jpeg)
2015-11-30 10:46 UTC, Denis
no flags Details
invalid data display in win 7 OpenOffice calc app (758.39 KB, image/jpeg)
2015-11-30 10:50 UTC, Denis
no flags Details
invalid data display in win 8 OpenOffice calc app (705.68 KB, image/jpeg)
2015-11-30 10:53 UTC, Denis
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Denis 2015-11-30 10:42:19 UTC
Created attachment 85181 [details]
source data file

we are expiriencing some problems during use of openoffice calc application.
the problem is duplicating values inside the cells. 

For ex: cell A1 contains  value = 'Value1'.

We see: A1 contains 'Value1Value1' or in some cases 'Value1Value1Value1' and n-th replication of source data.

However, MS Excel Viewer displays data correctly: 
http://joxi.ru/nAy8kYWuOBY12Z

But openoffice calc displays data in strange way!
http://joxi.ru/bmoVD3EhMNwEqr ( windows 7 )

http://joxi.ru/xAe0Lybu0bQk2y ( windows 8 )
Comment 1 Denis 2015-11-30 10:46:50 UTC
Created attachment 85182 [details]
correct data display in ms excel viewer app
Comment 2 Denis 2015-11-30 10:50:52 UTC
Created attachment 85183 [details]
invalid data display in win 7  OpenOffice calc app
Comment 3 Denis 2015-11-30 10:53:31 UTC
Created attachment 85184 [details]
invalid data display in win 8 OpenOffice calc app
Comment 4 Denis 2015-11-30 10:55:00 UTC
we have additionally attached files with screenshots of errors.
Comment 5 orcmid 2015-11-30 17:37:50 UTC
The behavior is confirmed with Apache OpenOffice 4.1.2, on Windows 10 Pro x64 en_US.

The behavior is not seen with LibreOffice 5.0 x64.

A peculiar aspect of the effect is that it applies in distinct blocks of rows.  Cells in the last two rows are fine, cell in preceding rows show cells as having the values being the same string twice, and then, working up to the top rows, expansion of the value can be as much as with 4 copies of the value.  See column B.

If the file is saved as a .ods, the resulting file has the defect (and it is seen when opened in Excel 2016 also), suggesting that it is the cell values that have been imported incorrectly by AOO.  The result is not a presentation defect.

If the .xlsx file is saved in .ods format from Excel 2016, that file opens correctly in AOO 4.1.2 with respect to the observed defect.
Comment 6 Kay 2015-11-30 18:15:31 UTC
Likely problems with incomplete interoperability with OOXML from AOO 4.1.2.
Comment 7 oooforum (fr) 2018-04-05 16:22:56 UTC
*** Issue 127748 has been marked as a duplicate of this issue. ***