Apache OpenOffice (AOO) Bugzilla – Issue 30564
Text to columns
Last modified: 2004-06-22 13:20:38 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.
Double to Issue 4040. Please use the query functionality before submitting Issues. Frank *** This issue has been marked as a duplicate of 4040 ***
closed double