Opened 4 years ago

Last modified 3 years ago

#333 new Issue

Output to Excel glitch in Windows10

Reported by: Lois Haggard Owned by:
Priority: Unknown Milestone: Unassigned
Component: View-App Version: Unknown
Severity: Unknown Keywords:
Cc: kneerings@…

Description

In Windows10, and Excel2016, in Internet Explorer11, the output to Excel function is not working. The downloaded file is empty.

Attachments (1)

ExcelSettings.PNG (49.2 KB) - added by Kim Neerings 4 years ago.

Download all attachments as: .zip

Change History (7)

comment:1 Changed 4 years ago by Lois Haggard

Type: DefectIssue

New Kendo functionality would actually export a true Excel file. We could also write an xslt to export a CSV, which the user could open in Excel. Garth thinks we'd be happier with the functionality that Kendo would provide. But we don't have experience with it, so we're not totally sure.

comment:2 Changed 4 years ago by Kim Neerings

Cc: kneerings@… added

This has now become an issue for Utah as well. We also tried in Chrome (Version 53.0.2785.89 m) and Firefox (47.0.1). I'm running Excel 2010.

We've had several users ask about this. If we could get a fix done relatively quickly, that would be good. It's time to update Indicators so folks will be needing the Export to Excel function.

Last edited 4 years ago by Kim Neerings (previous) (diff)

comment:3 Changed 4 years ago by Tong Zheng

We have a few people to try from home computers. The feature works fine on both Excel 2010 and 2016. We are guessing if it's because the firewall etc. makes the issue for the exporting. Tong opens a ticket for Utah DTS to look into it.

Changed 4 years ago by Kim Neerings

Attachment: ExcelSettings.PNG added

comment:4 Changed 4 years ago by Kim Neerings

We found a possible fix! DTS thinks it was the result of a Windows update. We changed some settings in Excel on both Tong and my machines and it works.

To apply fix, open Excel and select File -> Options -> Trust Center -> Trust Center Settings -> Protected View. Then uncheck the top two boxes (see attached screenshot).

comment:5 Changed 4 years ago by Lois Haggard

This fix worked in NM, but not sure about Windows 10. Will test that.

comment:6 Changed 3 years ago by navina

Lois tested and said it does work in Windows 10 and so this ticket can be closed.

Note: See TracTickets for help on using tickets.