When you import this file into Calc, here is what you get with the current version:
As you can see, most of the fields got converted to dates. You get the same results even if those individual cells are not quoted, because Calc’s current csv import filter doesn’t make any distinction between quoted and unquoted fields in terms of data types.

When you import this file using the new option, you get this instead:

Now, all quoted fields are imported as text, with no surprise conversion. Plain and simple. :-)

4 Responses to It’s text when it’s quoted, stupid!

This is really a very nice feature and i think it will solve many problems of our csv imports. Is there a chance that we can set this option as a default in the openoffice config. Because it will be difficult to train all of our staff to select this option on every import. Thanks in advance for your great featurs like the solver and this little gem.