OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Changes in Paste behavior between OOo 3.3.0 and 3.4.0 - Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
SoundConception
General User
General User


Joined: 18 Aug 2010
Posts: 12
Location: South Australia

PostPosted: Wed Jun 20, 2012 5:58 pm    Post subject: Changes in Paste behavior between OOo 3.3.0 and 3.4.0 - Calc Reply with quote

The behavior of Calc has changed between OOo 3.3.0 and 3.3.4 when pasting a multi cell selection.
I have found a few related threads on this pasteing issue but haven't seen anything to clearly resolve it.

The Issue:
- Select a cell range and Copy the contents to the clipboard
- Move to a new position and Paste or Paste Special

Paste Behavior In OOo 3.3.0
- The contents of the clipboard are pasted at the new location.

Paste Behavior In OOo 3.4.0
- The Text Import dialog appears.

Paste Special Behavior In OOo 3.3.0
- The Paste Special dialog appears with flexible options including Flags for Text, Numbers, Formats, Formulas etc.

Paste Special Behavior In OOo 3.4.0
- The Text Import dialog appears.

i.e. In OOo 3.4.0 most of the flexibility provided by the Paste Special dialog is lost. This is a significant step backward in my opinion.

Does anyone know how to access the old Paste Special dialog in OOo 3.4.0 ?????

I have tried this on numerous machines and found the same result.
Back to top
View user's profile Send private message
CSLam
General User
General User


Joined: 08 Aug 2012
Posts: 29
Location: Hong Kong

PostPosted: Thu Aug 30, 2012 6:03 pm    Post subject: Reply with quote

There looks a further issue with OO 3.4 pasting :-

(1) Copy, say, a text block of 20 lines (from a table in a Writer document),
(2) Paste (paste special, RTF format) to Calc with only 20 lines not protected, ie. a "hole" just large enough to hold the data going to get imported.

Process will fail - cell protected returned. However, if you copy-and-paste 19 text lines into the 20 rows, it will get through without problem. In such a way, you will always have to copy-and-paste one line less, and handling the outstanding line afterwards. One process becomes two after OO upgrade.

This is not convenient.

CSLam
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group