Bug #40
closed
Downloaded Agent time detail report in Excel is wrong
100%
Description
Hi goautodial technicians,
Am facing a big problem with reports in agent time detail it shows correctly in crm but when we download it i excel the minutes is changing it's position to hours and seconds is taking minutes position can any one help me with this problem will be highly appreciated..
i have installed goautodial-ce-2.0-final my system configuration is core 2 duo with 4 Gb ram
VERSION: 2.2.1-237
BUILD: 100510-2015
i have uploaded the image file what i see in crm and even i have attached the downloaded excel file please check it and please help me with this..
http://goautodial.org/projects/goautodialce/issues/new
Thanks!
Sanjeev
Files
| crm.png (166 KB) crm.png | Crm reports is correct | ||
| AGENT_TIME20110714-020005.csv (1.29 KB) AGENT_TIME20110714-020005.csv | downloaded report is wrong |
Updated by Demian Biscocho almost 13 years ago
- Status changed from New to Resolved
- Priority changed from High to Low
- % Done changed from 0 to 100
That is not a valid bug. That's the auto-format feature of MS Excel. Open it with a text editor and the format of the data is unchanged.
Updated by sanjeev raj almost 13 years ago
you mean that particular report cannot be viewed correctly in excel, it can ve viewed only in excel
Updated by sanjeev raj almost 13 years ago
please see the crm report and check with excel also and please tell me how to format in excel it is making our manual work a lot please help me with this
Updated by Demian Biscocho almost 13 years ago
It can probably. You might just need to disable the auto-formatting of Excel. I don't know how to do it since I don't use Excel. Try Google. ;)
Updated by Demian Biscocho almost 13 years ago
- Status changed from Resolved to Closed