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...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Justin L
URL:
Whiteboard: target:7.6.0
Keywords:
: 135436 (view as bug list)
Depends on: 106181
Blocks: XLSX XLSX-Form-Controls
  Show dependency tree / graph
 
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:

Attachments
Original document created in MS Excel (11.10 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-08-21 11:06 UTC, Serge Krot (CIB) 		Details
XLSX resaved with LO (6.48 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-08-21 11:07 UTC, Serge Krot (CIB) 		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 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 7.1.0.1. 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":

https://git.libreoffice.org/core/commit/7f23dae00fedc9d7119b44b6c44d9eca4f8c87b8

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:
https://wiki.documentfoundation.org/Testing_Daily_Builds

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