John Rotomano wrote:
John W. Kennedy wrote:
Thanks for the reply. I am currently using OOo 2.3, but previuos
versions have had the same problem. I run Kubuntu 7.04 and 6.06.
I download shop inventory from a suplier. The download is in .csv
format and includes 20 or so columns of product data. Some of the
columns manufacturer name, product name and model and one or both of
these symbols © ®. If I use UTF-8 I get a rectangular box instead of
the symbol. If I use Western Europe (ISO-8859-1), I get the correct
symbol. Once I've downloaded the I make a few changes, set pricing
info, save the file in csv format and then import into a MySQL
database. I've found the only way to preserve these symbols is to
make sure I use Western Europe (ISO-8859-1) every time the data is
saved. The font used doesn't seem to be part of the problem, as I've
used a couple of diferrent fonts with the same problem.
OK, if it's merely a question of setting the /default/, then, no, I
don't believe there's a way to do it. Perhaps you could create a macro.
a workaround could bet to CONVERT the csv file from ISO-8859-1 into
UTF-8, by opening it first in a word processor like writer and then
saving it again, as csv files are simple text files.
In writer try file -> open and choose TEXT ENCODED ISO-8859-1 file type
and then file -> save as and choose TEXT ENCODED UTF-8 file type
Unless he's processing the same file over and over again, that doesn't
help. What he wants to do is change the /default/, so the he doesn't
have to switch from the default UTF-8 to his desired ISO-8859-1 every
single time, so you're, in effect, advising him to do two operations to
avoid one.
I'm not sure but that there isn't a way to change the default, even
though I can't find it. I notice that my system defaults to
Windows-1252, rather than UTF-8. However, that may be a hard-coded
difference between his Linux build and my Windows build.
--
John W. Kennedy
A proud member of the reality-based community.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
