wiln / as3xls

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

Letters "ç á é í ó ú ê ã õ" #41

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. When i use setCell() letters like "ç á é í ó ú ê ã õ" in Excel are 
show how #$ or another characters before save it's printing correctly
2.
3.

What is the expected output? What do you see instead?
The expected output is this ç á é í ó ú ê ã õ

Please use labels and text to provide additional information.

Original issue reported on code.google.com by vbdalmaz on 15 Mar 2011 at 4:37

GoogleCodeExporter commented 9 years ago
i tried to change Excelfile.as with this:
var charset:String = "utf-16";
cell.type = Type.LABEL;
cell.data.writeByte(0); 
cell.data.writeByte(0); 
cell.data.writeByte(0); 
var ba:ByteArray = new ByteArray(); 
ba.writeMultiByte(String(value),charset); 
cell.data.writeByte(ba.length); 
cell.data.writeMultiByte(String(value),charset);
Works fine with accents and other symbols but a strange effect... In MSSOffice 
2010 looks ok but if this same file open with MSOffice 2007 and previous dont 
work properly.
Any suggestion??????

Original comment by mpulido....@gmail.com on 5 May 2011 at 11:23

GoogleCodeExporter commented 9 years ago
did you solved the problema? Actually the problem is with la charset "utf-16". 
If you change to "utf-8" you wont get spaces between letters but it will not 
show propely the accents

Original comment by bharti.k...@gmail.com on 13 Jun 2012 at 12:07