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 (5,395 stars) (2,496 forks)batch import
help wanted

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

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.
3
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.
mostly clear
Prerequisites
Character encoding basicsCSV formatFamiliarity with UI Grid export options
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
40
Research direction
The issue involves CSV export encoding for Excel on OSX. Examine the CSV export module in UI Grid, likely in the exporter service files (e.g., exporter.js or related). Check if there is any encoding option or BOM (Byte Order Mark) handling. The user suggests that UTF 16LE works; consider adding a BOM for UTF 8 to help Excel detect encoding. Look at the exporterOlderExcelCompatibility option mentioned. Also check the maintainer's next steps—this issue may need a decision on whether to support different encodings. No linked PRs or comments from maintainers.