search

codeice / linqtoexcel

Automatically exported from code.google.com/p/linqtoexcel
0 stars 0 forks source link

CRLF in cell causes Cell not be read #102

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1.create 2 rows with three columnss
2.first row enter Apple,58102,Pie
3.second row enter Pear,58103[carriage return, linefeed],Sleep

What is the expected output? What do you see instead?
Expect:
Apple, 58102, Pie
Pear, 58103, Sleep

See:
Apple, 58102, Pie,
Pear, null, Sleep

What version of the product are you using? On what operating system?
1.7.1 Windows 7 

Please provide any additional information below.
First problem I've had - otherwise this has been awesome!

Original issue reported on code.google.com by dwgor...@gmail.com on 29 Jan 2014 at 7:18

GoogleCodeExporter commented 8 years ago 
Just wanted to add more context, the excel I was troubleshooting was edited by 
a mac. So I believe that is the main culprit to getting the crlf whitespace.

Original comment by dwgor...@gmail.com on 29 Jan 2014 at 10:45