Issue 121158 - Paste Special is deleting other values
Summary: Paste Special is deleting other values
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 3.4.1
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-10-04 13:40 UTC by ggeerits
Modified: 2013-01-09 20:42 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description ggeerits 2012-10-04 13:40:36 UTC
OpenOffice Calc version 3.4.1

Cell A1: value: 1
Cell A2: value: 2
Cell A3: formula: =SUM(A1:A2)
Cell B1: value: 10
Cell B2: value: 11

Select Cells A1, A2 and A3
Copy selected cells (Ctrl+C)

Go to Cell B1
Paste special... Deselect all selections except for Formulas
Press OK
!!!! The values in B1 and B2 has been deleted !!!!

This was not the case in version 3.4.0
The values in Cells B1 and B2 may not been changed.
Comment 1 Regina Henschel 2012-10-04 22:02:57 UTC
I get a overwrite warning. Have you at sometime checked the option, that you do not want the overwrite warning?
Comment 2 Rob Weir 2013-01-09 20:42:33 UTC
I see the same behavior as reported, though I do see a dialog first, warning that this will cause an overwrite. 

If I test the same scenario in Excel 2010 the non-formula cells are not overwritten.

I think that is a reasonable expectations, that when you say to paste only formulas, that non-formula cells are not erased.

But I am lowering the severity for this to normal, since it is not a crash or data loss situation, since the user is warned of the overwrite.