[sc-dev] using cut paste on pw protected sheets causes problems ...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I have a problem using cut paste on non protected cells (input area) on password protected sheets: Example: A user insert values into non protected cells to do some calculations. The sheet is password protected, the user can not change the formulas. Now the user uses cut (strg x) on a non protected cell and paste the content via (strg v) into another non protected cell ... This will change the referenced cells of the formulas and the formular results are wrong ... This is a general problem and seems to affect all documents... Would'nt it make sense to disable cut on password protected sheets ? For example, a message is displayed if one tries to change a protected cell: Protected cells can not be modified and it's not possible to change a cellstyle if one sheet of the document is protected ... Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFER466TiyrQM/QSkURAkQ+AKCKi10XdJ4XP4wPe4YvK9kyg1+ZYACeL3fF GE6pjrv8OoahUn+X52fvSyo= =h7V3 -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] using cut paste on pw protected sheets causes problems ...
Oliver Brinzing wrote: I have a problem using cut paste on non protected cells (input area) on password protected sheets: Example: A user insert values into non protected cells to do some calculations. The sheet is password protected, the user can not change the formulas. Now the user uses cut (strg x) on a non protected cell and paste the content via (strg v) into another non protected cell ... This will change the referenced cells of the formulas and the formular results are wrong ... This is a general problem and seems to affect all documents... Would'nt it make sense to disable cut on password protected sheets ? Disabling it only on the protected sheet wouldn't be enough, a protected formula might as well depend on cells on non-protected sheets. Also, it's not only cut paste, but also stuff like drag drop and inserting/deleting cells. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sc-dev] using cut paste on pw protected sheets causes problems ...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Niklas, Disabling it only on the protected sheet wouldn't be enough, a protected formula might as well depend on cells on non-protected sheets. Also, it's not only cut paste, but also stuff like drag drop and inserting/deleting cells. yes, that is true, but what about a simple warning if a sheet is protected ? We have a configurable warning for pasting data: Show overwrite warning when pasting data Another posibility might be a special (pw protected) user mode, where a user can only insert/delete values in non protected input cells ... Oliver - -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFESG+JTiyrQM/QSkURAkUIAJ9OsrHLdXHOFVEhzA7Hhlaf4QHxvACggu5+ rwJXg0M18lKwXm2KTcjlKaw= =6uFf -END PGP SIGNATURE- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]