To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=105103
                 Issue #|105103
                 Summary|copy/paste from Calc to any non oo app joins the colum
                        |ns
               Component|Spreadsheet
                 Version|OOO310m19
                Platform|Macintosh
                     URL|
              OS/Version|Mac OS X
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|formatting
             Assigned to|spreadsheet
             Reported by|sweepingoar





------- Additional comments from sweeping...@openoffice.org Tue Sep 15 22:18:42 
+0000 2009 -------
If you copy a small block of data from Calc (more than one column) and paste it
into another application that isn't Writer, such as any other text editor, the
data gets collapsed into one long column. Example: If I have a Calc document
with six columns and several rows like the following:

One     Two     Three   Four    Five    Six
One     Two     Three   Four    Five    Six
One     Two     Three   Four    Five    Six
One     Two     Three   Four    Five    Six
One     Two     Three   Four    Five    Six
One     Two     Three   Four    Five    Six
One     Two     Three   Four    Five    Six
One     Two     Three   Four    Five    Six
One     Two     Three   Four    Five    Six
One     Two     Three   Four    Five    Six
One     Two     Three   Four    Five    Six

If I copy the cells using command/control-C and then switch to another,
non-OpenOffice.org application, such as TextWrangler or Appleworks or any
application that doesn't support tables, the grid turns into one long column,
like this:

One
Two 
Three
Four
Five
Six
One
Two 
Three
Four
Five
Six
One
Two 
Three
Four
Five
Six
One
Two 
Three
Four
Five
Six
One
Two 
Three
Four
Five
Six
One
Two 
Three
Four
Five
Six
One
Two 
Three
Four
Five
Six
One
Two 
Three
Four
Five
Six
One
Two 
Three
Four
Five
Six
One
Two 
Three
Four
Five
Six
One
Two 
Three
Four
Five
Six

It would be nice if it could convert the grid to tab delimited text as it is
pasting. That seems to be the more intuitive way to handle data going to non-OLE
aware apps.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

Reply via email to