Re: Protecting Cells from accidental change

[Steve Greig <greigsteve gmail com>]

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 <michael uplawski uplawski eu> 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
> gnumeric-list gnome org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list

--
GnuPG/OpenPGP  4096R/3216CF02 2013-11-15 [expires: 2015-11-15]
Michael Uplawski (privat) <michael uplawski uplawski eu>
sub   4096R/2751C550 2013-11-15 [expires: 2015-11-15]