On Tue, Jan 22, 2013 at 11:50:51AM -0500, Randy Kramer wrote: > On Tuesday 22 January 2013 4:55:53 am Andrei POPESCU wrote: > > Bah, my own colleagues are overwriting formulas with values and then > > wonder why the sheet doesn't work anymore. > > > > [1] this is only half joke, I've actually seen it several times. > > Sounds like an opportunity ;-) > > Maybe spreadsheets need a warning mechanism that warns the user when he is > about overwrite a formula with a value, tells him that doing so will probably > prevent the spreadsheet from working properly in the future, tells him there > is a more appropriate way to make the change he wants to do (ideally, telling > him where to make such a change ;-), and finally, forcing him to confirm he > really wants to do that.
AFAIR, you can "lock" cells/rows/columns. The worst thing is when people use a spreadsheet as a database, and then give you the job of updating it! -- "If you're not careful, the newspapers will have you hating the people who are being oppressed, and loving the people who are doing the oppressing." --- Malcolm X _______________________________________________ D-community-offtopic mailing list [email protected] http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/d-community-offtopic
