[Libreoffice-bugs] [Bug 107922] New: Paste special, does not respect the option " Skip empty cells"

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: dolespa at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170517/c7127bf0/attachment.html>