Issue 30564 - Text to columns
Summary: Text to columns
Status: CLOSED DUPLICATE of issue 4040
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: PC Windows 98
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-06-22 12:59 UTC by atambling
Modified: 2004-06-22 13:20 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description atambling 2004-06-22 12:59:34 UTC
A feature of MS Excel which I have found extremely useful in the past, is Text 
to Columns. It is found in the Excel Data menu. An equivalent of the feature 
does exist in OOo, but it is relatively difficult to use: it is in the Left, 
Middle and Right commands. While these do work, they take longer than the Excel 
feature.
Typically I and my colleagues used this feature for converting database dumps 
to Excel spreadsheet formats. When the data was organised correctly in Excel 
the other features of Excel were employed to change the database info and then 
return it to the application from whence it came. The applications are Rockwell 
Software's RSLogix 500, and Wonderware's InTouch; there are also many other 
applications like them.
Comment 1 frank 2004-06-22 13:20:19 UTC
Double to Issue 4040.

Please use the query functionality before submitting Issues.

Frank

*** This issue has been marked as a duplicate of 4040 ***
Comment 2 frank 2004-06-22 13:20:38 UTC
closed double