search

kartik-v / yii2-grid

Enhanced GridView with various utilities for Yii Framework 2.0
http://demos.krajee.com/grid
Other
556 stars 303 forks source link

How to remove currency symbol and thousand separator from excel export #926

Closed josephpnc closed 4 years ago

josephpnc commented 5 years ago

Hi

I'm using Kartik export and 'exportConversions' option. I hope to remove currency symbol and thousands separator from the exported excel file without any success yet. What I've done:

        'exportConversions' => [
            ['from' => ',' , 'to' => ''],
            ['from' => '$', 'to' => '']
        ],

As my values for "to" is '' (nothing), it doesn't work.

If I use one empty space for the "to" value, it works. But then my number has spaces in them. I've tried to google but haven't figure out how.

Any help is highly appreciated. Thanks! Joseph

stale[bot] commented 5 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.