Bug 127311 - FILEOPEN DOCX: Microsoft Excel Object Worksheet in DOCX don't start a the right line
Summary: FILEOPEN DOCX: Microsoft Excel Object Worksheet in DOCX don't start a the rig...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
6.0.1.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: DOCX-OLE-Objects
  Show dependency treegraph
 
Reported: 2019-09-03 14:01 UTC by LE GARREC Vincent
Modified: 2020-04-11 15:11 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
ExcelEmbedded.docx (21.33 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2019-09-03 14:01 UTC, LE GARREC Vincent
Details
Another example document from Word13 (31.67 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2020-03-17 21:01 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description LE GARREC Vincent 2019-09-03 14:01:38 UTC
Created attachment 153841 [details]
ExcelEmbedded.docx

I have a docx edited by Microsoft Office.
In this docx, I have a embedded xlsx (Microsoft Excel Object worksheet).
When I open the document with Microsoft Office, the table starts with line 16.
When I open the document with LibreOffice, the table starts with line 1.

Steps:
1) Open Microsoft Excel
2) Create a table
3) Copy this table (don't start a line 1) in the clipboard
4) Open Microsoft Word
5) Special paste "Microsoft Excel Object Worksheet"

Here, you should see your table. First line is the right one.

6) Save your document as docx.
7) Open your document with LibreOffice.

Current behavior: The first line of the table is the first line of the excel tab, not the first line of the table in the clipboard

Expected behavior: The first line of the table is the first line of the copy in the clipboard


Version: 6.4.0.0.alpha0+ (x64)
Build ID: 41cd3e8e817c8c33a13608e62eeb06ce2c6977e4
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@62-TDF, Branch:master, Time: 2019-09-01_22:04:10
Locale: fr-FR (fr_FR); UI-Language: en-US
Calc: CL
Comment 1 Durgapriyanka 2019-09-03 16:10:11 UTC
Thank you for reporting the bug. I can reproduce the bug in 

Version: 6.3.0.0.alpha0+
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

But, when I open the document in 

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4 

the table starts with line 16.
Comment 2 m.a.riosv 2019-09-03 19:42:13 UTC
Works fine with:
Version: 5.4.6.2 (x64)
Build ID: 4014ce260a04f1026ba855d3b8d91541c224eab8
CPU threads: 4; OS: Windows 6.19; UI render: GL; 
Locale: es-ES (es_ES); Calc: group

Bad with:
Versión: 6.0.7.1 (x64)
Id. de compilación: 5d2cb2a5dd04fe174b336488731eb50bbb5faed3
Subprocs. CPU: 4; SO: Windows 10.0; Repres. IU: GL; 
Configuración regional: es-ES (es_ES); Calc: CL
Comment 3 raal 2019-09-04 15:41:53 UTC
This seems to have begun at the below commit.
Adding Cc: to Szymon Kłos; Could you possibly take a look at this one? Thanks

3e092e207e04ea141c59d25e8c71b1c74e2e1cfe is the first bad commit
commit 3e092e207e04ea141c59d25e8c71b1c74e2e1cfe
Author: Norbert Thiebaud <nthiebaud@gmail.com>
Date:   Sat Jul 29 06:24:35 2017 -0700

    source sha:505ce3a2ba3adeef46daecbf9b14c42cea211408


author	Szymon Kłos <szymon.klos@collabora.com>	2017-07-07 12:58:42 +0200
committer	Szymon Kłos <szymon.klos@collabora.com>	2017-07-08 09:28:09 +0200
commit	505ce3a2ba3adeef46daecbf9b14c42cea211408 (patch)
tree	aab90b60e9c0c0ac5b7ea912dc3b25a8c45614cf
parent	3340ce30562832b584dd0576d9e0733aa03d867f (diff)
tdf#108544 edit in window (XLSX inside DOCX)
Comment 4 NISZ LibreOffice Team 2020-03-17 21:01:33 UTC
Created attachment 158765 [details]
Another example document from Word13

Another document made in Word 13 (original is from Word16).

Here I scrolled a bit inside the embedded table after pasting it in Word, this seems to work in Writer 7 master, but the original does not.

It's interesting that in my file Word cannot edit the embedded file (it could before saving and closing), but Writer can.

Version: 7.0.0.0.alpha0+ (x64)
Build ID: 8e323fcacebad1afe9d867b846722a6b9bf20f78
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL