https://bugs.documentfoundation.org/show_bug.cgi?id=91241
Bug ID: 91241
Summary: Paste Special - Destroy formula and replace with
numeric value
Product: LibreOffice
Version: 4.4.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 115522
--> https://bugs.documentfoundation.org/attachment.cgi?id=115522&action=edit
Spreadsheet with screen copy of dialog boxes describes the bug
Have a row with two input cells (B4 and C4), numeric values and one resulting
cells (D4).
Drag the formula in D4 down so that also D5 contains same formula with B5 and
C5 as input. Could be simple operators.
Now, select area B4:D4 and Copy, Ctrl+C.
Select area B5:D5 and Paste Special. In the Paste Special dialog box, make sure
that under Selection, only "Numbers" is checked. Click the OK button.
First thing I don't expect: I get a warning message "Do you really want to
overwrite the existing data". I don't expect this because there is no data to
overwrite. I click "Yes" to this question anyway.
Second thing I don't expect - This one turns the whole Paste Special function
useless:
The formula in cell D5 isn't a formula any more. It's contents is just the
numeric value that equals the contents of D4 when the copy was taking place.
Expected behaviour: Cell D5 should be untouched by the Paste Special operation,
unless the option "Formulas" is also checked.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
