Bug 170332 - FILESAVE XLSX to ODS: Form control anchoring changes
Summary: FILESAVE XLSX to ODS: Form control anchoring changes
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
26.8.0.0 alpha0+ master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: QA:needsComment
Keywords:
Depends on:
Blocks: XLSX-Form-Controls
  Show dependency treegraph
 
Reported: 2026-01-13 19:42 UTC by Gabor Kelemen (Collabora)
Modified: 2026-01-29 10:24 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
The original xlsx attachment saved as ODS (15.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2026-01-13 19:42 UTC, Gabor Kelemen (Collabora)
Details
Anchoring setting in the original XLSX file (184.57 KB, image/png)
2026-01-13 19:43 UTC, Gabor Kelemen (Collabora)
Details
Anchoring setting in the saved ODS file (181.42 KB, image/png)
2026-01-13 19:43 UTC, Gabor Kelemen (Collabora)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (Collabora) 2026-01-13 19:42:55 UTC
Created attachment 205036 [details]
The original xlsx attachment saved as ODS

This is related to bug 169997

When attachment 204666 [details] is saved as ODS, the Anchor setting of the shapes changes from "To Cell" to "To Page", which makes them behave differently if a new line is inserted above them.

1. Open attachment 204666 [details]
2. Enable Tools - Forms - Design Mode
3. Right click on a checkbox, select Control Properties
-> In the Anchor dropdown notice the value "To Cell"
4. Save as ODS, reload
5. Enable Tools - Forms - Design Mode
6. Right click on a checkbox, select Control Properties
-> In the Anchor dropdown notice the value "To Page"

Version: 26.2.0.1.0+ (X86_64)
Build ID: bdc4b4cafd092ead7eb5a0fc67d02b9c289f8df7
CPU threads: 32; OS: Linux 6.14; UI render: default; VCL: gtk3
Locale: hu-HU (hu_HU.UTF-8); UI: en-US
Calc: threaded
Comment 1 Gabor Kelemen (Collabora) 2026-01-13 19:43:18 UTC
Created attachment 205037 [details]
Anchoring setting in the original XLSX file
Comment 2 Gabor Kelemen (Collabora) 2026-01-13 19:43:47 UTC
Created attachment 205038 [details]
Anchoring setting in the saved ODS file