Character range encodin issues for ruby > 1.8.7

[interventure]

HI,

in one of the our projects we use Writeexcel and I think is great.
One problem what we found so far is encoding issues with some of the characters
« » ² ³ µ ¶
We think because they belongs to totally different characters range..Please take a look:
https://en.wikipedia.org/wiki/Unicode_subscripts_and_superscripts#Superscripts_and_subscripts_block
When we generate excel file, the characters either missing or we got ??????...

In all our files we have ruby encoding flag:
# coding: UTF-8

Any help or idea how we can fix this it would be great...

Regards,
Aleksandar

[MSeal]

If you're loading in ruby, try .force_encoding(Encoding::UTF_16LE).encode(Encoding::UTF_8) on the cell content... I recently ran into this as well (opening another issue on the topic).