Bug 160466 - Libre Calc does not allow you to temporarily enter data into a read-only document.
Summary: Libre Calc does not allow you to temporarily enter data into a read-only docu...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-01 18:36 UTC by oeuceda
Modified: 2024-04-02 01:45 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.