Description: When using LibreCalc and opening CSV table from a file it shows UI for the file format. If my table format contains custom separator, this UI saves it for the next session usage. The bug appears when the separator is Unicode, like "→" character, for example. So when I next open similar file the UI shows "?" character instead of the expected "→", which breaks the custom workflow. Steps to Reproduce: 1. Open a .csv file where custom column separator is → Unicode character; 2. Close the file; 3. Try to open this or other similar file, having the preset remembered. Actual Results: The custom Unicode separator gets remembered as ? instead. Expected Results: The custom Unicode separator should be remembered as previously set, like → in this case. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.1.5.2 (x64) / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Repro in Version: 7.1.5.2 (x64) / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: CL No repro in Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 4debb7e8cc12563f46d1aaa58afdcb831f21cc83 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: CL
Also, no repro in Version: 7.2.0.4 (x64) / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: threaded
Can not confirm. The calc 'Text Import' dialog allows, and will remember, a single Unicode character like U+2192 RIGHTWARDS ARROW to be the 'Other' separator. But, the default "normal" separator checkboxes must first be cleared so that only the 'Other' checkbox and its input field remain enabled. The Unicode character must be pasted into the field (combining & modifier glyphs will not work) and Unicode toggle or numpad entry do not convert to the single character field separator. Configuration of the text import dialog is recorded to user profile and is persistent between LO sessions. Be aware that LibreOffice does not support Save as filter export of its calc sheets using any other separators than "normal" 'Tab', 'Comma', 'SemiColon', or 'Space' Also, neither the import filter nor the export filter support "multi-character field separator" for delimited data (bug 124899). =-testing-= Windows 10 (21H1) with Version: 7.2.0.4 (x64) / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded