Bug 148246

Summary:	Copy non-consecutive cells at the same time does not copy the formulas
Product:	LibreOffice	Reporter:	nurv
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	REOPENED ---
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	7.2.6.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description nurv 2022-03-29 11:12:08 UTC

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

Comment 1 m_a_riosv 2022-03-29 15:44:33 UTC

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

Comment 2 nurv 2022-04-14 06:12:16 UTC

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.

Comment 3 m_a_riosv 2022-04-14 09:51:48 UTC

You expecting that doesn' mean it is a bug.