Hi Ennio-Sr, On Thu, Mar 17, 2005 at 22:51:04 +0100, Ennio-Sr wrote:
> > upload your document(s) somewhere and give us an URL so that we can > > access it and have a look. > I'd do that very willingly, however I don't have the capabilities to > enable my reserved web space with my DSL provider ;( (with so many kids > around sending worms, virus and similar stuff I need managing security > firewalls first) [But see below] I don't quite get what you're trying to tell us, using the webspace provided by the provider (err.. yes..) shouldn't make it necessary to think about doing the firewalling yourself, but anyway, there are so many free webspace providers out there, see http://www.freewebspace.net/, that it shouldn't be a problem to find one that suits the need to just temporarily publish 1-2 files. I, for example, would use http://rapidshare.de/ for instant access. > > > > 'prepare' said .txt file with some text-utils (like sed, tr) and noticed > > > > that if I search for Tabs nothing changes; > > > > So it is not tab delimited. > > > It's not me but Calc that selects the Tab delimited item when showing > the dialog box ... ;) Well, then deselect it and select some other. There is a preview that shows you what happens and how the data splits up in columns. > > > Hexedit-ing the downloaded .txt file I can see no Tab chars in it, but > > > only spaces (char 0x20). [*] > > > > Then select the space as separator, and maybe check the "merge > > delimiters" option. > > > > I tried "merge delimiters": it gets columns right (in the sense that > they become 'real' cells, not rows) but the cell contents is no longer > aligned. Let me explain better with a short example (where each point > represents a space): > > File.txt: > First line ends here.........***..10,15..-0,15..12,30..Mar 17 05.. > Second line .................***.200,02..+1,30..33,50..Mar 17 05.. > > will appear in Calc: > First line ends here.........***..10,15..-0,15..12,30..Mar 17 05.. > Second line....***.200,02..+1,30..33,50..Mar 17 05.. In the import dialog switch from "Separated by" to "Fixed width" and set the columns in the ruler of the preview window. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
