Bug 170385 - copy and pasting cells with formulas converts to text/values and does not copy formulas
Summary: copy and pasting cells with formulas converts to text/values and does not cop...
Status: RESOLVED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-01-19 10:12 UTC by Claas
Modified: 2026-01-20 09:59 UTC (History)
1 user (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 Claas 2026-01-19 10:12:11 UTC 
A1: 1
A2: =A1+1   # displayed as "2"

select A2, CTRL+C
select A3, CTRL+V 

A3: shows "3"

I am not able to copy the formula any more. Why?


selecting more than one cell (f.ex. A3-A20), CTRL-V: It only pastes into A3, skipping A4-A20. Why?


This used to work different in earlier versions. Why?
Please help.
Comment 1 LeroyG 2026-01-19 22:14:06 UTC 
I can't reproduce.

1. There is a clipboard manager in you system?
2. Have you tested with a new document?
3. Can you share the LibreOffice version information? See menu Help - About LibreOffice, and use the button there to copy. Once done, change the Statur to Unconfirmed. Thanks.
Comment 2 Werner Tietz 2026-01-20 07:13:37 UTC 
If you copy »=A1+1« from A2, it becomes »=A2+1«,  IF you paste into A3… (which is obviously 3 ) 

thats how **relative** Cellreferences works in every spreadsheet works ( since 30 years )
Comment 3 Werner Tietz 2026-01-20 07:21:24 UTC 
(In reply to Claas from comment #0)
> A1: 1
> A2: =A1+1   # displayed as "2"
 
> selecting more than one cell (f.ex. A3-A20), CTRL-V: It only pastes into A3,
> skipping A4-A20. Why?


cannot reproduce… I would guess sth. wrong with your clipboard-manager
Comment 4 Claas 2026-01-20 09:59:28 UTC 
Today, the bug has disappeared. Maybe some external process was modifying my clipboard.