| Summary: | copy & paste looses formula if omitting cells in between | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | t.zuelsdorf |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | example for copy-paste-issue | ||
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. 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. 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. |
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