Open fails, looks like chinese

users
#1

I'm trying to use calc to format some Ordnance Survey data.
It consists of 201 rows of 201 values.
The values are all short ascii numeric, such as 123.4

It seems to think the data is a long string of what looks (to me) like
chinese characters.

I downloaded an up-to-date copy of Calc, with the same result.

#2

JimJoyce wrote

Am attaching the offending .csv.
I am surprised with the result. I've since tried to read other OS files,
.csv or .asc.
They are all producing 'chinese'.

You need to choose Character Set=System Language=English(USA) and check
"Separated by" "Space" "Merge delimiters"

With these settings I didn't have any odd results...

Hope this helps...

#3

Hi Jay,
Am attaching the offending .csv.
I am surprised with the result. I've since tried to read other OS files,
.csv or .asc.
They are all producing 'chinese'.
Thanks for trying,
JJ

#4

Works fine for me.

How are you trying to import the data? What are the settings on the Text
Import Dialog?

jomali

#5

jomali wrote

Works fine for me.

How are you trying to import the data? What are the settings on the Text
Import Dialog?

Problem solved. See answer here (it hasn't been accepted by the mailing list
yet)
http://nabble.documentfoundation.org/Open-fails-looks-like-chinese-tp4079539p4079592.html

#6

Thank you,
Yes, The Problem is Solved.
My problem, 'I'm too impetuous', will probably never be solved !

#7

Hi :slight_smile:
Attachments don't work on mailing lists which is why we have been trying to
help you figure out how to upload to Nabble.
Regards from
Tom :slight_smile: