Support Unicode

Alpha5 - August 14, 2009 - 08:33
Project:Views Excel Export
Version:6.x-1.x-dev
Component:Code
Category:feature request
Priority:normal
Assigned:Unassigned
Status:closed
Description

Excel file not show correct unicode font. Please support Unicode.

#1

jk@arsum.com - August 14, 2009 - 13:52

Can you please send me an example. It works for me.

#2

Daniel A. Beilinson - August 15, 2009 - 16:29

I think it's MS Excel not support UTF. And this's huge problem. Could you please support something other character encoding? Or tell me please where I can put encoding function, for example this (for win1251):

function utf2win1251($content)
{
                $newcontent = "";

                for ($i = 0; $i < strlen($content); $i++)
                {
                        $c1 = substr($content, $i, 1);
                        $byte1 = ord($c1);
                        if ($byte1>>5 == 6)
                        {
                                $i++;
                                $c2 = substr($content, $i, 1);
                                $byte2 = ord($c2);
                                $byte1 &= 31;
                                $byte2 &= 63;
                                $byte2 |= (($byte1 & 3) << 6);
                                $byte1 >>= 2;
                                $word = ($byte1<<8) + $byte2;

                                if ($word == 1025) $newcontent .= chr(168);
                                else if ($word == 1105) $newcontent .= chr(184);
                                else if ($word >= 0x0410 && $word <= 0x044F) $newcontent .= chr($word-848);
                                else
                                {
                                        $a = dechex($byte1);
                                        $a = str_pad($a, 2, "0", STR_PAD_LEFT);
                                        $b = dechex($byte2);
                                        $b = str_pad($b, 2, "0", STR_PAD_LEFT);
                                        $newcontent .= "?".$a.$b.";";
                                }
                        }
                        else
                                $newcontent .= $c1;
                }

        return $newcontent;
}

#3

Alpha5 - August 19, 2009 - 03:21

Only Excel not show correct UTF-8. DOC is OK.
But your module not support Header and Footer? Can you add this feature, please?

And more thing, when view field, fields can not merge into one column like view style is table.

#4

amogiz - August 31, 2009 - 19:45

I am trying to export fields that got french caracters (with accent) and this does not work. Could you help me to do this ? Thanx

#5

jk@arsum.com - November 4, 2009 - 17:42
Status:active» fixed

Now with utf8 support.

#6

jk@arsum.com - November 16, 2009 - 12:33
Status:fixed» closed
 
 

Drupal is a registered trademark of Dries Buytaert.