It'll be the same with newer versions. Basically, "csv" is an underspecified format. Everyone has their own idea of what a csv is supposed to mean. Every choice we make is "right" for some people, but "wrong" for someone else.
You can use the configurable text importer to impose your own opinion. Select the "Text" format for the column in question. But the best solution is to avoid csv altogether. Morten On Thu, Mar 27, 2014 at 12:08 PM, Rex Couture <[email protected]> wrote: > I have a problem importing a text string. In the attached .csv file the > string "10.4.2" is imported incorrectly as a date, and once imported, there > does not seem to be a way to recover the correct text. (I just open the > file, and it is imported automatically.) LibreOffice and Excel for Windows > import it as text, as intended. The only workaround I have found is to > prefix it with an apostrophe ("'"), which has the disadvantage that an > unwanted apostrophe appears in those spreadsheets. > > Is there another way to import this as text--preferably automatically? Is > this a bug? > > The problem occurs in versions 1.10.9 for Windows and 1.10.17 for Linux. I > have not tried 1.12 yet. > > _______________________________________________ > gnumeric-list mailing list > [email protected] > https://mail.gnome.org/mailman/listinfo/gnumeric-list > _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list
