angular-ui/ui-grid

Encoding issue with Excel on OSX

Open

#5,428 建立於 2016年5月23日

在 GitHub 查看
 (1 留言) (0 反應) (0 負責人)JavaScript (5,395 star) (2,496 fork)batch import
help wanted

描述

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

貢獻者指南

技術棧
javascript
領域
frontend
議題類型
bug
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
3
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
1-3 hours
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
stale
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
mostly clear
前置要求
Character encoding basicsCSV formatFamiliarity with UI Grid export options
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
40
研究方向
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.