Bug 166724 - Checkbox anchor wrongly imported from xlsx
Summary: Checkbox anchor wrongly imported from xlsx
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Anchor-and-Text-Wrap
  Show dependency treegraph
 
Reported: 2025-05-25 18:13 UTC by Michael Zapf
Modified: 2025-06-09 12:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Demo Excel file, to be opened in Calc (12.15 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-05-25 18:13 UTC, Michael Zapf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Zapf 2025-05-25 18:13:26 UTC
Created attachment 200956 [details]
Demo Excel file, to be opened in Calc

After importing an Excel spreadsheet with a checkbox control that is anchored to a cell, the checkbox is then shown as anchored on the page instead. 

For some documents this leads to a wrong position of the checkbox on the sheet and thus makes it unusable.
Comment 1 BogdanB 2025-05-25 18:40:51 UTC
Open the file and insert a row above the checkboxes lines. 
Checkboxes are not in line with the options for them (checkboxes are wrong anchored to page).

Confirm with
Version: 25.2.3.1 (X86_64) / LibreOffice Community
Build ID: d8d1af5f77df955194e52baabe19324532ac8e8b
CPU threads: 16; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 2 BogdanB 2025-05-27 05:41:11 UTC
The anchor is imported as on page, not as on cell.

If we changed anchor to cell, everything works fine.

It is the same in
Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: a0dd1c4a363b9d4d2a16ff82acc3ada0c075cb65
CPU threads: 16; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 3 Telesto 2025-06-09 12:08:34 UTC
Also in
Version: 7.6.3.0.0+ (X86_64) / LibreOffice Community
Build ID: 35f19e5cb93ce218787904e99c2bedfd40e725cc
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded

and in 
Version:  7.0.7

and in
Versie: 4.4.7.2 
Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Locale: nl_NL