<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 - Pasting cells between sheets uses absolute values (not cross-sheet references)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114659">114659</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Pasting cells between sheets uses absolute values (not cross-sheet references)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>mail@samtuke.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When copying and pasting cells which contain formulas between two sheets of the
same document, the values are inserted literally, instead of pasting the
formulas with references to the original sheet, as expected. By default,
references should be used instead of literal values.
Steps to Reproduce:
1. Create some calculations using formulas and cell references within sheet #1
2. Create sheet #2 in the same document and copy the cells from sheet #1
3. Double click the pasted cells and observe the values are literal numbers --
the formulas are gone
Actual Results:
Formulas are lost and literal values are inserted
Expected Results:
Formulas are inserted, with automatically updated cell references pointing to
sheet #1 in the same document.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:59.0) Gecko/20100101
Firefox/59.0</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>