Issue 38888 - Text to columns (refer to Excel) - import from csv data
Summary: Text to columns (refer to Excel) - import from csv data
Status: CLOSED DUPLICATE of issue 4040
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-12-13 09:06 UTC by tapio_junes
Modified: 2007-06-15 09:56 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
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 tapio_junes 2004-12-13 09:06:59 UTC 
"Text to Columns" that I use in MS-Excel - is missing from Open office Chart.
The function is very handy when handling Comma Separated Value - data 
and does the ordering from csv data into the rows and columns. That is 
needed when copy-pasting .csv-"raw"data from the internet-site directly 
to the openoffice.org Calc and sorting and analyzing the data there.

This lack of functionality is literally preventing me from using Open Office 2.0
Chart in hour-reporting to our customer and I have to use Excel in that in stead.

BR,
Tapio Junes
CEO
Comment 1 kla 2005-02-08 06:56:58 UTC 
.
Comment 2 IngridvdM 2006-03-08 16:17:38 UTC 
I think this is a general calc issue and not a chart specific thing so I changed
the component to be spreadsheet.
Comment 3 onejaguar 2007-06-14 22:31:03 UTC 
Duplicate of Issue 4040.

Note that as of v2.2, text pasted into Calc from an unknown source will invoke
the Text Import dialog box which provides this functionality.

There is also a macro available to do this to a range of data (as Excel does) here:
http://www.ooomacros.org/user.php#104183
Comment 4 frank 2007-06-15 09:54:50 UTC 
double to Issue 4040

*** This issue has been marked as a duplicate of 40404 ***
Comment 5 frank 2007-06-15 09:55:37 UTC 
wrong Issue as double
Comment 6 frank 2007-06-15 09:56:11 UTC 
double to Issue 4040

*** This issue has been marked as a duplicate of 4040 ***
Comment 7 frank 2007-06-15 09:56:36 UTC 
closed double