Issue 126712

Summary:

Data dublicating in cells

Product:

Calc

Reporter:

Denis <denis_levin>

Component:

open-import

Assignee:

AOO issues mailing list <issues>

Status:

RESOLVED DUPLICATE

QA Contact:

Severity:

Normal

Priority:

P5 (lowest)

CC:

damjan, kschenk, pauger

Version:

4.1.2

Keywords:

interop_OOXML, ms_interoperability

Target Milestone:

---

Hardware:

All

OS:

Windows, all

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
source data file	none
correct data display in ms excel viewer app	none
invalid data display in win 7 OpenOffice calc app	none
invalid data display in win 8 OpenOffice calc app	none

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. ***

Comment 8 damjan 2023-01-31 00:43:34 UTC

This is another duplicate of bug 124928.

The fix has been cherry-picked into the AOO41X branch and should appear in the
upcoming 4.1.14 release.

Resolving duplicate.

Thank you for your bug report and sample document :-).

*** This issue has been marked as a duplicate of issue 124928 ***