Hi Ennio-Sr, On Sat, Mar 12, 2005 at 18:47:38 +0100, Ennio-Sr wrote:
> What happens, in effect, is that the original web-site html_tables being > inserted is seen by OOo as a one column spreadsheet: copy-pasting from > column A of the ss copies the entire row to destination cell. I didn't > realize that at the beginning as everything seemed so well aligned to > give me the impression of being a multi-columns ss. ;). So maybe the original document really _is_ a table consisting of only one column, just spaces inserted to look as if it was layouted in columns. But this is all guessing around now. If choosing the space separator like mentioned blow doesn't help, you might consider to upload your document(s) somewhere and give us an URL so that we can access it and have a look. > > If I download the same HTML_tables from a browser (Netscape/Opera), > > save it as a .txt and then (from OOo-1.1.4) do: > > > > File > Open, the Text Import dialog box appears showing in the Separator > > options that the file is Tab delimited: in effect the table appears well > > aligned in the bottom pre-view window, but when I go ahead and a new Cal > > sheet appears with the contents of the table I can see that no real > > column separation has occurred, as when I click on a number the whole > > line is selected. This happens also if I choose a different separator. So what is the separator that is used in the .txt file to separate columns? Choose that. I assume that it is a blank/space. > Obviously, I'm selecting Files of Type "Text CSV" as suggested by Help. > If I don't choose Text CSV, the file will be imported in OO-Writer as an > ordinary document, although the data are still aligned. sigh.. yes.. because it is text, that's why you can select the filter type to open it in Calc. > > It is worth noting that, after experiencing what said above,I tried to > > '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. > > if the search/substitution is > > made on single space, the substitution occurs as many times as the > > spaces involved (not always the same ;) ). Normal. > I'm not an expert to judge whether this occurs as a consequence of how > the web site is organized, or of the kind of treatment (presumably) > reserved to it by the browser downloading it as a .txt file. I can > imagine that the web-site is w$ 'oriented', if this may matter. > 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. 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]
