allenf972 wrote:P.S. Again, out of curiosity, are there any CSV import tricks I should know about?
One of these marvellous tricks is opening a CALC-sheet and filling the table with sheet-data
by a simple drag/drop of csv-files at the very upper banner of the tool.
If you drag /drop a csv-file this way at an OOo 2.3-application you will be asked once for relevant formatting data. In German csv-files you will normally have to select the semicolon as a separator.
The next drag /droppings of csv-files to new documents will automatically be processed with the previously entered formatting-settings.
If you do this drag /droppings of csv-files to an Excel-tool you will not be asked for a separator and the sheet will automatically be filled with correct data.
This trick is hardly known to any user, but I think this drag/dropping-functionality is excellent.