<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 not sort cells having formulas in them and still have sort properly."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136864">136864</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Can not sort cells having formulas in them and still have sort properly.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</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>mclean8414@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I clicked “filing an enhancement request“ but found only “file a bug”. This is
not a bug, works great. I am filing an enhancement request. I know formulas
follow cells. But when a formula is part of “sort”, “sort” does not sort
aright, not properly! I may be missing on how to handle such, (sorting cells
with formulas in them). But if, when a sheet is locked, it would work if “copy”
& “cut” were disabled, when the sheet is locked.
I hope there is another way to keep the active command “copy” and “cut”
available and still be able to sort cells having formulas in them. Thanks.
Steps to Reproduce:
1.copy cell to another row
2.sort
3.
Actual Results:
sort will follow the cut copied or cut cell, giving an untrue sort. (which it
should).
Expected Results:
Sort to figure it out! or, when sheet is locked to also disable cut and copy
command.
Reproducible: Always
User Profile Reset: No
Additional Info:
I have a file. Was hoping to leave it here.</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>