[Solved] Form control data not being saved

Discuss the spreadsheet application

[Solved] Form control data not being saved

Postby paulh » Sat Mar 09, 2019 9:10 pm

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.
Last edited by Hagar Delest on Sun Mar 10, 2019 1:55 pm, edited 1 time in total.
Reason: tagged solved
OpenOffice 3.1 on Windows Vista
paulh
 
Posts: 3
Joined: Sat Mar 09, 2019 9:05 pm

Re: Form control data not being saved

Postby FJCC » Sat Mar 09, 2019 9:22 pm

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7307
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Form control data not being saved

Postby paulh » Sat Mar 09, 2019 10:56 pm

I was trying.xls. I’ll try .OBS
OpenOffice 3.1 on Windows Vista
paulh
 
Posts: 3
Joined: Sat Mar 09, 2019 9:05 pm

Re: Form control data not being saved

Postby RoryOF » Sat Mar 09, 2019 11:05 pm

paulh wrote:I was trying.xls. I’ll try .OBS


That should be .ods - select from the file type dropdown in /File /Save As.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29578
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Form control data not being saved

Postby paulh » Sun Mar 10, 2019 1:24 pm

I did save the spreadsheet as a .ods and it worked! All of the form control information was saved. Thanks
OpenOffice 3.1 on Windows Vista
paulh
 
Posts: 3
Joined: Sat Mar 09, 2019 9:05 pm


Return to Calc

Who is online

Users browsing this forum: RusselB and 11 guests