Bug 160466

Summary: Libre Calc does not allow you to temporarily enter data into a read-only document.
Product: LibreOffice Reporter: oeuceda
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: UNCONFIRMED ---    
Severity: enhancement CC: miguelangelrv
Priority: medium    
Version: 7.6.5.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description oeuceda 2024-04-01 18:36:36 UTC
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.
Comment 1 m_a_riosv 2024-04-02 01:45:32 UTC
Menu/Data/Edit mode [Ctrl+Shift+M]
And remember do not save the file.