[Solved] Form control data not being saved

[paulh]

Within a Calc spreadsheet, I am using several 'check boxes' that when checked place a certain value in a cell. After I save the spreadsheet and then re-open it, all of the control data is lost. Example, when a check box is checked, the cell value is 5, unchecked it is 0. It works fine at this point. I save the spreadsheet and then close it. I later open it up and when the check box is checked, it enters TRUE in the linked cell (instead of 5). When I then view the control data, the values for checked and unchecked are now blank.

[FJCC]

I tried to reproduce the problem and I did not see it. What format are you saving in? If it is not ods, try that.

[paulh]

I was trying.xls. I’ll try .OBS

[RoryOF]

I was trying.xls. I’ll try .OBS

That should be .ods - select from the file type dropdown in /File /Save As.

[paulh]

I did save the spreadsheet as a .ods and it worked! All of the form control information was saved. Thanks