Issue 10871 - Special Paste mode for CSV text
Summary: Special Paste mode for CSV text
Status: CLOSED DUPLICATE of issue 4040
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-01-22 20:40 UTC by Unknown
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-01-22 20:40:01 UTC 
When pasting CSV text into a spreadsheet I would like to have Calc parse the 
CSV text and place each comma-seperated value into it's own cell.  This could 
be accomodated with the Paste Special function.  Here's an example:

"My Name","123 Lake Dr.","Oregon","12345"

when pasted into Calc:

   A1          A2          A3      A5
My Name | 123 Lake Dr. | Oregon | 12345

I use CSV text a lot since it is such a handy and simple format for moving 
data between applications.  This feature would be very useful to me.
Comment 1 frank 2003-01-23 07:31:54 UTC 
Hi Bettina,

1 4 u

Frank
Comment 2 gessel 2003-05-22 22:26:07 UTC 
It would be very helpful to have the standard equivalent import modes
for data on the clipboard as for files on the hard disk.  For example,
from Paste...special, paste as, delimited text, etc.
Comment 3 daniel.rentz 2003-05-23 06:51:57 UTC 
I think you are talking about a functionality similar to Excel's "Text
to columns". This is covered in issue 4040. There is your solution
(Paste special) mentioned too.

As a workaround you can link an entire sheet to your CSV file.
Insert->Sheet->FromFile and Linked. This way the data will always be
updated when you open the spreadsheet (manually with Edit->Links).

*** This issue has been marked as a duplicate of 4040 ***
Comment 4 daniel.rentz 2003-05-23 06:52:15 UTC 
double->closed