Comments (3)
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.
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.
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)
- doesn't seem to recoginse end of line properly in some cases. HOT 1
- CR line ending are not well treated HOT 1
- Typo in basic-usage.html (fixed in 0.8.0) HOT 2
- Enhancement: Parse CSV in a thread using settimeout HOT 3
- 배열의 기본 속성값(remove)이 포함 됩니다. HOT 1
- Karma test fails - HOT 2
- Failures on test.html file HOT 2
- colNum not reset when onParseValue callback called
- Export $ globally in browser when not already set
- CSVDataError: Illegal State - Only in IE HOT 3
- Using Zurb Foundation 3 causing an error HOT 3
- $.csv.toObjects return garbage value HOT 3
- Parse doesn't handle quotes in the CSV, even if escaped HOT 3
- Hooks relying on a return value of false to skip entries makes parsing values that resolve to false impossible
- Uncaught ReferenceError: require is not defined
- Generate Motion chart HOT 1
- Options arg not really optional? HOT 2
- TypeError: csv.replace is not a function
- Data Format
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from jquery-csv.