Tag Archives: MSDN Code Gallery

Excel Financial Functions for .NET

Luca Bolognese recently posted a new library that makes Excel’s financial functions available through .NET managed code without going through Excel! This is excellent news for anyone working on a financial or LOB app. Luca created the library to mimic the Excel functions, including errors or bugs, in F#. The release comes in two versions: a smaller .dll that will run on an installed F# installation and a larger, stand alone .dll for those who do not wish to deploy F#.

Check it out at the MSDN Code Gallery.

WPF DataBinding: Nullable Value Types

We recently ran into what appeared to be an inconsistency in WPF’s data binding. When you attempt to data bind to a nullable value type with a value of null, WPF appears to drop the binding. Using an identity converter and several other methods only told us what we already knew, so I did a little research this morning.

hortha posted a solution with examples to the MSDN Code Gallery that we tried this morning. His solution works beautifully. Several commenters noted that VS2008 SP1 is supposed to fix this without converters, but no one seems to have tried it.