Bug 161000

Summary:	Form controls (anchored to page) misplaced (shifted down) in XLSX file
Product:	LibreOffice	Reporter:	nengxing_xu <nengxing_xu>
Component:	filters and storage	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	stephane.guillou
Priority:	medium	Keywords:	filter:xlsx
Version:	4.0.0.3 release
Hardware:	x86-64 (AMD64)
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	133999
Attachments:	source excle file image show error comparison LO 24.8alpha0+ (left) and MS 365 (right)

Description nengxing_xu 2024-05-09 02:17:18 UTC

Description:
After converting the Excel file to PDF, the form fields are misplaced.

Actual Results:
After converting the Excel file to PDF, the form fields are misplaced.

Expected Results:
After converting the Excel file to PDF, the form fields Need the correct


Reproducible: Always


User Profile Reset: No

Additional Info:
No more information

Comment 1 nengxing_xu 2024-05-09 02:18:40 UTC

Created attachment 194040 [details]
source excle file

Comment 2 nengxing_xu 2024-05-09 02:19:06 UTC

Created attachment 194041 [details]
image show error

Comment 3 Stéphane Guillou (stragu) 2024-05-09 03:29:23 UTC

Reproduced that the checkboxes are shifted down compared to the file opened in Excel. (No need to export to PDF to see the issue.)

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 92815f3a464b447898ecf52492247335228e4a72
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: CL threaded

Same on Windows 11.

Already the case in LO 4.0.0.3.

Comment 4 Stéphane Guillou (stragu) 2024-05-09 03:31:10 UTC

Created attachment 194044 [details]
comparison LO 24.8alpha0+ (left) and MS 365 (right)

Comparison between LO and MS 365. Note the shift down for all checkboxes.
Position setting in MS 365 is "move but don't size with cells".
In LO, controls are anchored to page.