Hi Manali,
If you're importing data that's comma separated or separated by some other
delimiter, there is no option to add additional column separators as it's
assumed that the columns are already defined. If you're importing raw text, you
can add column breaks by clicking on the ruler above the box showing the import
text. To remove a column break, click on it at the ruler.
If you want to paste the data into a spreadsheet, then parse into columns,
you'll need the text to columns macro written by Paolo Mantovani. I believe
that you'll find it if you search the OOo site for 'text to columns'.
tc
autoresponse:help hints for unsubscribed users wrote:
Manali Sabharwal <[EMAIL PROTECTED]> writes:
------=_NextPart_000_00A8_01C5846D.F64A18C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Dear Anthony,
Thanks for your help.
1.) Well while importing csv file we are able to get data in columns as we want. But if we could have an option to put/remove
column divider as in Microsoft Office it would be really good.
2.) But what happens in case we are copying data directly. Can we define
columns in such case.
Regards,
Manali Sabharwal
I. T. Executive
Email: [EMAIL PROTECTED]
--------------------------------------------------------------------------------
----- Original Message -----
From: "Anthony Chilco" <[EMAIL PROTECTED]>
To: <[email protected]>; <[EMAIL PROTECTED]>
Sent: Saturday, July 09, 2005 1:28 AM
Subject: Re: [users] Help for text file
Hi Manali,
Rename your text file to *.csv. Open calc and use 'file /
open' and select text/csv text as the file type. You get a
dialogue that allows you to parse the incoming data.
tc
Manali Sabharwal wrote:
Dear Openoffice team,
In Openoffice 2.0 beta I am having various problem with text data :
1. I am unable to import text data in Openoffice Calc. (It opens in Openoffice
Writer)
2. If I copy text data in openoffice calc then there is no option to handle
data (like in Microsoft office there is an option :
data -> Text to Columns). All the columns come in haphazard manner.
Is there any option to work this out. Pls. help.
Regards,
Manali Sabharwal
I. T. Executive
Email: [EMAIL PROTECTED]
Carlson Wagonlit Travel
7 E- H, Vandhna Building,
11, Tolstoy Marg,
New Delhi - 110001, India.
Reception: +91 (11) 23322000 Ext: 235
Fax: +91 (11) 23319689
www.carlsonwagonlit.com
With offices in more than 140 countries, Carlson Wagonlit Travel deploys the
right people, processes, skills and technologies to
consistently deliver great service and bottom line results to our corporate
clients.
--------------------------------------------------------------------------------
This email may contain confidential and/or privileged information and is intended only for the use of the individual or entity
named
above. If you have received it in error, please advise Carlson Wagonlit Travel immediately by reply email and delete the
original.
Any further use of this email by you is strictly prohibited.
------=_NextPart_000_00A8_01C5846D.F64A18C0--
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
