Bug 132671 - FILEOPEN Text Import dialog does not store encoding of text separator 'other' character
Summary: FILEOPEN Text Import dialog does not store encoding of text separator 'other'...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-05-04 08:57 UTC by max
Modified: 2022-05-12 20:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Screen grabs of the dialog appearance first & second time (172.83 KB, application/vnd.oasis.opendocument.text)
2020-05-04 08:57 UTC, max
Details
Example UTF-16 format text file (34.46 KB, application/octet-stream)
2020-05-07 09:35 UTC, max
Details

Note You need to log in before you can comment on or make changes to this bug.
Description max 2020-05-04 08:57:00 UTC
Created attachment 160310 [details]
Screen grabs of the dialog appearance first & second time

I am importing a UTF-16 file which contains the ° character (alt-shift-8 on a UK Mac keyboard). I want to use these characters as separators. I enter the character as an 'other' separator and the file is imported. The next time I open a text file, in the Text Import dialog, the ° character has been replaced with a ᄚ

The character should not change when the dialog is reopened.

The attached document shows the appearance of the dialog with the original, correct character & the incorrect character when reopened.
Comment 1 Alex Thurgood 2020-05-07 09:02:09 UTC
@max :

Ideally, we would need a test CSV file with some sample data with which to test.

I don't have anything that makes UTF-16 CSV files by default on my Mac, unless you have another suggestion of where I might download one with such a configuration ?
Comment 2 max 2020-05-07 09:35:32 UTC
Created attachment 160481 [details]
Example UTF-16 format text file

This file was generated by "LTSpice XVII for OS X, Build Oct 25 2018, 14:56:22 US Pacific", downloadable from https://www.analog.com/en/design-center/design-tools-and-calculators/ltspice-simulator.html (However I notice a more recent version has just been uploaded)

To generate a file from a simulation result (i.e. waveform plot '.raw' file), click the settings icon (hammer) on the plot window toolbar, and then click the Data Export Tool button.
Comment 3 QA Administrators 2020-05-08 03:46:33 UTC Comment hidden (obsolete)
Comment 4 eisa01 2020-05-09 14:20:42 UTC
Can confirm on macOS and Windows: ° becomes garbled on second import try

I guess it must be the encoding of the "other" text identifier that is not saved

Version: 6.4.0.3 (x64)
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 5 QA Administrators 2022-05-10 03:29:10 UTC Comment hidden (obsolete)
Comment 6 max 2022-05-12 20:40:02 UTC
The uploaded example file's encoding is now remembered and correctly applied to the delimiter character edit control, in version 7.3.2.2. OS is macOS 12.3.1