Bug 91042 - copy & paste looses formula if omitting cells in between
Summary: copy & paste looses formula if omitting cells in between
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-03 11:38 UTC by t.zuelsdorf
Modified: 2015-05-04 23:13 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
example for copy-paste-issue (16.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-05-03 11:38 UTC, t.zuelsdorf 		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 t.zuelsdorf 2015-05-03 11:38:02 UTC 
Created attachment 115286 [details]
example for copy-paste-issue

A1 : Text1
B1 : =1+2
C1 : Text2
D1 : Text3


1. 
mark A1:C1
copy & paste elsewhere => B1 still =1+2

2.
mark A1, B1 and D1
copy & paste elsewhere => B1 just 3 instead of the formula
Comment 1 MM 2015-05-03 12:59:00 UTC 
Confirmed with v4.4.3.2 under windows 7 x64
Confirmed with v4.4.3.2 under mint 17.1 x64
Confirmed with v3.3.4 under windows 7 x64

Doesn't copy the formula when you skip rows/cells. As a workaround, when you know you need to copy/paste, use 'paste special/paste all'.

I set the importance a bit higher as it can affect a lot of users with a broken core function.
Comment 2 m_a_riosv 2015-05-04 00:02:56 UTC 
As I know copy-paste multiple selection it's not available, at least for multi-range destination.

How it works it's explained in:
https://wiki.openoffice.org/wiki/Calc/Features/Multi-range_copy_and_paste
LibreOffice was born from OpenOffice.

Comments from developer in http://kohei.us/2009/06/03/multi-range-selection-copy-paste/

It's works as designed, resolved as not a bug.
Comment 3 MM 2015-05-04 23:13:30 UTC 
Maybe it's not a bug, works as designed. But how would people know this, except that someone would have to look it up on the 'competitors' wiki site ? Someone *would* expect that everything is copied, not half.