https://bugs.documentfoundation.org/show_bug.cgi?id=172905
Bug ID: 172905
Summary: CSV import does not detect ISO Latin1 input
Product: LibreOffice
Version: 25.8.7.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a data logger that creates CSV file using semicolons as separator.
The file starts like this:
#;Datum/Zeit;Bewegung;Taupunkt;Temperatur;Feuchtigkeit;Thermoelement
2;Thermoelement 1;
1;21.07.2026 06:33:17;2 ;11.1 °C;23.9 °C;44.8 %rH;;;
2;21.07.2026 06:43:17;2 ;6.5 °C;22.0 °C;36.7 %rH;;;
3;21.07.2026 06:53:17;2 ;7.2 °C;22.3 °C;37.9 %rH;;;
4;21.07.2026 07:03:17;2 ;7.6 °C;22.4 °C;38.8 %rH;;;
According to GNU Emacs the encoding is ISO-Latin1 (due to the ° glyph).
However when double-clicking the CSV to open it in Calc, it assumes it's
Unicode and shows Chinese glyphs instead, so you cannot see the structure of
the file.
Steps to Reproduce:
1. Double-click CSV file in Windows Explorer to open in In LibreOffice Calc
2. The import dialogue appears
Actual Results:
Data preview is shown as Chinese Unicode glyphs
Expected Results:
Data should be shown as text (ISO-Latin-1 glyphs)
Reproducible: Always
User Profile Reset: No
Additional Info:
Manually setting the encoding fixes the issue, but how should the user know?
--
You are receiving this mail because:
You are the assignee for the bug.
