<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 - CALC cell becomes "write protected" when the formatting (right Justified) forces the exposed formula across the preceding cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144194">144194</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>CALC cell becomes "write protected" when the formatting (right Justified) forces the exposed formula across the preceding cell
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.0.4 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>that.man.colin@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=174647" name="attach_174647" title="Example">attachment 174647</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=174647&action=edit" title="Example">[details]</a></span>
Example
When double clicking a cell to directly edit the formula is acting upon a cell
where the format is "right justified" and the length of the formula is
sufficient to force it to display "on top of" the cell(s) to its left then
attempting to place the cursor on any element of the formula which is displayed
"covering" the adjacent cell results in the formula being "write protected".
The workaround is to edit the formula in the toolbar.
Worksheet attached.
1 Try editing any right justified formula by "double clicking" the cell and
placing the cursor as defined above.
Try editing any left justified formula by "double clicking" the cell and
placing the cursor as defined above.
Try editing the third formula column (G) which overlaps another formula rather
than a data cell and the attempt to locate the cursor in an overlapped portion
of the formula results in the cell address being inserted into the formula at
that location.</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>