Description: If i select non-consecutive cells with forumla (es. A1 and A3) and copy them (Ctrl-C), when i paste it (Ctrl-V) then program paste value instead formula. Steps to Reproduce: 1. Create 2 or more cells with formula 2. Select and copy 2 or more non-consecutive cells 3. Select new location and paste the cells Actual Results: New cells have values of original cells Expected Results: New cells have formulas of original cells with update argument if need (as copy/paste consecutive cells) Reproducible: Always User Profile Reset: No Additional Info: Version: 7.2.6.2 (x64) / LibreOffice Community Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: it-IT (it_IT); UI: en-US Calc: threaded
You can use paste spacial to get the formulas copied, but cells are joined, skipping not selected cells. I think it's a duplicate, maybe not exactly the same, but part of the issue. Please, if you are not agree, reopen it. *** This bug has been marked as a duplicate of bug 141907 ***
This "bug" is not the same of bug 141907. This is not problem of relative gep of selected cells, but problem is that LO not copy formula. When i select consecutive cells and copy>paste it, LO copy the formulas. When i select non-consecutive cells, instead, LO not copy the formulas, but the values. As you say, if i use special-paste, LO copy the formulas. Expected results: Copy>Paste consecutive or non-consecutive cells work in the same way.
You expecting that doesn' mean it is a bug.