Issue 62 in linqtoexcel: Transformation does not accept a null result?

[linqt...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 62 by tim.sirm...@gmail.com: Transformation does not accept a
null result?
http://code.google.com/p/linqtoexcel/issues/detail?id=62

What steps will reproduce the problem?

excel.AddMapping<Order>(o => o.StringProperty, "Header", val => null);

var results = (from o in excel.Worksheet<Order>(0)
where o.AnotherProperty != null
select o).ToList();

What is the expected output? What do you see instead?

I expect the StringProperty of each object to contain the value null.
Instead when the query is executed a NullReferenceException is thrown.

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

1.6.0.0 from NuGet
Windows 7 x64 (Using x86 binary)

Please provide any additional information below.

This is a cut down example, but displays the core of my problem.

Unless I am missing something, it seems as though if the result of the
Func<string,object> transformation returns a null value, even though the
property I am mapping to is a string, an exception is raised.

[linqt...@googlecode.com]

Updates:
Status: Accepted

Comment #1 on issue 62 by paulyo...@gmail.com: Transformation does not

accept a null result?
http://code.google.com/p/linqtoexcel/issues/detail?id=62

Thanks Tim, I'll be looking into this.

[linqt...@googlecode.com]

Updates:
Status: Fixed

Comment #2 on issue 62 by paulyo...@gmail.com: Transformation does not

accept a null result?
http://code.google.com/p/linqtoexcel/issues/detail?id=62

This is fixed in version 1.6.2

[linqt...@googlecode.com]

Comment #3 on issue 62 by tim.sirm...@gmail.com: Transformation does not

accept a null result?
http://code.google.com/p/linqtoexcel/issues/detail?id=62

Thank you, I shall try out the new build.