Brewster Gillett wrote:
On Mon, 2010-03-01 at 12:34 +0100, Andreas Saeger wrote:
When you paste zip-codes from a decent application (database?) the
clipboard data are marked as text and Calc will treat them as text in
this particular case.
Ah, it's about csv files again. Nice to hear after all. That is a
database exchange format in plain text and a spreadsheet is definitively
the wrong application (yes, I know that everybody uses Excel, like every
database admin hates Excel for what it does to valid csv).
Open your text file in a text editor if you need to edit the data. For
Windows there is at least one excellent csv editor which does not
evaluate your data and keeps everything as it has been imported:
http://csved.sjfrancke.nl/ (1.4MB of extremely helpful software).
If you want to read csv data into office documents, simply store this
csv together with all similar csv you may have in one dedicated
directory and connect a Base file to this directory. All the csv tables
are accessible at once without importing anything. The import options
are stored in the Base file. YOu can filter, sort, rearrange the data by
means of very simple SQL-queries and a few extra clicks define pretty
reports in Writer.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
