Bug 164602 - EDITING: Copy&paste of multiple CTRL-selected rows copies values, not formulas
Summary: EDITING: Copy&paste of multiple CTRL-selected rows copies values, not formulas
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste
  Show dependency tree / graph
 
Reported: 2025-01-06 12:21 UTC by Hajo Schatz
Modified: 2025-01-07 11:57 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Hajo Schatz 2025-01-06 12:21:30 UTC 
Assume rows 1-3 each containing e.g. value in column A and a formula in column B.

SHIFT-select rows 1-3, copy & paste (CTRL-C & -V ) them into e.g. rows 5 ff. Results are as expected, formulas are copied into B:5-7.

However, CTRL-select rows 1 & 3 only (exclude row 2), copy & paste (CTRL-C & -V) into rows 9 ff. Rows are copied into rows 9 & 10 as expected, however B:9&10 now contain value copies of B:1&3 instead of formulas as one would expect. 

Observed in LibreOffice 24.2.7.2
Comment 1 m_a_riosv 2025-01-07 01:55:02 UTC 
Reproducible
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 022e95d39d9ae29496be0f81740eefaf515f578a
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: en-US (es_ES); UI: en-US
Calc: CL threaded

You can do it using Paste special [Shift+Ctrl+V] with formulas selected.
Also selecting the ranges instead of rows also works.