asked on November 14, 2019
Hi,
I try to export a CSV with Chinese content in Flexmonster. Open it with Excel. The Chinese text is not displayed correctly.
I wonder if Flexmonster can export UTF-8 with BOM CSV or UTF16 encoded CSV，so Excel can show CSV correct。
If not,Is it possible to add future versions?
⋅ November 14, 2019
Hello, Yabou,
Thank you for reaching out to us.
We didn't manage to reproduce the described issue on our side.
Please check out an example we made for you: https://jsfiddle.net/flexmonster/m02gxbcf/.
Let us know if it helped you. Otherwise, we would like to kindly ask you to modify the example above so that the issue is reproducible.
Feel free to contact us in case of additional questions.
Best Regards,
Illia
⋅ November 15, 2019
Hi,Illia
I reproduce issue in flexmonster V2.2.
I tried to use the latest trial version of flexmonster 2.7 to export CSV again, and the problem was solved. Thank you for your answer.
⋅ November 15, 2019
Hello, Yabou,
We are glad everything is working fine now.
Kind Regards,
Illia
⋅ July 22, 2022
Hi, Illia,
I'm sorry to find that the result csv file has a problem.
The numeric data with comma was changed the character with space at the place of comma at result file.
See the attached file.
I tried to export another dataset of the country in far east area and found the same problem.
please check again and let me know.
Best Regards,
SK Park
⋅ July 22, 2022
Hello!
Thank you for contacting us.
Kindly note that you can change the default number formatting as follows:
report: {
...
formats: [{
name: "",
thousandsSeparator: ","
}]
}
We have prepared a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/mv3spjL4/.
You can find more information about number formatting in our docs: https://www.flexmonster.com/doc/number-formatting/.
Please let us know if we understand you right and if this approach works for your case.
Looking forward to hearing from you.
Regards,
Solomiia
⋅ July 25, 2022
Hi, Solomiia,
Thanks for your rapid reply.
I mistook a space as a comma on the report.
I got the fact the default number formatting is a space.
Actually, the numeric data on the report didn't have commas originally.
I could change the format(from a space to a comma) with format button on the toolbar.
Export function was working well from the first.
Thank you for your hard work.
It must work for me very much.
Best regards,
SK Park
⋅ July 25, 2022
Hello!
Thank you for your feedback.
We are glad to hear that our approach was helpful.
Feel free to contact us in case of any other questions.
Best regards,
Solomiia