Bug 158211 - Form input writes over protected cells
Summary: Form input writes over protected cells
Status: RESOLVED DUPLICATE of bug 131560
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-14 13:02 UTC by Daan
Modified: 2023-11-29 00:31 UTC (History)
2 users (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 Daan 2023-11-14 13:02:42 UTC
Description:
Hi, I recently started using the "Form" option to input data to Libre Calc. I noticed I can overwrite data in protected and locked cells this way.

Version: 6.4.7.2
Build ID: 1:6.4.7-0ubuntu0.20.04.8

Steps to Reproduce:
1.create protected and locked columns and unprotected columns
2.select all
3.use form to input and write over protected and locked cells

Actual Results:
overwrite protected and locked cells

Expected Results:
not being able to overwrite protected and locked cells


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 m_a_riosv 2023-11-14 15:15:21 UTC
First, your version it's a bit old.

Have you protected the sheet:
Menu/Tools/Protect sheet.
https://help.libreoffice.org/latest/en-US/text/scalc/01/06060100.html?DbPAR=CALC#bm_id141619439455954

No clear for me your steps, what is the meaning the use a form to input after select all. And what form do you use?
Comment 2 Daan 2023-11-14 15:47:24 UTC Comment hidden (obsolete)
Comment 3 Daan 2023-11-14 15:50:00 UTC
Hi, "form" is a way of entering data in cells. You can find it under Data - Form.

I've noticed I worked on an old version indeed, so I installed both Flatpack and Appimage versions and tried again. But another worse bug appears now. If I select protected cells by ctrl-a in a protected sheet and use the "form" function the whole program freezes.
Comment 4 m_a_riosv 2023-11-14 16:22:26 UTC
Please attach a sample file.
Comment 5 Daan 2023-11-15 10:52:11 UTC
No need for that. Just protect a cell, lock the sheet, select all and go to data - form and the bug is there.
Comment 6 QA Administrators 2023-11-16 03:13:04 UTC Comment hidden (obsolete)
Comment 7 Buovjaga 2023-11-28 12:26:21 UTC
Since 7.4, Calc supports 16384 columns, so that is causing the performance problem when selecting all and opening the Form dialog.

*** This bug has been marked as a duplicate of bug 131560 ***