https://bugs.documentfoundation.org/show_bug.cgi?id=168364
--- Comment #6 from ace_dent <[email protected]> --- @ady - thanks. I've add further information below. For a reference CSV file handler, I suggest SmoothCSV (https://github.com/kohii/smoothcsv3). It correctly opens and displays the minimum test case attached. Tested with LibreOffice Version: 26.2.3.2 (AARCH64) Build ID: 70e089b17412e4cb7773e41413306b17a2328c34 CPU threads: 8; OS: macOS 26.4.1; UI render: Skia/Raster; VCL: osx Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded 1. Open this issue's test CSV (attached) using Calc. 2. Text Import settings (default) ~ - Character set = Automatic (Unicode UTF-8) - Locale = Default - English (UK) - From row = 1 - Separator options = Detected (,) - Format quoted fields as text = Checked √ - Detect special numbers = Checked √ 3. After importing, enter either cell `B4` or `B5` by double-clicking. 4. Observe that the single-apostrophe (') has been *doubled*, i.e. a second single-apostrophe has been inserted in the cell contents. (For clarity: single-apostrophe is U+0027). Expected Results: - When importing a field prefixed with a single-apostrophe, it should be imported as is. There should just be the one character as present in the data. In the test case file: - Cell `B4` should contain: '01 - Cell `B5` should contain: '1 Actual Results: - The single-apostrophe character is doubled. In the test case file: - Cell `B4` after import contains: ''01 - Cell `B5` after import contains: ''1 Background: Although not standardised, the single-apostrophe may be used to denote that a field should be treated as text (literal). It is not generally displayed but hidden as a field marker- dependant on implementation and user preference. -- You are receiving this mail because: You are the assignee for the bug.
