Ask Your Question
0

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

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

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: 5.4.0.3 (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.

Cheers.

edit retag flag offensive close merge delete

Comments

Please, what file format do you use to save?

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

I have also had this problem when saving to .ods on Windows 7 in version 5.4.1.2 (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 4.3.7.2 on Enterprise Linux 6.

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

Please report the bug Create a bug report

m.a.riosv gravatar imagem.a.riosv ( 2017-09-21 16:58:45 +0100 )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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

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

pierre-yves samyn gravatar image

Hi

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

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 86 times

Last updated: Oct 12