https://bugs.documentfoundation.org/show_bug.cgi?id=168364
--- Comment #7 from ady <[email protected]> --- (In reply to ace_dent from comment #6) > 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. Sure, but you have not specified that in the Text Import dialog. Some of the options that you have not mentioned here are: _ String delimiter; _ Merge delimiters; _ Trim Spaces; _ Testing the possibility of marking more than one character as delimiter in the Text Import dialog (e.g. marking not only the comma (",") character but also the apostrophe ("'") too, or even the double quotation marks too); _ Column type (Standard vs Text). You have also not mentioned how the last row of the csv should be imported (i.e. should the number 2 be imported as numeric value, as text, by itself, or including the double quotation marks as part of the resulting content). I am not saying that there is no bug. I am saying that the results can still be different, depending on the options used in the Text Import dialog, so a developer trying to specifically detect where exactly the bug could be located, and how to produce a unit test (that would not negatively impact other cases), will confront an ambiguous situation. Moreover, there could be a set of options that would return the desired result; just with a different set than what a typical user would use. In fact, I can actually achieve what seems to be the result that you are looking for. Unfortunately, Eike is no longer active, so we don't really know whether he would consider that his commit introduced a regression, or instead would suggest using a different set of options (as I did). -- You are receiving this mail because: You are the assignee for the bug.
