Bug 135987 - FILEOPEN XLSX: Check box loses "Linked Cell" property after round-trip (comment 6)
Summary: FILEOPEN XLSX: Check box loses "Linked Cell" property after round-trip (comme...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Justin L
Whiteboard: target:7.6.0
: 135436 (view as bug list)
Depends on: 106181
Blocks: XLSX XLSX-Form-Controls
  Show dependency treegraph
Reported: 2020-08-21 11:06 UTC by Serge Krot (CIB)
Modified: 2023-02-22 15:33 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:
Regression By:

Original document created in MS Excel (11.10 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-08-21 11:06 UTC, Serge Krot (CIB)
XLSX resaved with LO (6.48 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-08-21 11:07 UTC, Serge Krot (CIB)

Note You need to log in before you can comment on or make changes to this bug.
Description Serge Krot (CIB) 2020-08-21 11:06:39 UTC
Created attachment 164531 [details]
Original document created in MS Excel

Original XLSX (created in MS Excel):
- the checkbox is visible in LO
- the checkbox is visible in MS Excel

After resaving the original XLSX into XLSX
- the checkbox is not visible in LO
- the checkbox is visible in MS Excel
Comment 1 Serge Krot (CIB) 2020-08-21 11:07:14 UTC
Created attachment 164532 [details]
XLSX resaved with LO
Comment 2 Thorsten Behrens (allotropia) 2020-08-21 11:46:52 UTC
Confirmed, never worked for LibreOffice.
Comment 3 NISZ LibreOffice Team 2020-10-06 11:40:18 UTC
*** Bug 135436 has been marked as a duplicate of this bug. ***
Comment 4 Silicomancer 2021-01-09 11:28:03 UTC
Same here in Kubuntu 20.04, LO Nasty.
Comment 5 m.a.riosv 2021-05-11 07:40:33 UTC

*** This bug has been marked as a duplicate of bug 113610 ***
Comment 6 Justin L 2023-01-21 19:02:22 UTC
Although the checkbox is now retained on save (thanks to bug 117266), the control is no longer linked to the A1 cell on import.

[It works in Excel 2010 - although the control is duplicated, so export is somewhat OK.]
Comment 7 Commit Notification 2023-01-24 02:14:56 UTC
Justin Luth committed a patch related to this issue.
It has been pushed to "master":


tdf#135987 xlsx vml export: retain checkbox link to cell

It will be available in 7.6.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.