Page 1 of 1

CSV Export currency symbol

Posted: Tue May 23, 2017 9:25 am
by 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
js.stimulsoft csv export.jpg (290.47 KiB) Viewed 3139 times
pound sign incorrect.jpg
pound sign incorrect.jpg (267.49 KiB) Viewed 3139 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
chrome language.jpg (134.36 KiB) Viewed 3139 times
However in Firefox, Opera, IE, Edge the currency symbol is showing correctly in our local currency (£).

Re: CSV Export currency symbol

Posted: Wed May 24, 2017 6:25 am
by 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.

Re: CSV Export currency symbol

Posted: Wed May 24, 2017 9:24 am
by 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

Re: CSV Export currency symbol

Posted: Mon May 29, 2017 10:47 am
by HighAley
Hello.

Sorry for the delay with answer.
You could set the Currency Symbol manually.
Currency.png
Currency.png (24.06 KiB) Viewed 3112 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.