<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 - Can't protect only the format of a sheet"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132133">132133</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Can't protect only the format of a sheet
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>crl@chrblee.net
</td>
</tr></table>
<p>
<div>
<pre>I've designed a spreadsheet with particular cell borders, column heights &
widths, and font sizes. Nothing elaborate.
My students have to enter data by whatever means they wish, but without
altering the formatting; for the spreadsheet to be of any use, the appearance
of the data has to remain compliant with a particular pattern.
I can't find a way of protecting only the formatting of a sheet.
Paste-Special, and macros which I don't know how to write (in the absence of an
ecosystem to match VBA), are not solutions for 12-year olds.
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Feature request - Option to lock formatting on cells and/or entire sheet, while allowing editing"
href="show_bug.cgi?id=88108">Bug 88108</a> dating from 2015 is nearly a duplicate, but apparently there has been
no action on the necessary changes to the odf standard.
I've marked this report critical because it concerns one of the missing
features that are critical for a competitive position of LO in the educational
field.</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>