Thanks to all for information and ideas. The documentation was a little misleading on that point and I have now achieved the main thing I want which is to be able to protect the work I have done but leave remaining rows unprotected so I can easily add new data. I will only have to temporarily unprotect the sheet to correct mistakes. Automatically protecting cells that I have entered information into would be nice as then I would not have to protect them for example at the end of each session of data entry and also they would be protected during that session. I was wondering if the protection could be applied to cells on the condition that they were not empty.
Michael, I will play around with that idea. It does sound complicated but might be useful in some situations. Best wishes Steve On Sat, Sep 13, 2014 at 7:27 AM, Michael Uplawski < [email protected]> wrote: > Good morning, > > I have a suggestion, but it may not be applicable to a Gnumeric table > which is already in use or has evolved past the stage, where > modifications are easy. > > On Fri, Sep 12, 2014 at 09:35:04PM +0100, Steve Greig wrote: > > > My question is what is the best way for me to make certain cells less > subject > > to accidental changes in future? It looks like gnumeric does not have a > cell > > protection function but I was wondering if some validation might be > applied > > which would make the cell(s) protected. The protection would need to > allow the > > results of formulae in the cells to change but not the formulae > themselves. > > I suggest that the formulae which are usually there to calculate > “results”, be it intermediate results, are accumulated in one table > (“sheet”) and the original data, which you may wish to adapt or complete > frequently, stay on a different sheet, where they are looked up in your > “results-table”. This way, you can easily protect the whole sheet, which > protects securely your formula without impeding calculations on new > values. > > > Would it be possible for every cell I have entered something into to then > > automatically be weakly protected ie. if the value is changed a pop up > could > > say 'do you really want to change the value of this cell'? > > If you use the existing protection on whole sheets, a message-box is > already generated each time, that you try to alter cell-content. > > Cheerio, > > Michael > > > > > Best wishes from Steve > > > _______________________________________________ > > gnumeric-list mailing list > > [email protected] > > https://mail.gnome.org/mailman/listinfo/gnumeric-list > > > -- > GnuPG/OpenPGP 4096R/3216CF02 2013-11-15 [expires: 2015-11-15] > Michael Uplawski (privat) <[email protected]> > sub 4096R/2751C550 2013-11-15 [expires: 2015-11-15] > >
_______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list
