Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
Example sheet attached.
Is this more than just “Undesired Behavior” from Calc?
If I’m working in a protected sheet (Example attached) with some unprotected cells, and I paste in just some random text from a random web page, the cell becomes protected and can no longer be edited or changed unless you unprotect the sheet.
This for me is highly undesired behavior. I’m sharing worksheets with other users that have password protection so that they can’t accidentally mess up the sheet, but they are sabotaging themselves by the simple act of pasting in text or numbers from websites -which should be harmless – yet it ends up destroying the sheet’s usefulness when it ceases to be editable in places where it should.
I am well aware that one can choose to paste/Unformatted, but the vast majority of my users do not understand this concept, and training all of them to do this is burdensome and frankly shouldn’t be necessary, because why is Calc changing cell protection after pasting plain text?
Is this a bug? In what case would this behavior be wanted?
Unprotected to Protected.ods (9.6 KB)
)