Bug 107922 - Paste special, does not respect the option "Skip empty cells"
Summary: Paste special, does not respect the option "Skip empty cells"
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-05-17 21:38 UTC by Dolespa
Modified: 2018-05-19 12:41 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Dolespa 2017-05-17 21:38:23 UTC 
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
Comment 1 Xisco Faulí 2017-05-17 22:00:36 UTC 
I think you misunderstand what "Skip empty cells" is supposed to do.
Skip empty cells don't ignore empty cells from the paste range but empty cell from the clipboard (copy range).

Help (F1) :
"Skip empty cells 
Empty cells from the clipboard do not replace target cells. If you use this option in conjunction with the Multiply or the Divide operation, the operation is not applied to the target cell of an empty cell in the clipboard. 

If you select a mathematical operation and clear the Skip empty cells box, empty cells in the clipboard are treated as zeroes. For example, if you apply the Multiply operation, the target cells are filled with zeroes."
Comment 2 Dolespa 2017-05-17 22:23:32 UTC 
I understand what I decided and I actually misplaced the example, because if you paste the inverse, that is, by selecting the range C1: C3 and paste it in A1, also consider the empty cell as zero (obviously with the option "jump empty cells")
Comment 3 m_a_riosv 2017-05-18 00:13:17 UTC 
Reproducible.
Version: 5.3.3.2 (x64)
Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new; 
Locale: es-ES (es_ES); Calc: group
Version: 5.4.0.0.alpha1+
Build ID: 774f033f86b3728123842321f21b10b400cf6b9a
CPU threads: 4; OS: Windows 6.19; UI render: GL; 
TinderBox: Win-x86@39, Branch:master, Time: 2017-05-16_02:20:51
Locale: es-ES (es_ES); Calc: CL
Comment 4 QA Administrators 2018-05-19 02:35:46 UTC Comment hidden (obsolete)
Comment 5 Dolespa 2018-05-19 12:41:40 UTC 
I'm sorry I did not close the incident before ... I apologize for that.

LibreOffice Current version: 6.0.3.2