Apache OpenOffice (AOO) Bugzilla – Issue 40204
Plain Paste (wrongly) shift down cells before pasting
Last modified: 2005-03-31 08:01:13 UTC
Title says it all. Plain Paste used to replace contents of target selection (and still does it with OOo Calc 1.1.4 for Windows), on my Linux Debian Box 1.1.3 insert copied cells (shifting down target cells and all cells below) instead of replacing contents of target cells. This is very bad behavior because in a spreadsheet data is usually organised by row/columns. Say one column for item, one column for price. If you copy a price cell because two items have the same price you do not wish to shift down all the price columns (getting all the prices wrong below insertion point). This behavior could be handy when copying entire rows (shift down) of entire columns (shift right) because inserting complete rows or columns does not break line semantic. But for individual cells its usually evil (only exception : when you are moving around unrelated zones of cells of the same width, say cells for different geographic zones, but yet such goal could be better achieved copying full rows). I put in in P1 because Calc will be pretty useless until corrected : too dangerous !!! I do not want to release a broken price list or such because of a split second of inattention. The following links point to threads on mailing list or forums related to this problem. http://www.archivum.info/debian-openoffice@lists.debian.org/2005-01/msg00052.html http://www.archivum.info/users@openoffice.org/2004-12/msg00021.html http://www.oooforum.org/forum/viewtopic.php?p=60227 I reported it too on the user ML (I thought there was an option to change behavior I had missed) under the title : [users] Calc: cut/copy/paste of cells incoherent and dangerous, change proposal (not yet appearing on Internet Archive, so no link sorry).
Added to cc list
I can confirm this on Debian Sarge (+unstable) with OpenOffice 1.1.3. It annoys me too. Such a change in behaviour - if there are people who want the new behaviour - should have been made configurable. E.g. have the Paste Special... dialog have a "make this behaviour the default" button.
Have you tried to log this error in the Debian-OOo bugtracker? They are using a different version (more correctly: The Debian people are using patches for a better Debian-compatibility) of OOo, so I think you should report it in their bugtracker ... ;)
Me not, but somebody else did: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=288708
Hi, checked it on different Linux distributions and can't reproduce using OOo builds. Seems to be a Debian problem. Also Prio 1 is much to high. Corrected this. Frank
closed wfm
http://www.oooforum.org/forum/viewtopic.phtml?t=15527 suggests this is not a Debian issue. I tried it on Mandrake 10.1 and saw the reported behaviour
This is a confirmed problem on two different FC3 boxes also. openoffice.org-1.1.3-2.5.fc3 This is new behavior since this last update. Ctrl-C/Ctrl-V functionality is pretty core stuff. Changing the way it behaves is a MAJOR productivity inhibitor. This should be reopened and fixed, or at the very least discuss workarounds for those afflicted.
This bug has been confirmed on the RedHat Bugzilla site. https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=146580
This "feature" was due to a patch introduced by Novell into ooo-build sources, and is NOT part of the OpenOffice.org distributed by OpenOffice.org. Its purely a local addition to ooo-build (which is used as the basis of Debian, Novell, Suse, and Red Hat) and has already been removed from those sources. Again, this isn't not an OpenOffice.org issue but a local vendor one for those who use ooo-build.
*** Issue 42008 has been marked as a duplicate of this issue. ***
*** Issue 46349 has been marked as a duplicate of this issue. ***