waleskim / linqtoexcel

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

Cannot process column headers with alt-enter breaks #6

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Create an excel column with a header that splits into multiple lines by 
using the alt+enter keystroke to force a line break.
2. Try to do an AddMapping using either a \n or \x0A where the alt+enters 
would be expected.
3. The query fails with "No value given for one or more required 
parameters."

What is the expected output? What do you see instead?
Would expect query to work. Tried to do debugging by inheriting from 
LinqToExcel.Tests.SQLLogStatements_Helper, doing a call to 
InstantiateLogger(); ClearLogEvents(); prior to query and then calling 
Console.WriteLine(GetSQLStatement()); just after query, but it appears 
log4net is not capturing anything, thus I have no way to see the exact SQL 
being formatted?

What version of the product are you using? On what operating system?
Occurs with both the r24 download and if I build direct from the svn 
source. Windows XP SP3 full patched.

Please provide any additional information below.

Original issue reported on code.google.com by wpfeff...@gmail.com on 13 Sep 2009 at 3:04

GoogleCodeExporter commented 9 years ago
Insert an underscore "_" in place of alt+enter. For example, a 2 line column 
header 
with "First" on top and "Name" on bottom would have a mapping of 
repo.AddMapping(x 
=> x.FirstName, "First_Name")

Original comment by paulyo...@gmail.com on 14 Sep 2009 at 4:10