Menu

#2812 (ok 3.1.2) Commas for CSV Excel 2008 for Mac

3.1.1
fixed
1
2013-06-11
2008-12-18
No

Exporting to CSV for Excel (Mac is all I have tried)
generates a file with ";" delimiting not ",". Can this be fixed?

An example output file is attached...

Stuart

Discussion

  • Stuart Chalk

    Stuart Chalk - 2008-12-18

    CSV Export file

     
  • Marc Delisle

    Marc Delisle - 2008-12-18

    This file with ";" does not load correctly in Excel 2003 for Mac?

     
  • Marc Delisle

    Marc Delisle - 2008-12-18
    • assigned_to: nobody --> lem9
     
  • Stuart Chalk

    Stuart Chalk - 2008-12-19

    Actually I am trying to import it into Excel 2008 for Mac. OSX recognizes the .csv extension and launches Excel but the data is not separated into columns because the delimiter is a semicolon not a comma. If I change the extension to ".txt" I can open the file from within Excel and choose the semicolon as the delimiter and it puts the data in columns fine.

     
  • Marc Delisle

    Marc Delisle - 2008-12-19

    Choosing "windows" in the drop-down for excel edition will produce commas. So we should add a choice "Excel 2008 for Mac" that also produces commas.

     
  • Marc Delisle

    Marc Delisle - 2008-12-25
    • priority: 5 --> 1
    • summary: CSV export (for Excel) files not CSV --> (ok 3.1.2) Commas for CSV Excel 2008 for Mac
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2008-12-25

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2009-01-19
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     
MongoDB Logo MongoDB