So, if there anyways to get OO to behave like MS Excel in this case? I need OO to behave like Excel because I have scripts that run of the 'Excel-CSV' format. I can't change my field delimiter to something else beside commas and I can't have double quotes all over the place. Two, if I don't use any text delimiter, then I don't get any double-quotes, but the strings of text that originally had 'commas' from the XLS format are now impossible to make out because my field delimiter is 'commas'. One, if I use 'double quotes' as a text delimiter, the double-quotes show up around every text string separated by the field delimiter (commas in my case). If I save the same file using OpenOffice, I can only see two options.
The question is, when saving an XLS file in CSV format using Microsoft Excel, if there are 'commas' in the some of the XLS cells, you will end up with 'double quotes' around the string of text in those cells in the CSV format. This is a different question, but since the topic is CSV files, it should be relevant.
