Openoffice oocalc weired behaour on CSV file

to open a CSV file using openoffice oocalc, the output surprised my a lot. the CSV contains lines  as this

MON060240,Roslyn,MOM06-240
MON050042,Roslyn,MON05-42S
MON050018,Roslyn,MOM05-18
MON050002,Roslyn,MON05-2
MON050032,Roslyn,MON05-32
MON050060,Roslyn,MON05-60
MON050008,Roslyn,MON05-8
MON050028,Roslyn,MON05-28
M0N050040,Roslyn,MON05-40S

open it at oocalc as comma delimited file, the result is weird, as

MON060240 Roslyn MOM06-240
MON050042 Roslyn MON05-42S
MON050018 Roslyn MOM05-18
MON050002 Roslyn 05/02/10
MON050032 Roslyn 05/01/32
MON050060 Roslyn 05/01/60
MON050008 Roslyn 05/08/10
MON050028 Roslyn 05/28/10
M0N050040 Roslyn MON05-40S

During the opening, if I change the 3rd column from Standard to Text, get the right form.

I don’t want this ‘intelligent’ changes how to change the default?

About these ads

One response to “Openoffice oocalc weired behaour on CSV file

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s