On Thu, 28 Aug 2008 12:41:15 limeiying wrote: > Hi all, > I have a question to ask for help. > > What I did: > 1 Create a new notepad file, then enter some characters like > "test1 test2 test3 test4" which is divided by tab-delimited. Then > copy > these characters into the clipboard. 2 Create a new Calc file, select a > cell at will, double-click and enter the cell, then paste the content in > the clipboard to the this cell. Click any another cell at will. > > Found, > Spaces replaces tab-delimited when pasting a single line of tab-delimited > text from notepad > > My question: > Why do Spaces replace tab-delimited when pasting a single line of > tab-delimited text from notepad?
Because notepad replaces tabs with a pre-determined number (usually 5) of spaces. It (notepad) is a very simple text editor, and it's files are plain ASCII. It (notepad) does not store tabs as tabs. If you tried doing the same using commas or semi-colons as delimiters, it will probably work properly (Not really sure, as I don't use Windows). Possible simply using a single space between text should work OK as well (the space becomes the delimiter). > > Thanks a lot! > > Best regards! > ------------------ > Li meiying > Beijing Redflag Chinese 2000 Software CO.,LTD > Email:[EMAIL PROTECTED] > Tel：51570010-6140 > Fax：51570333 > Code：100176 > 2008-08-28 -- Alex Fisher Co-Lead, CD-ROM Project OpenOffice.org Marketing Community Contact Australia/New Zealand http://distribution.openoffice.org/cdrom/
signature.asc
Description: This is a digitally signed message part.
