I wanted to give an ods file to a microsoft office user so i saved the file as xls and now all characters became question marks. Only the numbers are intact. I tried to open the file as text cvs and selected all the available character sets but the question marks don’t change…
Are you sure he has the font installed?
I never gave the file. The problem is in the same computer after the save as…
Somewhere along the line you have a miss match between the text you are using and the character supported in the character sets. I don’t use MS office but I assume the problem is the same using XLS.
The � character is the Unicode Replacement Character is the general substitute character for any “unknown” character in a document or spreadsheet. If you export the file as CVS you must choose a character set that contains all the text characters you
use. Libreoffice uses Unicode (UTF-8) which contains every character used in Europe and the world.
If you choose a character set that does not contain all your text characters you have such, as ISO-8859-1 (Western Europe) or US-ASCII all the missing characters will be replaced and end up as �.
Likewise if you import the file into office, the correct character set for import must be chosen. Likewise the Fonts must support the characters used.
Hope this helps.
@petermau, It might be a little clearer to say: “If you choose a character set that does not contain all your text characters, such as ISO-8859-1 (Western Europe) or US-ASCII, all the missing characters will be replaced and end up as �.”
Yes, would be a little clearer, but less accurate. The � is a Unicode character and only shown if the software supports Unicode. The replacement character in US-ASCII and ISO-8859-1 X’1A’ would show up as a blank space and I was trying to avoid that complication. Sorry if my note was confusing.
Aha! Well, any folks interested in the nuances of your answer may simply let their eyes walk down the page to our comments here and read the further explanation for themselves. So it all works out quite well in the end