Workaround needed for EPPlus' AutoFilter bug

[eobeda]

While trying to add support for anonymous types, I found an issue with the underlying Excel library that you might want to address with a workaround. It seams that version 3.1.3.0 of the EPPlus library does not support toggling of it's AutoFilter property. If you touch it, it will be set to true.

The quickest way to reproduce the issue is to set the autoFilter property of the XlsxMediaTypeFormatter to false in the sample code:

var formatter = new XlsxMediaTypeFormatter(
autoFilter: false, < ===== HERE
freezeHeader: true,

and run the sample. Upon opening the Excel spreadsheet, you'll see the filter dropdowns are still be displayed.

One possible workaround would be to wrap the call in an if statement:
if (AutoFilter) cells.AutoFilter = true;
(at Line 264 of XlsxMediaTypeFormatter.cs)

Hope this helps improve an already great formatter.
Ed

PS: Any interest in anonymous type support with optional per view configs ??

[jordangray]

Thanks for reporting this! I'll see if I can reproduce it tomorrow; it should be fairly easy to work around exactly as you say.

(Way behind on my work for milestone 2, but one priority is considering more flexible configuration mechanisms—see e.g. #12. The particular avenue described there probably wouldn't work for anonymous types, but I'm open to ideas! 😄)

[jordangray]

Sorry for taking forever on this; life (and lack of an MSDN account) intervened! Closed in commit 39491bf.

BTW, would you like me to ping you when I'm ready to look at config for anonymous types?