<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 Formula references not consistant"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138825">138825</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc Formula references not consistant
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</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>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>dbondo1@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Creation of a formula such as "=($B$2-$B$3)/$B$3 and using this symbol "$" to
restrict the formula to the cell location still does not work. If you move or
cut the numeric value in the cell and move or paste it into another cell in
that same spreadsheet, the formula moves with the numeric value rather than
staying with the cell
The only way to change the location of of the numeric value and not have the
formula follow the location is to cut it from the spreadsheet paste it special
into another spreadsheet without the formula and then either copy it and paste
it back into the original spreadsheet.
Example attached.
Steps to Reproduce:
1.Move value in cell from B2 to B3
2. or cut cell value in B2 and paste into any other spread sheet cell
3. Cut B2 value, paste special into a different spread sheet without formula
and then copy the value into the original spreadsheet B3
Actual Results:
$B$2 designation to a specific cell does not restrict a formula to that cell
Expected Results:
It works, but cumbersome.
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no</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>