Hi Ennio-Sr, On Fri, Mar 18, 2005 at 17:35:40 +0100, Ennio-Sr wrote:
> > In the import dialog switch from "Separated by" to "Fixed width" and set > > the columns in the ruler of the preview window. > > > > Aaahhh! That's it: I didn't notice before there was a ruler you could > adjust to correctly fit the columns! It works perfectly now, and the > resulting file behaves like a Calc spreadsheet :-) > > May be the preview window could be integrated with a small help note > saying, more or less: "Look folks, I'm automagically selecting Tab > separated fields, but be aware you can adjust things manually choosing > other separators or fixed width and moving the cursor to adjust > columns" ? ;) An ultimate tip: use the online help in dialogs when you're stuck.. > Now, it would be extremely interesting were it possible to do the same > 'adjustment' with the Insert > External Data commands (directly from the > web site) ... Insert external data only works with HTML, Calc and Excel documents, not with CSV. If your HTML data is already broken it should be fixed there. > When my webspace is ready I'd be in a position to upload the relevant > files, if you think it worth. I think that's not necessary anymore now that we clarified it. > Thanks a lot for your assistance, Reike, I insist on calling me Eike ;-) 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]
