Bug 161000 - Form controls (anchored to page) misplaced (shifted down) in XLSX file
Summary: Form controls (anchored to page) misplaced (shifted down) in XLSX file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Form-Controls
  Show dependency tree / graph
 
Reported: 2024-05-09 02:17 UTC by nengxing_xu
Modified: 2024-05-09 03:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
source excle file (517.20 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-05-09 02:18 UTC, nengxing_xu 		Details
image show error (332.86 KB, image/png)
2024-05-09 02:19 UTC, nengxing_xu 		Details
comparison LO 24.8alpha0+ (left) and MS 365 (right) (367.28 KB, image/png)
2024-05-09 03:31 UTC, Stéphane Guillou (stragu) 		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 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.