<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 - Paste special, does not respect the option "Skip empty cells""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107922">107922</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Paste special, does not respect the option "Skip empty cells"
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.1.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>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>dolespa@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When using Special Paste, select "Numbers", option "Skip empty cells",
operation "Multiply" (for example) we realize that the empty cells are
considered as 0 (zero), when they should be ignored when using "Skip empty
cells".
The same thing happens with the Divide operation.
(I apologize for my English.I hope you understand the above.)
Steps to Reproduce:
1. Enter, in the range A1: A3 the following values: 10, 20, 30.
2. Enter C1 and C3, 50 and 6 respectively.
3. Select range A1: A3 and Copy.
4. Special paste on C1, only "numbers", operation "multiply" and the option
"jump empty cells".
As a result, instead of ignoring cell C2 (which is empty) it takes it to zero
resulting in 20 * 0 = 0.
Actual Results:
It does not skip the empty cells. It considers them as zero value.
Expected Results:
You must ignore the empty cells.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:53.0) Gecko/20100101
Firefox/53.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>