Bug 116620 - About Calc "copy and paste"
Summary: About Calc "copy and paste"
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-25 08:30 UTC by Chris
Modified: 2018-03-25 09:57 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris 2018-03-25 08:30:10 UTC
Description:
I want to "copy and paste" a cell, but that doesn't paste the good cell.
For my example : I copy the cell B5 (B5=B1) except that copy and paste the cell B2 (B1+1) into the cell B6.

I repeat the process several times any cells; it's "copy and paste" the cell C+1


Thanks.

Steps to Reproduce:
1.Enter B1=20
2.Copy B1
3.Paste into B5

Actual Results:  
B5=B2

If B2=12, B5=12



Expected Results:
B5=B1


Reproducible: Always


User Profile Reset: No



Additional Info:
The same problem with the mouse : it doesn't succeed too.


There are different methods for copying a formula. One of them is:
1. Select the cell containing the formula.
2. Choose Edit - Copy or press Ctrl + C to copy.
3. Select the cell in which the formula is to be copied.
4. Choose Edit - Paste or press Ctrl + V. The formula is inserted in the new cell.
If you want to copy a formula into multiple cells, you can proceed in a simple and fast way between adjacent cell areas:
1. Select the cell containing the formula.
2. Click at the bottom right of the selection rectangle that surrounds the cell and hold down the mouse button. The mouse pointer turns into a cross.
3. While holding down the mouse button, drag the mouse down or to the right on the cells in which the formula is to be copied.
4. Release the mouse button: the formula has been copied and automatically adapted.
To avoid automatically updating values ​​and text, hold down the Ctrl key while dragging your selection. However, the formulas are systematically adjusted.


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0
Comment 1 Xavier Van Wijmeersch 2018-03-25 09:57:19 UTC
no repro with

Version: 5.3.1.2
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 8; OS Version: Linux 4.14; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group

not a bug and your version of LO is EOL, try with a newer version, if you not agree you can still reopen as unconfirmed