Author Topic: QM1.6.0.1 export to excel,the top column was ??  (Read 4442 times)

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
QM1.6.0.1 export to excel,the top column was ??
« on: May 20, 2010, 04:17:08 »
I update it from 1.5.5 use yum,and when i export to excel,the title column was "?",aslo in the xml-rpc response,was it my problem or the QM's bug? ;)

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: QM1.6.0.1 export to excel,the top column was ??
« Reply #1 on: May 20, 2010, 08:52:42 »
maybe it's my problem,it is because i translate it to zh_CN,where can i modify  to slove it?

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: QM1.6.0.1 export to excel,the top column was ??
« Reply #2 on: May 20, 2010, 10:28:18 »
Why don't you contribute back the Chinese translation? :)

That is caused by the file encoding that does not support non ASCII characters.


coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
« Last Edit: June 01, 2010, 16:45:53 by coolname »

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: QM1.6.0.1 export to excel,the top column was ??
« Reply #4 on: June 08, 2010, 14:37:24 »
It was expected to be already solved, we track this as issue #1112

I will keep you posted.

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: QM1.6.0.1 export to excel,the top column was ??
« Reply #5 on: July 10, 2010, 10:00:23 »
1.6.1,the xml-rpc seem to fine,the export to xls & csv seems to still there

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: QM1.6.0.1 export to excel,the top column was ??
« Reply #6 on: July 12, 2010, 10:40:18 »
Have you tried the advanced Excel mode?

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: QM1.6.0.1 export to excel,the top column was ??
« Reply #7 on: July 13, 2010, 04:02:48 »
Sorry
How?

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: QM1.6.0.1 export to excel,the top column was ??
« Reply #8 on: July 13, 2010, 14:10:09 »
Try this:

Code: [Select]
default.useXmlExcel=true
Will work with Excel 2007+

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: QM1.6.0.1 export to excel,the top column was ??
« Reply #9 on: July 15, 2010, 03:19:24 »
thanks
it works

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: QM1.6.0.1 export to excel,the top column was ??
« Reply #10 on: July 16, 2010, 09:23:12 »
That's great.