https://bugs.documentfoundation.org/show_bug.cgi?id=168364
--- Comment #5 from ady <[email protected]> --- For a bug report about importing CSV, we need: 1._ a sample CSV (attachment 202798); 2._ the complete set of options that were used in the Text Import dialog (not specified in this report); 3._ the unexpected result, if possible as ods file; 4._ the expected result, if possible as ods file. Someone might think that prior comments are enough and clear; they are not. The fact that one outcome reflects the description of this report does not mean that there is a bug for sure. For instance, using different Text Import options would return a different outcome. We need the expected outcome, as clear as possible. An example of uncertainty / lack of clarity is that the provided sample csv file contains both "commas" and "apostrophes" (sometimes known as single quotation marks, and sometimes known as "inverted commas". This makes the description in comment 0 slightly ambiguous. It is not 100% clear what the outcome should be, even when the potential duplication of characters could be reproduced in relation to the single quotation mark, not the normal comma character. For instance, if I leave the comma in the CSV as part of the resulting cells (not as a separator / delimiter), then the double apostrophe is not seen in the resulting cells. There are several Text Import options that could modify the outcome in many ways. I can think of at least 3 options that could / should alter the result, so any (or all) of the 3 could be the source of the problem / bug. We don't know whether the single quotation mark in the CSV is supposed to be a Text marker only, or it should be part of the real content of the resulting cell. The same goes for the double quotation mark. All these factors are not only relevant for the report itself, but are also very important in order to create a unit test (to avoid repeating the problem in the future). In other words, these factors are crucial for developers to be able to solve any Text Import bug. We need additional specific details. Additionally, Eike is no longer active, so we need some other developer to take a look at this (preferably with all the required details provided first). -- You are receiving this mail because: You are the assignee for the bug.
