<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Data/Form provides access to cells that are protected"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131560">131560</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Data/Form provides access to cells that are protected
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>p_d_hodgson@btinternet.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I have a database table in Calc, some columns contain formulas but (to prevent
changing within the main sheet) they are also protected. I would like to be
able to use Data\Forms to enter new rows in the table but (I would have
expected) the cells that are protected and/or containing formulae to be
protected in the form, and show the results (I have not checked, but I would
expect that hidden cells/columns within the table should not appear on the
form).
I also have "Data Validation..." on some cells in the sheet (using lookups from
other named ranges or lists) and would like that functionality to propagate to
the form.
Steps to Reproduce:
1. Create a database in a sheet (A1 = "Width", B1 = "Height", C1 = "Area", C2 =
"=A2*B2")
2. Select A1:C2 and name the Area "DB"
3. Protect column C (click on column header, Ctrl-1 to format and protect the
cells of the column, then Right click on the sheet tab and select "Protect
Sheet...", unselect the check on "Select protected cells"). If you now click on
a cell in column C the cursor does not move there.
4. Position the cursor in A1 and Open Data\Form...
Actual Results:
The "Area" Field is open for data entry... no calculation is done when data is
entered
Expected Results:
The field for the cell in the protected column should be protected because:
1. It is a protected cell - this should be protected in the form
2. It is a formula, this formula should be propagated to new cells and when
data is entered the calculation should present results.
Reproducible: Always
User Profile Reset: No
Additional Info:
The form should inherit the attributes of the main sheet...
1. Protected columns should be protected
2. Hidden columns should be hidden
3. Formula cells should inherit the formula used in existing rows
4. Validation should be inherited from existing rows (e.e. if I has a list of
values for the "Length" column, the form should provide a combo control with
the same list of values.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>