[Libreoffice-bugs] [Bug 116620] New: About Calc "copy and paste"

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Mar 25 08:30:10 UTC 2018


https://bugs.documentfoundation.org/show_bug.cgi?id=116620

            Bug ID: 116620
           Summary: About Calc "copy and paste"
           Product: LibreOffice
           Version: 5.1.6.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: chrisjullien94 at aol.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180325/006f4d45/attachment.html>


More information about the Libreoffice-bugs mailing list