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]
Attachment:
signature.asc
Description: Digital signature