Ask Your Question

Linked Cell in Checkbox properties is always blank, even after saving the document

asked 2017-08-01 05:18:48 +0200

KayOffice gravatar image

Hi folks,

When creating a checkbox, i always enter the LINKED CELL value as well as the ON/OFF values and they work just fine. I have done this for 3-7 checkboxes accross 50 sheets. All the sheets are unique and have been adjusted accordingly and individually, and all the checkboxes work fine with their intended linked cells and on/off values.

When i close the file and reopen it, the LINKED CELL value for all the 250+ checkboxes have lost their LINKED CELL values (blank) whereas the ON/OFF values are retained.

Is this a bug or am i just not doing it right? I'm using LIBREOFFICE Version: (x64). Any help wwould be most appreciated as this is the second time I've had to re-enter the values for ALL my checkboxes in that file.


edit retag flag offensive close merge delete


Please, what file format do you use to save?

m.a.riosv gravatar imagem.a.riosv ( 2017-08-01 12:43:14 +0200 )edit

I have also had this problem when saving to .ods on Windows 7 in version (x64). The checkbox linked cell field is blanked out whenever the file is closed and reopened, even if the file is saved beforehand. Interestingly, I do not have this problem when saving to .ods when running LibreOffice Calc on Enterprise Linux 6.

azmulh gravatar imageazmulh ( 2017-09-21 15:28:02 +0200 )edit

Please report the bug Create a bug report

m.a.riosv gravatar imagem.a.riosv ( 2017-09-21 16:58:45 +0200 )edit

I also have this problem: Spreadsheets created or opened with version 5.x do not save the linked cell of form controls, e.g. spin or push buttons. This is a really serious bug.

snowy gravatar imagesnowy ( 2017-10-11 17:51:10 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-10-12 08:37:47 +0200

pierre-yves samyn gravatar image


The bug is already reported : tdf#112459 duplicate of tdf#110431


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-01 05:18:48 +0200

Seen: 159 times

Last updated: Oct 12 '17