Re: Protecting Cells from accidental change

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

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.



Best wishes from Steve

gnumeric-list mailing list
gnumeric-list gnome org

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]

Attachment: signature.asc
Description: Digital signature

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]