Bug 162366 - Incorrect reference location in Word file with embedded Excel (edited on Mac)
Summary: Incorrect reference location in Word file with embedded Excel (edited on Mac)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: OLE-Objects
  Show dependency tree / graph
 
Reported: 2024-08-06 03:52 UTC by Saburo
Modified: 2024-12-12 16:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Samplefile(mac_word) (37.32 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2024-08-06 03:53 UTC, Saburo 		Details
Samplefile(win_word) (29.10 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2024-08-06 03:55 UTC, Saburo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Saburo 2024-08-06 03:52:34 UTC 
Description:
This happens in files edited with Word on a Mac,
but not in files edited with Word on Windows.

Steps to Reproduce:
1.Open Samplefile


Actual Results:
Embedded table displays A1:E3

Expected Results:
Show D6:G8


Reproducible: Always


User Profile Reset: No

Additional Info:
https://ask.libreoffice.org/t/pdf/108834

Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c60dd66d89dab2174aa71c26c653f68908c7ba78
CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Calc: threaded
Comment 1 Saburo 2024-08-06 03:53:38 UTC 
Created attachment 195729 [details]
Samplefile(mac_word)
Comment 2 Saburo 2024-08-06 03:55:01 UTC 
Created attachment 195730 [details]
Samplefile(win_word)

Although I don't think it's necessary, I've also attached a version I edited in Word on Windows.
Comment 3 m_a_riosv 2024-08-06 20:09:39 UTC 
Reproducible
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f7197e574cdbd7410fcadab1632bcce2626dca5a
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 4 Saburo 2024-10-10 03:24:49 UTC 
The cause seems to be that the topLeftCell is not written in the sheetView of the embedded Excel created in Word on a Mac.

If topLeftCell is not written, how about getting it from the oleSize ref in workbook.xml, or displaying media/image1.emf when opened?