Thanks I did that. Under INSTALL it says goto Tools -> Package Manager but I don't see a Package Manager option under tools?
To install/uninstall TextToColumns: ------------------------------------------- From any OpenOffice.org document: menu Tools -> Package manager... Couldn't find it in help either. -----Original Message----- From: Paul [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 06:11 PM To: [email protected], [EMAIL PROTECTED] Subject: Re: [users] Cut/Paste Hi Everyone I am using a spreadsheet (whatever the OO name for excel is) with headings like this: NAME PID %CPU VSZ each is its own column. I have an appropriate ps command to give the above output for a bunch of processes. Trouble is, when I copy and paste into the spreadsheet it puts it all in one column (everything under NAME) instead of distributing it to the 4 columns (name under NAME, pid under PID, etc). Anybody know how to copy/paste to get the date into separate columns instead of 1? That is because calc is treating your paste as text. You need to transform the text to columns. This is done by using an addon found here: http://www.ooomacros.org/user.php#104183 /paul -- Processing Key for cracking HD DVD's: 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0 ----- Try Torpark; a small portable, open-source, built on Firefox browser that enables anonymous browsing. Requires no installation : http://www.torrify.com/
