https://bugs.documentfoundation.org/show_bug.cgi?id=107922
Bug ID: 107922
Summary: Paste special, does not respect the option "Skip empty
cells"
Product: LibreOffice
Version: 5.3.1.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dole...@hotmail.com
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs