parthipan30 / as3xls

Automatically exported from code.google.com/p/as3xls
0 stars 0 forks source link

umlaut encoding #50

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. export an excel file with umlauts (äöü)
2. open file in ms excel

suggested fix in ExcelFile.as:

187 public function saveToByteArray(charSet:String = "utf-8"):ByteArray {

257 cell.data.writeMultiByte(value, charSet);

Original issue reported on code.google.com by matthias...@gmail.com on 28 Sep 2011 at 12:10

Attachments:

GoogleCodeExporter commented 8 years ago
This will allow diffrent string encodings. see supported encoding
http://help.adobe.com/en_US/FlashPlatform/reference/actionscript/3/charset-codes
.html.

In my case I use "iso-8859-1". UTF-8 also allows umlauts but ms excel does not 
display them right unless there iso encoded.

This might even works with chinese, russian and hebrew etc.

Original comment by matthias...@gmail.com on 28 Sep 2011 at 12:16

GoogleCodeExporter commented 8 years ago
Setting charSet to "x-ansi" would show umlauts fine in excel.
Any ideas for which character-set should work to display Russian, please? 

Original comment by achilles...@googlemail.com on 20 Oct 2011 at 2:31

GoogleCodeExporter commented 8 years ago
Thanks a lot.
It works for me with x-cp1250 charset.

Regards,
Eric

Original comment by eric.paw...@gmail.com on 4 Nov 2011 at 3:06

GoogleCodeExporter commented 8 years ago
Thank you.
this information I have been very helpful

Original comment by enlinea...@gmail.com on 23 Nov 2011 at 2:48