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.
10.4.2, 10.2, 13.4.2
"10.4.2", 10.2, 13.4.2
'10.4.2', 10.2, 13.4.2
'10.4.2, 10.2, 13.4.2
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
