Because of same reason of Bug 18404,I hope to add this attribute. I hope,if once user setted an attribute about encoding to HSSFWorkbook instace,he need not to care about this at each HSSFCell object. 1.Add "default encoding" attribute to HSSFWorkbook and add setter/getter method. 2.When a HSSFCell instance is created in the HSSFWorkbook instance,constractor of HSSFCell set automatically a copy of this attribute to itself. And if you can,set default encoding automatically based upon the Locale of JVM (e.g by using java.util.ResouceBundle).
Now,constant value about it already exist in HSSFWorkbook. But it is worked only setting each sheet's name.
All unicode strings (i think i caught them all) now write out correctly, this includes the sheet name as you descibe, plus headers & footers and a host of others that i cant remember. Jason