Hi,
I have an asp page that create a csv formatted file and then displays a link to the file (<A HREF>). When the user clicks on the link, the csv is opened in Internet Explorer with an Excel look and feel (Columns, Rows, Cells, etc).
Now, if the user's local settings dictate a delimiter other than a comma (eg semi-colon), then the csv is formatted in this way (eg "A";"B";"C").
I have a user in Turkey whose delimiter is semi-colon, but when he opens the csv from the <A HREF>, IE displays each record's data in column A, and shows commas between each field/column data item.
If however, the user accesses the csv directly by
\\servername\folder\file.csv, then the csv opens in Excel and is correctly formatted (ie, data in Col A, Col B, Col C).
This suggests that something in IE is causing the formatting problem, but I cannot figure out what or where.
Any suggestions?
Many Thanks
Gary
Topic Options
Post Options
Thanks(0)
