CSV Export currency symbol

[ICRTouch]

Hello,

When exporting a report from the Stimulsoft Reports.JS viewer to a CSV file (selecting the "Data File" option), we are having an issue where the pound sign "£" is appearing on the CSV export as "£".

I have tried using the online demo on your website http://js.stimulsoft.com, and the same problem occurs. A good example is the report "Highlight Condition".

js.stimulsoft csv export.jpg (290.47 KiB) Viewed 3138 times

pound sign incorrect.jpg (267.49 KiB) Viewed 3138 times

Also I have noticed that when running any reports using Google Chrome the currency symbol shows as "$" when the field type is set to "Use Local Setting". I have checked the language setting of the browser, which is set to English rather than English (United States).

chrome language.jpg (134.36 KiB) Viewed 3138 times

However in Firefox, Opera, IE, Edge the currency symbol is showing correctly in our local currency (£).

[HighAley]

Hello.

The report is exported to CSV with UTF-8 encoding right.
This is an issue of the MS Excel. You should use the Import Tool.
Please, try to import the data using Data --> Import External Data --> Import Data.

Thank you.

[ICRTouch]

Hello,

Thank you for clarifying this, the import option in excel does show correctly when I select UTF-8.

Do you have any ideas how I can fix the other issue I have with "$" instead of "£" appearing in Chrome?

Thanks

[HighAley]

Hello.

Sorry for the delay with answer.
You could set the Currency Symbol manually.

Currency.png (24.06 KiB) Viewed 3111 times

Also we have made an improvement. If the Culture of the report is set to en-GB, the Currency will be shown using format of the specified culture.

Thank you.