<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 - LibreOffice Calc > Column containing calculated values disappears when copying and posting the 108th row (100 rows of data) to the 109th row (101 rows of data)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134893">134893</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LibreOffice Calc > Column containing calculated values disappears when copying and posting the 108th row (100 rows of data) to the 109th row (101 rows of data)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.1.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>el_gallo_azul@yahoo.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I want to add a new line to a sheet. I normally copy the final row and paste it
to the new row that I append. Today, when I do that, an entire column of
calculated numbers is annulled (ie. the numbers change from the calculated
values to "-" as the value in each row).
They do not return if I Ctrl-Z (undo), but stay as "-" on each row in that
column.
I have no option but to NOT save, and to close and reopen the sheet. I can't
find any way to correctly update the sheet.
Steps to Reproduce:
1.Save sheet with manually-entered values and calculation from those values
entered on 100 rows of data (108 rows in sheet)
2.Copy and paste calculations of final row to the subsequent row.
3.This same bug occurs when only the calculation from the final row in the
column that is affected by this bug is copied and pasted to the following row
(rather than copying and pasting the entire row).
Actual Results:
"-"
Expected Results:
Calculated number
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial10
CPU Threads: 32; OS Version: Linux 4.4; UI Render: default;
Locale: en-AU (en_AU.UTF-8); Calc: CL
I haven't tried resetting my user profile, nor checking that OpenGL is enabled,
because this sheet has operated perfectly every week for two years until today.</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>