Description: There is a spreadsheet I use that contains various calculators I occasionally need. This is a co-worker's document that I do not want to prevent him from using (nor do I want to accidentally save any changes) so I open it as a read-only file and use its calculators. The problem is, when Calc opens a file in read-only mode it does not allow you to enter data in any cells. I think a better way to handle this (even if this is an option in Calc's preferences) is to allow entry of data but if the user tries to save the file, force them to save it as a different filename. This is how Excel does it, and it allows User-1's multi-function spreadsheet to be used by multiple people without having to worry about dumb User-4 saving changes and causing problems for all other users. Keywords: EDITING, FILEOPEN, FILESAVE Steps to Reproduce: 1. Open a file in read-only mode. 2. Try entering data into a cell. Actual Results: All text entry is blocked. Expected Results: Text entry is allowed, but cannot save over original file. Reproducible: Always User Profile Reset: Yes Additional Info: Please allow entry of data so multiple users are able to utilize a spreadsheet without unintentionally breaking it.
Menu/Data/Edit mode [Ctrl+Shift+M] And remember do not save the file.