angular-ui/ui-grid

Encoding issue with Excel on OSX

Open

#5,428 opened on May 23, 2016

View on GitHub
 (1 comment) (0 reactions) (0 assignees)JavaScript (2,496 forks)batch import
help wanted

Repository metrics

Stars
 (5,395 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

Hello,

I encounter an issue with the encoding, when opening an exported csv file with Excel (on OSX). My csv contains some accentuated caracters. But, Excel does not correctly detect the encoding :

The csv is actually an UTF-8 file, I checked with a text editor :

One weird thing, is that Excel does not seem to recognize the encoding when importing the csv manually :

I tried playing with this option :

exporterOlderExcelCompatibility: true

But with no luck. It just made a mess with the first caracters :

I made the test that if I convert my UTF-8 file into UTF-16LE, then Excel will open it correctly. Is there any option to set the encoding during the export ? Or maybe a workaround to make it work ?

Thanks in advance for any help.

Regards,

Kilian

Contributor guide

Research direction
Research how to add a BOM (byte order mark) to CSV export to make Excel recognize UTF 8 encoding, or provide an encoding option to export as UTF 16LE.
Tech stack
javascript
Domain
frontend
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
JavaScript
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65