File listing to CSV - wrong separator

Bugs found in XnView Classic. Please report only one bug per topic!

Moderators: helmut, XnTriq, xnview

Post Reply
User avatar
Peter2
XnThusiast
Posts: 1365
Joined: Thu Nov 24, 2005 3:07 pm
Location: CH

File listing to CSV - wrong separator

Post by Peter2 »

I tried to export a filelist to CSV and got a comma , as separator. My Excel (2003, german) needs and saves "semicolon ;" as separator.

Is this a bug or is it dependent from language and country settings?

Peter
XnViewMP <Current version> German, XnConvert <Current version>, Win 10
User avatar
xnview
Author of XnView
Posts: 46255
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: File listing to CSV - wrong separator

Post by xnview »

And CSV can't be imported if you select the good separator in Excel?
Pierre.
User avatar
Peter2
XnThusiast
Posts: 1365
Joined: Thu Nov 24, 2005 3:07 pm
Location: CH

Re: File listing to CSV - wrong separator

Post by Peter2 »

Of source - selecting a separator does everything.

BUT: A doubleclick on a CSV (with ",") opens it with "all in one column"; a doubleclick on a semicolon-CSV opens it perfectly.

Peter
XnViewMP <Current version> German, XnConvert <Current version>, Win 10
User avatar
xnview
Author of XnView
Posts: 46255
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: File listing to CSV - wrong separator

Post by xnview »

; is the default separator?
Pierre.
User avatar
Peter2
XnThusiast
Posts: 1365
Joined: Thu Nov 24, 2005 3:07 pm
Location: CH

Re: File listing to CSV - wrong separator

Post by Peter2 »

xnview wrote:; is the default separator?
Yes - in my configuration. "," is very often used as decimal point (Germany, Austria), and therefore it can not be a separator (IMHO).
"Pi: 3,1415927"

Peter
XnViewMP <Current version> German, XnConvert <Current version>, Win 10
Post Reply