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
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