Code Monkey home page Code Monkey logo

Comments (3)

GoogleCodeExporter avatar GoogleCodeExporter commented on August 21, 2024
Because Excel for mac uses CR (carriage return) as the default line line ending 
for formatting. A convention that even Mac quit using when they transitioned 
from OS9 to OSX.

I don't know if that's the cause of your problem but the code available in the 
repository properly handles old mac style line endings.

I'll be dropping a new release soon that should include the fix. I'll try it 
with your sample to see if it that's the issue.

Original comment by [email protected] on 15 Dec 2014 at 5:12

from jquery-csv.

GoogleCodeExporter avatar GoogleCodeExporter commented on August 21, 2024
I noticed indeed that it's just a difference between Excel for Mac and Excel 
for Windows; when you save files in Excel for Mac you can choose a specific 
format that is compatible, but it's not the default option. The default option, 
even after the latest updates, uses different line endings then Excel for 
Windows does. So it's not just old Mac's, it's also present on OS X Yosemity 
with the latest Office for Mac release. 

If I can be of any assistance, I would be glad to help out and/or test it for 
you. Thanks so much for looking into it!

Original comment by [email protected] on 15 Dec 2014 at 10:10

from jquery-csv.

GoogleCodeExporter avatar GoogleCodeExporter commented on August 21, 2024
Thanks for chiming in. Sorry if I wasn't clear. What I meant was...

Even on the most recent versions of Excel for Mac, the default for line endings 
is CR. Despite CR being obsolete since the transition from OS9 to OSX. OSX -- 
as a Unix based system -- uses LF as the default line ending for everything.

I'm not sure if the Microsoft devs are just ignorant about OSX conventions or 
if they wrote it that way intentionally as a tongue-in-cheek FU to Apple. 
Either way, it causes a lot of problems for people who are blissfully ignorant 
of the aftermath caused by the OS line ending wars.

If only MS Office had a public bug tracker. If only...

Either way, the source available in the repository (ie not the latest release) 
should contain a fix that properly handles CSV source with CR line endings.

Original comment by [email protected] on 15 Dec 2014 at 10:19

from jquery-csv.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.