https://bugs.documentfoundation.org/show_bug.cgi?id=104452
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- OS|Linux (All) |All --- Comment #12 from ady <[email protected]> --- The problem is that Calc knows how to do "cut" and _immediately_ _one_ "paste", but does not know how to do the _same_ _exact_ "paste" if that action is not immediately after the initial "cut". Any "paste" action that is not the first and immediate action after the initial "cut" action will work as "(copy+)paste". This is also true for several (adjacent, vector) cells selected at once for pasting in the first immediate step – only the first pasted cell will have the same exact formula, whereas the others will behave as copy+paste. So, in Calc, when doing cut, insert (cells), paste, the resulting paste is not the same as cut and paste, but rather a copy and paste. And when repeating the first immediate paste after the initial cut, the result is also not the same as the first paste, but rather it works as a "copy+paste". Example: 1. A1: 100 2. B2: =A1*2 3. Cut B2. Note the surrounding "ants" around B2. 4. First immediate paste on D3. Result: =A1*2. Note the surrounding "ants" around B2. 5. Paste on E3. Paste on D4. Paste on B3. Note that the resulting formulas are equivalent to copying the initial B2 (still surrounded by "ants") and then pasting that on E3, D4 and B3 respectively. 6. Paste on A3. The behavior is exactly the same as step 5. With the current behavior, there is no alternative but to result in =#REF!2*2. In order to repeat the same formula several times in Calc, there are a couple of options: either use absolute references before cutting, or you have to cut the formula itself from within the input window formula bar. Unfortunately, in the second case the corresponding paste action(s) will only paste the formula, not the cell's format. Other spreadsheet tools might work differently. One possibility is to transform this report into a request for enhancement (or starting a new one), allowing to paste the initially cut cell multiple times "as-is", or even when other non-clipboard actions are performed in between. -- You are receiving this mail because: You are the assignee for the bug.
