Issue 77013 - Data: Text to columns
Summary: Data: Text to columns
Status: CLOSED DUPLICATE of issue 4040
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.2
Hardware: PC (x86_64) Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-05-06 21:31 UTC by markvolz
Modified: 2007-06-15 09:48 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 markvolz 2007-05-06 21:31:08 UTC 
One of my main concerns before I made the switch to open office was that before
there was no data: text to columns feature - something that I use all the time.
 Fortunately I did see that Calc does indeed have that feature via the paste
special> unformatted text.

I think that the way of accessing the calcs method of data>text to columns is
too obscure to find for many users; after all ms excel has the text to columns
feature in a huge icon with its data banner.  

I am thankful that there is the paste special> unformatted text>delimited
feature.  I just think it is too hidden for most people.
Comment 1 onejaguar 2007-06-14 22:35:21 UTC 
Duplicate of Issue 4040.

As of v2.2, text pasted into Calc from an unknown source will invoke the Text
Import dialog box, you shouldn't need to do "paste special."

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 2 frank 2007-06-15 09:48:17 UTC 
double to Issue 4040

*** This issue has been marked as a duplicate of 4040 ***
Comment 3 frank 2007-06-15 09:48:38 UTC 
closed double