Bug 136489 - Copy and paste seems to have a problem when copying a range and pasting only formula
Summary: Copy and paste seems to have a problem when copying a range and pasting only ...
Status: RESOLVED DUPLICATE of bug 64596
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha0+
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste
  Show dependency tree / graph
 
Reported: 2020-09-05 08:26 UTC by Elmar
Modified: 2021-07-28 15:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
copy range with mixed contents past only formula (17.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-09-05 08:28 UTC, Elmar 		Details
doc with incorrect formulas (21.05 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-07-28 11:43 UTC, Elmar 		Details
copy and paste step (139.84 KB, image/png)
2021-07-28 11:44 UTC, Elmar 		Details
result of paste (54.12 KB, image/png)
2021-07-28 11:44 UTC, Elmar 		Details
result (16.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-07-28 11:45 UTC, Elmar 		Details
View All 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 Elmar 2020-09-05 08:26:51 UTC 
Description:
I copy a range which includes text, numbers and formulae. When I paste to a similar range, selecting formulae only, it does change the formula cells but wpies what is in the other cells in the range

Steps to Reproduce:
1. work on existing sheet
2. correct formulas in a row
3. select the a range (which includes corrected formulas)
4. past to other similar ranges (e.g. subtotals) 


Actual Results:
any cells that don't include formula are wiped

Expected Results:
should only update the cells which have formulae


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

Version: 7.1.0.0.alpha0+
Build ID: 15988fe00c4f49ae32ab2d5cf3c16495ab6e1d59
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2020-08-25_13:42:41
Calc: threaded
Comment 1 Elmar 2020-09-05 08:28:43 UTC 
Created attachment 165174 [details]
copy range with mixed contents past only formula
Comment 2 Buovjaga 2021-07-26 11:01:08 UTC 
If you paste formulas only, isn't the result expected?
Comment 3 Elmar 2021-07-28 11:43:41 UTC 
Created attachment 173910 [details]
doc with incorrect formulas
Comment 4 Elmar 2021-07-28 11:44:18 UTC 
Created attachment 173911 [details]
copy and paste step
Comment 5 Elmar 2021-07-28 11:44:47 UTC 
Created attachment 173912 [details]
result of paste
Comment 6 Elmar 2021-07-28 11:45:09 UTC 
Created attachment 173913 [details]
result
Comment 7 BogdanB 2021-07-28 11:54:15 UTC 
I don't see any problem. You pasted from all the info just the formula, and that's what you get. Just formulas.
Comment 8 Elmar 2021-07-28 15:42:58 UTC 
It did NOT just paste the formulas, it pasted empty blanks into the cells. The cells had data in them before which was not formulas.
How can you say that it did what you asked it to do.
Then remove this feature.
Comment 9 Elmar 2021-07-28 15:45:49 UTC 
By not ticking the other options, it is telling me "do not touch the other cells, leave them as they are"
Comment 10 Buovjaga 2021-07-28 15:55:14 UTC 
(In reply to Elmar from comment #8)
> It did NOT just paste the formulas, it pasted empty blanks into the cells.
> The cells had data in them before which was not formulas.
> How can you say that it did what you asked it to do.
> Then remove this feature.

The steps in your attachment 165174 [details] were not clear. You had left B10:D10 empty. This is a dupe anyway.

*** This bug has been marked as a duplicate of bug 64596 ***